Subversion Repositories DevTools

Rev

Rev 6681 | 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,
4687 dpurdie 5 
 
6 
        used.USED_COUNT,
7 
 
119 ghuddy 8 
        rc.BASE_VIEW_ID,
6642 dpurdie 9 
        vi.view_name,
119 ghuddy 10 
        rc.PKG_STATE,
11 
        rc.DEPRECATED_STATE,
4687 dpurdie 12 
        rc.PRODUCT_STATE,
5080 dpurdie 13 
        rc.SDKTAG_ID,
6440 dpurdie 14 
        rc.RIPPLE_STOP,
15 
        rc.PERSIST_RIPPLE_STOP,
4687 dpurdie 16 
 
17 
        rel.proj_id,
18 
        rel.rtag_id,
19 
        rel.rtag_name,
5098 dpurdie 20 
        rel.product_state_used,
4687 dpurdie 21 
 
6642 dpurdie 22 
        nvl2(peg.pv_id, 1, 0 ) as pegged,
7468 dpurdie 23 
        nvl2(ar.pv_id, 1, 0 ) as advisory_ripple,
5098 dpurdie 24 
 
7468 dpurdie 25 
        nvl(rc.in_manifest, 'N') as inManifest,
26 
        nvl(rel.s3manifest, 'N') as s3ManifestEnabled
27 
 
119 ghuddy 28 
   FROM RELEASE_CONTENT rc,
4687 dpurdie 29 
        release_tags rel,
5098 dpurdie 30 
        pegged_versions peg,
6642 dpurdie 31 
        advisory_ripple ar,
32 
        views vi,
119 ghuddy 33 
   		USERS ins,
34 
        (
35 
         SELECT Count(*) AS USED_COUNT
36 
           FROM PACKAGE_DEPENDENCIES dep
6642 dpurdie 37 
          WHERE dep.DPV_ID = :PV_ID
119 ghuddy 38 
        ) used
39 
 WHERE rc.RTAG_ID = :RTAG_ID
40 
   AND rc.PV_ID = :PV_ID
4687 dpurdie 41 
   AND rc.INSERTOR_ID = ins.USER_ID
42 
   AND rel.rtag_id (+) = :RTAG_ID
5098 dpurdie 43 
   AND peg.rtag_id(+) = rc.RTAG_ID
44 
   AND peg.pv_id(+) =  rc.PV_ID
6642 dpurdie 45 
   AND ar.pv_id(+) =  rc.PV_ID
6681 dpurdie 46 
   AND ar.rtag_id(+) =  rc.RTAG_ID
6642 dpurdie 47 
   AND vi.view_id(+) =  rc.base_view_id