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 
-- UsedByProjects.sql
5946 dpurdie 2 
-- Generate summary data for projects that use this package version
3 
--  Match control via :MATCH
4 
--    :MATCH 0  - Match any  package name
5 
--    :MATCH 1  - Match Package name and Project Suffix
6 
--    :MATCH 2  - Match exactly the package. Name, Version and Suffix
119 ghuddy 7 
SELECT proj.PROJ_ID,
5939 dpurdie 8 
       proj.PROJ_NAME,
9 
       COUNT(ev.RTAG_ID) AS USED_COUNT
119 ghuddy 10 
  FROM ENVIRONMENT_VIEW ev,
5939 dpurdie 11 
       PACKAGE_VERSIONS pv,
12 
       RELEASE_TAGS rt,
13 
       PROJECTS proj
119 ghuddy 14 
 WHERE ev.PV_ID = pv.PV_ID
15 
   AND ev.RTAG_ID = rt.RTAG_ID
16 
   AND rt.PROJ_ID = proj.PROJ_ID
5946 dpurdie 17 
   AND (ev.PV_ID  = :PV_ID OR :MATCH != 2)
18 
   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)
19 
   AND (pv.PKG_ID in ( select pkg_id from package_versions where pv_id = :PV_ID) OR :MATCH = 2)
20 
GROUP BY proj.PROJ_ID, proj.PROJ_NAME
21 
ORDER BY UPPER(proj.PROJ_NAME)
22