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 This Project */
 1 
-- UsedByThisProject.sql
- 
 
 2 
-- Generate detailed 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 DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
 6 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
3 
	   rt.RTAG_ID,
 7 
       rt.RTAG_ID,
4 
	   rt.RTAG_NAME,
 8 
       rt.RTAG_NAME,
5 
	   rt.OFFICIAL,
 9 
       rt.OFFICIAL,
6 
	   ev.ENV_AREA,
 10 
       ev.ENV_AREA,
7 
	   pv.PV_ID,
 11 
       pv.PV_ID,
8 
	   pkg.PKG_NAME,
 12 
       pkg.PKG_NAME,
9 
	   pv.PKG_VERSION,
 13 
       pv.PKG_VERSION,
10 
	   pv.DLOCKED,
 14 
       pv.DLOCKED,
11 
	   usr.FULL_NAME,
 15 
       usr.FULL_NAME,
12 
	   usr.USER_EMAIL,
 16 
       usr.USER_EMAIL,
13 
	   pv.MODIFIED_STAMP
17 
       pv.MODIFIED_STAMP
14 
  FROM ENVIRONMENT_VIEW ev,
 18 
  FROM ENVIRONMENT_VIEW ev,
15 
  	   PACKAGE_VERSIONS pv,
 19 
       PACKAGE_VERSIONS pv,
16 
	   PACKAGES pkg,
 20 
       PACKAGES pkg,
17 
	   RELEASE_TAGS rt,
 21 
       RELEASE_TAGS rt,
18 
	   USERS usr
 22 
       USERS usr
19 
 WHERE ev.PV_ID = pv.PV_ID
 23 
 WHERE ev.PV_ID = pv.PV_ID
20 
   AND pv.PKG_ID = :PKG_ID
 24 
   AND pv.PKG_ID = :PKG_ID
21 
   AND NVL( pv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
 25 
   AND NVL( pv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
22 
   AND pv.PKG_ID = pkg.PKG_ID
 26 
   AND pv.PKG_ID = pkg.PKG_ID
23 
   AND ev.RTAG_ID = rt.RTAG_ID
 27 
   AND ev.RTAG_ID = rt.RTAG_ID
24 
   AND pv.MODIFIER_ID = usr.USER_ID
 28 
   AND pv.MODIFIER_ID = usr.USER_ID
25 
   AND rt.PROJ_ID = :PROJ_ID
 29 
   AND rt.PROJ_ID = :PROJ_ID
26 
 ORDER BY rt.RTAG_ID DESC
- 
 
27 

            30
            
   AND (ev.pv_id = :PV_ID OR :PV_ID = -1)

          

          

            -
            
 

            31
            
 ORDER BY rt.RTAG_ID DESC 

          

          

            -
            
 

            32
            
 

          

          

            -
            
 

            33