Subversion Repositories DevTools

Rev

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

Rev 5939 Rev 5946
Line 1... Line 1...
1 
-- UsedByThisProject.sql
 1 
-- UsedByThisProject.sql
2 
-- Generate detailed data for projects that use a package.suffix
 2 
-- Generate detailed data for projects that use this package version
3 
-- It can generate two types of data
 3 
--  Within an PROJECT specified by :PROJ_ID
- 
 
 4 
--  Match control via :MATCH
4 
--  PV_ID == -1 -- Any package.suffix
 5 
--    :MATCH 0  - Match any  package name
- 
 
 6 
--    :MATCH 1  - Match Package name and Project Suffix
5 
--  PV_ID != -1 -- Only package that match this specific package-version
 7 
--    :MATCH 2  - Match exactly the package. Name, Version and Suffix
6 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
 8 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
7 
       rt.RTAG_ID,
 9 
       rt.RTAG_ID,
8 
       rt.RTAG_NAME,
 10 
       rt.RTAG_NAME,
9 
       rt.OFFICIAL,
 11 
       rt.OFFICIAL,
10 
       ev.ENV_AREA,
 12 
       ev.ENV_AREA,
Line 19... Line 21...
19 
       PACKAGE_VERSIONS pv,
 21 
       PACKAGE_VERSIONS pv,
20 
       PACKAGES pkg,
 22 
       PACKAGES pkg,
21 
       RELEASE_TAGS rt,
 23 
       RELEASE_TAGS rt,
22 
       USERS usr
 24 
       USERS usr
23 
 WHERE ev.PV_ID = pv.PV_ID
 25 
 WHERE ev.PV_ID = pv.PV_ID
24 
   AND pv.PKG_ID = :PKG_ID
 - 
 
25 
   AND NVL( pv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
 - 
 
26 
   AND pv.PKG_ID = pkg.PKG_ID
 26 
   AND pv.PKG_ID = pkg.PKG_ID
27 
   AND ev.RTAG_ID = rt.RTAG_ID
 27 
   AND ev.RTAG_ID = rt.RTAG_ID
28 
   AND pv.MODIFIER_ID = usr.USER_ID
 28 
   AND pv.MODIFIER_ID = usr.USER_ID
29 
   AND rt.PROJ_ID = :PROJ_ID
 29 
   AND rt.PROJ_ID = :PROJ_ID
30 
   AND (ev.pv_id = :PV_ID OR :PV_ID = -1)
 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)
31 
 ORDER BY rt.RTAG_ID DESC
33 
  ORDER BY rt.RTAG_ID DESC
32 
 
 34