Subversion Repositories DevTools

Rev

Rev 13 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13 Rev 15
Line 1... Line 1...
1 
/* Node Products */
1 
/* Node Products */
2 
SELECT nn.NODE_ID,
 2 
SELECT nn.NODE_ID,
3 
	   bt.BOS_ID,
 3 
	   bt.BOS_ID,
4 
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
 4 
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
- 
 
 5 
	   LOWER( bt.ELECTRONIC_NAME ) AS OS_NAME,
5 
 	   osc.PROD_ID,
 6 
 	   osc.PROD_ID,
6 
	   pkg.PKG_NAME,
 7 
	   pkg.PKG_NAME,
- 
 
 8 
	   pkg.ELECTRONIC_NAME,
7 
	   pv.PKG_VERSION,
 9 
	   pv.PKG_VERSION,
8 
	   pv.MODIFIED_STAMP
 10 
	   pv.MODIFIED_STAMP,
- 
 
 11 
	   pv.IS_PATCH
9 
  FROM NETWORK_NODES nn,
 12 
  FROM NETWORK_NODES nn,
10 
  	   BOM_CONTENTS bc,
 13 
  	   BOM_CONTENTS bc,
11 
	   OPERATING_SYSTEMS os,
 14 
	   OPERATING_SYSTEMS os,
12 
	   OS_CONTENTS osc,
 15 
	   OS_CONTENTS osc,
13 
	   PACKAGE_VERSIONS pv,
 16 
	   PACKAGE_VERSIONS pv,
Line 23... Line 26...
23 
   AND osc.PROD_ID = pv.PV_ID
26 
   AND osc.PROD_ID = pv.PV_ID
24 
   AND obe.OS_ID = os.OS_ID
 27 
   AND obe.OS_ID = os.OS_ID
25 
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID
 28 
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID
26 
   AND be.BOS_ID = bt.BOS_ID
 29 
   AND be.BOS_ID = bt.BOS_ID
27 
   AND bt.BOS_ID IN (1,2)	-- Windows and Solaris only
 30 
   AND bt.BOS_ID IN (1,2)	-- Windows and Solaris only
28 
   AND nn.NODE_ID = :NODE_ID
 - 
 
29 

            31
            
   AND nn.NODE_ID = :NODE_ID

          

          

            -
            
 

            32
            
ORDER BY osc.SEQ_NUM

          

          

            -
            
 

            33