Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 5939
Line 1... Line 1...
1 
 /* Used By Projects */
 1 
-- UsedByProjects.sql
- 
 
 2 
-- Generate summary data for projects that use a package.suffix
- 
 
 3 
-- It can generate two types of data
- 
 
 4 
-- PV_ID == -1 -- Any package.suffix
- 
 
 5 
-- PV_ID != -1 -- Only package that match this specific package-version
2 
SELECT proj.PROJ_ID,
 6 
SELECT proj.PROJ_ID,
3 
	   proj.PROJ_NAME,
 7 
       proj.PROJ_NAME,
4 
	   COUNT(ev.RTAG_ID) AS USED_COUNT
8 
       COUNT(ev.RTAG_ID) AS USED_COUNT
5 
  FROM ENVIRONMENT_VIEW ev,
 9 
  FROM ENVIRONMENT_VIEW ev,
6 
  	   PACKAGE_VERSIONS pv,
 10 
       PACKAGE_VERSIONS pv,
7 
	   RELEASE_TAGS rt,
 11 
       RELEASE_TAGS rt,
8 
	   PROJECTS proj
 12 
       PROJECTS proj
9 
 WHERE ev.PV_ID = pv.PV_ID
 13 
 WHERE ev.PV_ID = pv.PV_ID
10 
   AND pv.PKG_ID = :PKG_ID
 14 
   AND pv.PKG_ID = :PKG_ID
11 
   AND NVL( pv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
 15 
   AND NVL( pv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
12 
   AND ev.RTAG_ID = rt.RTAG_ID
 16 
   AND ev.RTAG_ID = rt.RTAG_ID
13 
   AND rt.PROJ_ID = proj.PROJ_ID
 17 
   AND rt.PROJ_ID = proj.PROJ_ID
- 
 
 18 
   AND (ev.pv_id = :PV_ID OR :PV_ID = -1)
14 
 GROUP BY proj.PROJ_ID, proj.PROJ_NAME
19 
 GROUP BY proj.PROJ_ID, proj.PROJ_NAME
15 
 ORDER BY UPPER(proj.PROJ_NAME)
 - 
 
16 

            20
            
 ORDER BY UPPER(proj.PROJ_NAME)

          

          

            -
            
 

            21