Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
/* All Products */
2 
SELECT DISTINCT
3 
       osc.PROD_ID,
4 
	   pkg.pkg_name,
5 
	   pv.pkg_version,
6 
	   pd.IS_REJECTED,
7 
	   pkg.pkg_id,
8 
	   pv.is_patch
9 
  FROM bom_contents bc,
10 
   	   operating_systems os,
11 
       os_contents osc,
12 
	   PACKAGES pkg,
13 
  	   PACKAGE_VERSIONS pv,
14 
	   PRODUCT_DETAILS pd
15 
 WHERE osc.os_id = os.os_id
16 
   AND os.node_id = bc.node_id
17 
   AND bc.bom_id = :BOM_ID
18 
   AND pd.PROD_ID (+) = osc.PROD_ID
19 
   AND pv.pkg_id = pkg.pkg_id
20 
   AND osc.prod_id = pv.pv_id
21 
 ORDER BY UPPER(pkg.pkg_name), UPPER(pv.PKG_VERSION)