Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1
/* Package Release Details */
2
 SELECT rc.insert_stamp, 
3
 	    ins.full_name AS insertor, 
4
        ins.user_email AS insertor_email,
4687 dpurdie 5
 
6
        used.USED_COUNT,
7
 
119 ghuddy 8
        rc.BASE_VIEW_ID,
9
        rc.PKG_STATE,
10
        rc.DEPRECATED_STATE,
4687 dpurdie 11
        rc.PRODUCT_STATE,
12
 
13
        rel.proj_id, 
14
        rel.rtag_id, 
15
        rel.rtag_name,
16
        rel.product_state_used
17
 
119 ghuddy 18
   FROM RELEASE_CONTENT rc,
4687 dpurdie 19
        release_tags rel,
20
 
119 ghuddy 21
   		USERS ins,
22
        ( 
23
         SELECT Count(*) AS USED_COUNT
24
           FROM PACKAGE_DEPENDENCIES dep
25
          WHERE dep.DPV_ID = :PV_ID                  
26
        ) used
27
 WHERE rc.RTAG_ID = :RTAG_ID  
28
   AND rc.PV_ID = :PV_ID
4687 dpurdie 29
   AND rc.INSERTOR_ID = ins.USER_ID
30
   AND rel.rtag_id (+) = :RTAG_ID
31