Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | 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,
5 
        rc.BASE_VIEW_ID,
6 
        used.USED_COUNT,
7 
        rc.PKG_STATE,
8 
        rc.DEPRECATED_STATE,
9 
        rc.PRODUCT_STATE
10 
   FROM RELEASE_CONTENT rc,
11 
   		USERS ins,
12 
        (
13 
         SELECT Count(*) AS USED_COUNT
14 
           FROM PACKAGE_DEPENDENCIES dep
15 
          WHERE dep.DPV_ID = :PV_ID
16 
        ) used
17 
 WHERE rc.RTAG_ID = :RTAG_ID
18 
   AND rc.PV_ID = :PV_ID
19 
   AND rc.INSERTOR_ID = ins.USER_ID