Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* All Products */
2 
SELECT DISTINCT
3 
       osc.PROD_ID,
4 
	   pkg.pkg_name,
5 
	   pv.pkg_version,
6 
	   pd.IS_REJECTED,
7 
	   os.OS_ID,
8 
	   os.OS_NAME,
9 
	   nn.NODE_NAME,
10 
	   nn.node_id,
11 
	   pv.IS_PATCH, pv.IS_OBSOLETE,
12 
	   osc.SEQ_NUM
13 
  FROM    deployment_manager.bom_contents bc,
14 
   	 deployment_manager.operating_systems os,
15 
      	 deployment_manager.os_contents osc,
16 
	 PACKAGES pkg,
17 
  	 PACKAGE_VERSIONS pv,
18 
	 deployment_manager.PRODUCT_DETAILS pd,
19 
	 deployment_manager.NETWORK_NODES nn
20 
 WHERE osc.os_id = os.os_id
21 
   AND os.node_id = bc.node_id
22 
   AND bc.bom_id = :BOM_ID
23 
   AND pd.PROD_ID (+) = osc.PROD_ID
24 
   AND pv.pkg_id = pkg.pkg_id
25 
   AND osc.prod_id = pv.pv_id
26 
   AND nn.NODE_ID = os.NODE_ID
27 
 ORDER BY UPPER(nn.NODE_NAME), UPPER(os.OS_NAME), osc.SEQ_NUM