Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
15 rsolanki 1 
/* Node Base Configurations*/
2 
SELECT nn.NODE_ID,
3 
	   os.OS_ID,
4 
	   os.OS_NAME AS OS,
5 
	   obe.BASE_ENV_ID,
6 
	   bec.PROD_ID,
7 
	   pkg.PKG_NAME,
8 
	   pkg.WIN_ELECTRONIC_NAME,
9 
	   pv.PKG_VERSION,
19 rsolanki 10 
	   pv.PATCH_ELECTRONIC_NAME,
15 rsolanki 11 
	   pv.MODIFIED_STAMP,
12 
	   pv.IS_PATCH,
13 
	   be.BOS_ID,
14 
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
15 
	   LOWER( bt.ELECTRONIC_NAME ) AS OS_NAME
16 
FROM   NETWORK_NODES nn,
17 
  	   BOM_CONTENTS bc,
18 
	   OPERATING_SYSTEMS os,
19 
	   OS_BASE_ENV obe,
20 
	   BASE_ENV_CONTENTS bec,
21 
   	   PACKAGE_VERSIONS pv,
22 
	   PACKAGES pkg,
23 
	   BASE_ENV be,
24 
	   BOS_TYPES bt
25 
WHERE  bc.BOM_ID = :BOM_ID
26 
   AND nn.NODE_ID = :NODE_ID
27 
   AND bc.NODE_ID = nn.NODE_ID
28 
   AND os.NODE_ID = nn.NODE_ID
29 
   AND obe.OS_ID = os.OS_ID
30 
   AND bec.BASE_ENV_ID = obe.BASE_ENV_ID
31 
   AND bec.PROD_ID = pv.PV_ID
32 
   AND pkg.PKG_ID = pv.PKG_ID
33 
   AND be.BASE_ENV_ID =obe.BASE_ENV_ID
34 
   AND bt.BOS_ID = be.BOS_ID
35 
   AND bt.BOS_ID IN (1)	-- Windows only
36 
   AND os.NOT_XML IS NULL
25 rsolanki 37 
   AND bec.NOT_XML IS NULL
38 
   AND pv.IS_OBSOLETE IS NULL
15 rsolanki 39 
 
40 
ORDER BY bec.SEQ_NUM