Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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

            29
            
   AND rc.INSERTOR_ID = ins.USER_ID

          

          

            -
            
 

            30
            
   AND rel.rtag_id (+) = :RTAG_ID

          

          

            -
            
 

            31
            
 

          

          

            -
            
 

            32