Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Unused patches */
2 
SELECT mp.PATCH_ID, pkg.PKG_NAME, pv.PKG_VERSION
3 
  FROM PACKAGES pkg,
4 
  	   PACKAGE_VERSIONS pv,
5 
       (
6 
 
7 
        /* All patches from pacth parent */
8 
		SELECT pp.PV_ID, pp.PATCH_ID
9 
		  FROM (
10 
		  		SELECT DISTINCT dep.DPV_ID
11 
				  FROM PACKAGE_DEPENDENCIES dep
12 
				 WHERE dep.PV_ID = :PV_ID
13 
		       ) parent_pp,
14 
		       PACKAGE_PATCHES pp,
15 
			   PACKAGE_VERSIONS pv
16 
		 WHERE pp.PV_ID = parent_pp.DPV_ID
17 
 		   AND pp.PATCH_ID = pv.PV_ID
18 
		   AND pv.IS_OBSOLETE IS NULL
19 
 
20 
		MINUS
21 
 
22 
		/* Currently used patches */
23 
		SELECT orig.PV_ID, orig.PATCH_ID
24 
		  FROM PACKAGE_PATCHES pp,
25 
		  	   PACKAGE_DEPENDENCIES dep,
26 
		       PACKAGE_PATCHES orig
27 
		 WHERE pp.PATCH_ID = dep.PV_ID
28 
		   AND pp.PV_ID = :PV_ID
29 
		   AND orig.PATCH_ID = dep.DPV_ID
30 
 
31 
       ) mp
32 
 WHERE mp.PATCH_ID = pv.PV_ID
33 
   AND pv.PKG_ID = pkg.PKG_ID
34 
   AND pv.DLOCKED = 'Y'
35 
   ORDER BY pv.PKG_VERSION
36