Subversion Repositories DevTools

Rev

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

Rev 5080 Rev 5098
Line 12... Line 12...
12 
        rc.SDKTAG_ID,
 12 
        rc.SDKTAG_ID,
13 
 
 13 
 
14 
        rel.proj_id,
14 
        rel.proj_id,
15 
        rel.rtag_id,
15 
        rel.rtag_id,
16 
        rel.rtag_name,
 16 
        rel.rtag_name,
17 
        rel.product_state_used
 17 
        rel.product_state_used,
- 
 
 18 
 
- 
 
 19 
        nvl2(peg.pv_id, 1, 0 ) as pegged
18 
 
 20 
 
19 
   FROM RELEASE_CONTENT rc,
 21 
   FROM RELEASE_CONTENT rc,
20 
        release_tags rel,
 22 
        release_tags rel,
21 
 
 - 
 
- 
 
 23 
        pegged_versions peg,
22 
   		USERS ins,
 24 
   		USERS ins,
23 
        (
25 
        (
24 
         SELECT Count(*) AS USED_COUNT
 26 
         SELECT Count(*) AS USED_COUNT
25 
           FROM PACKAGE_DEPENDENCIES dep
 27 
           FROM PACKAGE_DEPENDENCIES dep
26 
          WHERE dep.DPV_ID = :PV_ID
28 
          WHERE dep.DPV_ID = :PV_ID
27 
        ) used
 29 
        ) used
28 
 WHERE rc.RTAG_ID = :RTAG_ID
30 
 WHERE rc.RTAG_ID = :RTAG_ID
29 
   AND rc.PV_ID = :PV_ID
 31 
   AND rc.PV_ID = :PV_ID
30 
   AND rc.INSERTOR_ID = ins.USER_ID
 32 
   AND rc.INSERTOR_ID = ins.USER_ID
31 
   AND rel.rtag_id (+) = :RTAG_ID
 33 
   AND rel.rtag_id (+) = :RTAG_ID
- 
 
 34 
   AND peg.rtag_id(+) = rc.RTAG_ID
- 
 
 35 
   AND peg.pv_id(+) =  rc.PV_ID
- 
 
 36 
 
32 
 
 37