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,
5080 dpurdie 12 
        rc.SDKTAG_ID,
4687 dpurdie 13 
 
14 
        rel.proj_id,
15 
        rel.rtag_id,
16 
        rel.rtag_name,
17 
        rel.product_state_used
18 
 
119 ghuddy 19 
   FROM RELEASE_CONTENT rc,
4687 dpurdie 20 
        release_tags rel,
21 
 
119 ghuddy 22 
   		USERS ins,
23 
        (
24 
         SELECT Count(*) AS USED_COUNT
25 
           FROM PACKAGE_DEPENDENCIES dep
26 
          WHERE dep.DPV_ID = :PV_ID
27 
        ) used
28 
 WHERE rc.RTAG_ID = :RTAG_ID
29 
   AND rc.PV_ID = :PV_ID
4687 dpurdie 30 
   AND rc.INSERTOR_ID = ins.USER_ID
31 
   AND rel.rtag_id (+) = :RTAG_ID
32