Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* ReleaseManager Products Unused Patches */
2 
SELECT pv.PV_ID AS PROD_ID,
3 
	   pkg.PKG_NAME,
4 
	   pv.PKG_VERSION,
5 
	   op.INSTALL_ORDER
6 
  FROM PACKAGES pkg,
7 
	   PACKAGE_VERSIONS pv,
8 
	   (
9 
	   	/* All patches from RM for all Products in OS */
10 
	    SELECT pp.PV_ID, pp.PATCH_ID
11 
		  FROM OS_CONTENTS osc,
12 
		  	   PACKAGE_PATCHES pp,
13 
               PACKAGE_VERSIONS pv,
14 
			   PACKAGE_VERSIONS ppv
15 
		 WHERE osc.PROD_ID = pp.PV_ID
16 
           AND osc.PROD_ID = pv.PV_ID
17 
		   AND pp.PATCH_ID = ppv.PV_ID
18 
           AND pv.IS_PATCH IS NULL
19 
           AND osc.OS_ID = :OS_ID
20 
		   AND ppv.IS_OBSOLETE IS NULL
21 
		MINUS
22 
        /* OS Patches */
23 
        SELECT pp.PV_ID, pp.PATCH_ID
24 
		  FROM OS_CONTENTS osc,
25 
		  	   PACKAGE_PATCHES pp,
26 
               PACKAGE_VERSIONS pv
27 
		 WHERE osc.PROD_ID = pp.PATCH_ID
28 
           AND osc.PROD_ID = pv.PV_ID
29 
           AND pv.IS_PATCH IS NOT NULL
30 
           AND osc.OS_ID = :OS_ID
31 
	   ) pp,
32 
	   PACKAGE_PATCHES op
33 
 WHERE pv.PKG_ID = pkg.PKG_ID
34 
   AND pp.PATCH_ID = PV.PV_ID
35 
   AND pp.PV_ID = op.PV_ID
36 
   AND pp.PATCH_ID = op.PATCH_ID
37 
 ORDER BY op.INSTALL_ORDER