Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
119 ghuddy 1 
/* Make Bulk Patches Official */
2 
 
3 
 
4 
		 SELECT pp.PATCH_ID AS PPATCH_ID,
5 
 
6 
		        pp.INSTALL_ORDER,
7 
                pkg.PKG_NAME,
8 
                pv.PKG_VERSION,
9 
                pv.COMMENTS,
10 
                pv.OBSOLETE_COMMENTS,
11 
                pv.DLOCKED,
12 
                pv.IS_PATCH,
13 
                pv.is_obsolete,
14 
                usr.FULL_NAME,
15 
                usr.USER_EMAIL
16 
		   FROM PACKAGE_PATCHES pp,
17 
           	    PACKAGES pkg,
18 
                PACKAGE_VERSIONS pv,
19 
                USERS usr
20 
		  WHERE pp.PV_ID = :PV_ID
21 
            AND pv.PKG_ID = pkg.PKG_ID
22 
            AND pp.PATCH_ID = pv.PV_ID
23 
            AND pv.MODIFIER_ID = usr.USER_ID
24 
			AND dlocked = 'N'
25 
			AND pv.is_obsolete IS NULL
26 
			AND pv.comments IS NOT NULL
27 
 
28 
 ORDER BY INSTALL_ORDER, PATCH_ID