Subversion Repositories DevTools

Rev

Rev 6642 | Go to most recent revision | 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,
23
        nvl2(ar.pv_id, 1, 0 ) as advisory_ripple
5098 dpurdie 24
 
119 ghuddy 25
   FROM RELEASE_CONTENT rc,
4687 dpurdie 26
        release_tags rel,
5098 dpurdie 27
        pegged_versions peg,
6642 dpurdie 28
        advisory_ripple ar,
29
        views vi,
119 ghuddy 30
   		USERS ins,
31
        ( 
32
         SELECT Count(*) AS USED_COUNT
33
           FROM PACKAGE_DEPENDENCIES dep
6642 dpurdie 34
          WHERE dep.DPV_ID = :PV_ID
119 ghuddy 35
        ) used
36
 WHERE rc.RTAG_ID = :RTAG_ID  
37
   AND rc.PV_ID = :PV_ID
4687 dpurdie 38
   AND rc.INSERTOR_ID = ins.USER_ID
39
   AND rel.rtag_id (+) = :RTAG_ID
5098 dpurdie 40
   AND peg.rtag_id(+) = rc.RTAG_ID
41
   AND peg.pv_id(+) =  rc.PV_ID
6642 dpurdie 42
   AND ar.pv_id(+) =  rc.PV_ID
6681 dpurdie 43
   AND ar.rtag_id(+) =  rc.RTAG_ID
6642 dpurdie 44
   AND vi.view_id(+) =  rc.base_view_id