Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Unused Packages */
2 
SELECT dpkg.PKG_NAME,
3 
       latest.PKG_VERSION,
4 
       latest.PV_ID AS LATEST_PV_ID
5 
  FROM (
6 
        /* Release content reference */
7 
        SELECT pv.PV_ID, pv.PKG_ID, pv.V_EXT, pv.PKG_VERSION
8 
		  FROM RELEASE_CONTENT rc,
9 
		  	   PACKAGE_VERSIONS pv
10 
		 WHERE rc.PV_ID = pv.PV_ID
11 
		   AND rc.RTAG_ID = :RTAG_ID
12 
   	   ) latest,
13 
       PACKAGE_DEPENDENCIES dep,
14 
       PACKAGE_VERSIONS dpv,
15 
       PACKAGES dpkg
16 
 WHERE dep.DPV_ID = dpv.PV_ID
17 
   AND dep.PV_ID = :PV_ID
18 
   AND dpv.PKG_ID = dpkg.PKG_ID
19 
   AND dpv.PKG_ID = latest.PKG_ID
20 
   AND NVL ( dpv.V_EXT, '|LINK_A_NULL|' ) = NVL ( latest.V_EXT, '|LINK_A_NULL|' )
21 
   AND dpv.PV_ID != latest.PV_ID
22 
 
23 
MINUS
24 
 
25 
/* Remove Already used patche dependencies */
26 
SELECT pkg.PKG_NAME, pv.PKG_VERSION, pv.PV_ID
27 
  FROM PACKAGE_PATCHES pp,
28 
  	   PACKAGE_DEPENDENCIES pdep,
29 
       PACKAGES pkg,
30 
       PACKAGE_VERSIONS pv
31 
 WHERE pp.PATCH_ID = pdep.PV_ID
32 
   AND pp.PV_ID = :PV_ID
33 
   AND pv.PKG_ID = pkg.PKG_ID
34 
   AND pdep.DPV_ID = pv.PV_ID