Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
/* Products Less Patches Combo*/
2 
SELECT osc.*,
3 
	   pkg.pkg_name,
4 
	   pv.pkg_version,
5 
	   pd.IS_REJECTED,
6 
	   pv.IS_PATCH,
7 
	   pv.IS_OBSOLETE,
8 
	   DECODE ( :PKG_NAME,
9 
	   			pkg.PKG_NAME, 'selected',
10 
				NULL ) AS SELECTED
11 
  FROM PACKAGES pkg,
12 
  	   PACKAGE_VERSIONS pv,
13 
	   PRODUCT_DETAILS pd,
14 
	   (
15 
		SELECT osc.seq_num, osc.prod_id, osc.product_comments, osc.change_log_flag
16 
		  FROM os_contents osc
17 
		 WHERE osc.os_id = :OS_ID
18 
	   ) osc
19 
 WHERE pd.PROD_ID (+)= pv.PV_ID
20 
   AND pv.pkg_id = pkg.pkg_id
21 
   AND osc.PROD_ID = pv.pv_id
22 
   AND pv.IS_PATCH IS NULL
23 
ORDER BY PKG_NAME