Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
33 ghuddy 1 
/* Node Products */
2 
SELECT nn.NODE_ID,
3 
	   bt.BOS_ID,
4 
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
5 
	   LOWER( bt.ELECTRONIC_NAME ) AS OS_NAME,
6 
 	   osc.PROD_ID,
7 
	   pkg.PKG_NAME,
8 
	   pkg.ELECTRONIC_NAME,
9 
	   pv.PKG_VERSION,
10 
	   pv.MODIFIED_STAMP,
11 
	   pv.IS_PATCH
12 
  FROM NETWORK_NODES nn,
13 
  	   BOM_CONTENTS bc,
14 
	   OPERATING_SYSTEMS os,
15 
	   OS_CONTENTS osc,
16 
	   PACKAGE_VERSIONS pv,
17 
	   PACKAGES pkg,
18 
	   BOS_TYPES bt,
19 
	   OS_BASE_ENV obe,
20 
	   BASE_ENV be
21 
 WHERE bc.NODE_ID = nn.NODE_ID
22 
   AND os.NODE_ID = nn.NODE_ID
23 
   AND osc.OS_ID = os.OS_ID
24 
   AND bc.BOM_ID = :BOM_ID
25 
   AND pv.PKG_ID = pkg.PKG_ID
26 
   AND osc.PROD_ID = pv.PV_ID
27 
   AND obe.OS_ID = os.OS_ID
28 
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID
29 
   AND be.BOS_ID = bt.BOS_ID
30 
   AND bt.BOS_ID IN (1,2)	-- Windows and Solaris only
31 
   AND nn.NODE_ID = :NODE_ID
32 
ORDER BY osc.PROD_ID