Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

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