Subversion Repositories DevTools

Rev

Rev 5929 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5929 Rev 6612
Line 4... Line 4...
4 
       pkg.pkg_name,
4 
       pkg.pkg_name,
5 
       pv.pkg_version,
5 
       pv.pkg_version,
6 
       pv.v_ext,
6 
       pv.v_ext,
7 
       pv.modified_stamp,
7 
       pv.modified_stamp,
8 
       pv.modifier_id,
 8 
       pv.modifier_id,
9 
       umd.user_name modifier,
9 
       umd.full_name modifier,
10 
       umd.user_email AS modifier_email,
10 
       umd.user_email AS modifier_email,
11 
       pv.created_stamp,
 11 
       pv.created_stamp,
12 
       pv.creator_id,
 12 
       pv.creator_id,
13 
       ucr.user_name AS creator,
13 
       ucr.full_name AS creator,
14 
       ucr.user_email AS creator_email,
 14 
       ucr.user_email AS creator_email,
15 
       pv.owner_id,
15 
       pv.owner_id,
16 
       onr.full_name AS owner,
16 
       onr.full_name AS owner,
17 
       onr.user_email AS owner_email,
17 
       onr.user_email AS owner_email,
18 
       pv.dlocked,
 18 
       pv.dlocked,
Line 41... Line 41...
41 
 WHERE pkg.pkg_id = pv.pkg_id
 41 
 WHERE pkg.pkg_id = pv.pkg_id
42 
   AND pv.last_pv_id = lpv.pv_id (+)
 42 
   AND pv.last_pv_id = lpv.pv_id (+)
43 
   AND umd.user_id (+) = pv.modifier_id
 43 
   AND umd.user_id (+) = pv.modifier_id
44 
   AND ucr.user_id (+) = pv.creator_id
 44 
   AND ucr.user_id (+) = pv.creator_id
45 
   AND onr.user_id (+) = pv.owner_id
 45 
   AND onr.user_id (+) = pv.owner_id
46 
   AND pv.pv_id = :PV_ID
- 
 
47 

            46
            
   AND pv.pv_id = :PV_ID 

          

          

            -
            
 

            47
            
 

          

          

            -
            
 

            48