Subversion Repositories DevTools

Rev

Rev 5939 | Rev 5947 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
5939 dpurdie 1 
-- UsedByThisProject.sql
5946 dpurdie 2 
-- Generate detailed data for projects that use this package version
3 
--  Within an PROJECT specified by :PROJ_ID
4 
--  Match control via :MATCH
5 
--    :MATCH 0  - Match any  package name
6 
--    :MATCH 1  - Match Package name and Project Suffix
7 
--    :MATCH 2  - Match exactly the package. Name, Version and Suffix
119 ghuddy 8 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
5939 dpurdie 9 
       rt.RTAG_ID,
10 
       rt.RTAG_NAME,
11 
       rt.OFFICIAL,
12 
       ev.ENV_AREA,
13 
       pv.PV_ID,
14 
       pkg.PKG_NAME,
15 
       pv.PKG_VERSION,
16 
       pv.DLOCKED,
17 
       usr.FULL_NAME,
18 
       usr.USER_EMAIL,
19 
       pv.MODIFIED_STAMP
119 ghuddy 20 
  FROM ENVIRONMENT_VIEW ev,
5939 dpurdie 21 
       PACKAGE_VERSIONS pv,
22 
       PACKAGES pkg,
23 
       RELEASE_TAGS rt,
24 
       USERS usr
119 ghuddy 25 
 WHERE ev.PV_ID = pv.PV_ID
26 
   AND pv.PKG_ID = pkg.PKG_ID
27 
   AND ev.RTAG_ID = rt.RTAG_ID
28 
   AND pv.MODIFIER_ID = usr.USER_ID
29 
   AND rt.PROJ_ID = :PROJ_ID
5946 dpurdie 30 
   AND (ev.PV_ID  = :PV_ID OR :MATCH != 2)
31 
   AND (NVL(pv.v_ext,'LINK') in ( select NVL(v_ext,'LINK') from package_versions where pv_id = :PV_ID ) OR :MATCH = 2 OR :MATCH = 0)
32 
   AND (pv.PKG_ID in ( select pkg_id from package_versions where pv_id = :PV_ID) OR :MATCH = 2)
33 
  ORDER BY rt.RTAG_ID DESC
5939 dpurdie 34