Subversion Repositories DevTools

Rev

Rev 6440 | Rev 6681 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6440 Rev 6642
Line 4... Line 4...
4 
        ins.user_email AS insertor_email,
 4 
        ins.user_email AS insertor_email,
5 
 
 5 
 
6 
        used.USED_COUNT,
 6 
        used.USED_COUNT,
7 
 
 7 
 
8 
        rc.BASE_VIEW_ID,
 8 
        rc.BASE_VIEW_ID,
- 
 
 9 
        vi.view_name,
9 
        rc.PKG_STATE,
 10 
        rc.PKG_STATE,
10 
        rc.DEPRECATED_STATE,
 11 
        rc.DEPRECATED_STATE,
11 
        rc.PRODUCT_STATE,
 12 
        rc.PRODUCT_STATE,
12 
        rc.SDKTAG_ID,
 13 
        rc.SDKTAG_ID,
13 
        rc.RIPPLE_STOP,
 14 
        rc.RIPPLE_STOP,
Line 16... Line 17...
16 
        rel.proj_id,
17 
        rel.proj_id,
17 
        rel.rtag_id,
18 
        rel.rtag_id,
18 
        rel.rtag_name,
 19 
        rel.rtag_name,
19 
        rel.product_state_used,
 20 
        rel.product_state_used,
20 
 
 21 
 
21 
        nvl2(peg.pv_id, 1, 0 ) as pegged
 22 
        nvl2(peg.pv_id, 1, 0 ) as pegged,
- 
 
 23 
        nvl2(ar.pv_id, 1, 0 ) as advisory_ripple
22 
 
 24 
 
23 
   FROM RELEASE_CONTENT rc,
 25 
   FROM RELEASE_CONTENT rc,
24 
        release_tags rel,
 26 
        release_tags rel,
25 
        pegged_versions peg,
 27 
        pegged_versions peg,
- 
 
 28 
        advisory_ripple ar,
- 
 
 29 
        views vi,
26 
   		USERS ins,
 30 
   		USERS ins,
27 
        (
31 
        (
28 
         SELECT Count(*) AS USED_COUNT
 32 
         SELECT Count(*) AS USED_COUNT
29 
           FROM PACKAGE_DEPENDENCIES dep
 33 
           FROM PACKAGE_DEPENDENCIES dep
30 
          WHERE dep.DPV_ID = :PV_ID
34 
          WHERE dep.DPV_ID = :PV_ID
31 
        ) used
 35 
        ) used
32 
 WHERE rc.RTAG_ID = :RTAG_ID
36 
 WHERE rc.RTAG_ID = :RTAG_ID
33 
   AND rc.PV_ID = :PV_ID
 37 
   AND rc.PV_ID = :PV_ID
34 
   AND rc.INSERTOR_ID = ins.USER_ID
 38 
   AND rc.INSERTOR_ID = ins.USER_ID
35 
   AND rel.rtag_id (+) = :RTAG_ID
 39 
   AND rel.rtag_id (+) = :RTAG_ID
36 
   AND peg.rtag_id(+) = rc.RTAG_ID
 40 
   AND peg.rtag_id(+) = rc.RTAG_ID
37 
   AND peg.pv_id(+) =  rc.PV_ID
 41 
   AND peg.pv_id(+) =  rc.PV_ID
38 
 
 - 
 
39 
 
 - 
 
- 
 
 42 
   AND ar.pv_id(+) =  rc.PV_ID
- 
 
 43 
   AND vi.view_id(+) =  rc.base_view_id