Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
25 rsolanki 1 
/*  Bom Product Locations  */
2 
SELECT nt.NODE_ICON,
3 
	   nn.NODE_ID,
4 
	   nn.NODE_NAME,
5 
	   os.OS_ID,
6 
	   os.OS_NAME,
7 
	   pv.PV_ID AS PROD_ID,
8 
	   pkg.PKG_NAME,
9 
	   pv.PKG_VERSION
10 
  FROM os_base_env obe,
11 
       base_env_contents bec,
12 
  	   OPERATING_SYSTEMS os,
13 
	   NETWORK_NODES nn,
14 
	   NODE_TYPES nt,
15 
	   BOM_CONTENTS bc,
16 
	   PACKAGE_VERSIONS pv,
17 
	   PACKAGES pkg
18 
 WHERE os.NODE_ID = nn.NODE_ID
19 
   AND nn.NODE_TYPE_ID = nt.NODE_TYPE_ID
20 
   AND bc.NODE_ID = nn.NODE_ID
21 
   AND bc.BOM_ID = :BOM_ID
22 
   AND bec.PROD_ID = :PROD_ID
23 
   AND pv.PKG_ID = pkg.PKG_ID
24 
   AND obe.os_id = os.os_id
25 
   AND bec.base_env_id = obe.base_env_id
26 
   AND bec.prod_id = pv.pv_id
27 
 ORDER BY UPPER(nn.NODE_NAME), UPPER(os.OS_NAME)