Subversion Repositories DevTools

Rev

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

Rev 15 Rev 19
Line 6... Line 6...
6 
	   LOWER( bt.ELECTRONIC_NAME ) AS OS_NAME,
 6 
	   LOWER( bt.ELECTRONIC_NAME ) AS OS_NAME,
7 
 	   osc.PROD_ID,
 7 
 	   osc.PROD_ID,
8 
	   pkg.PKG_NAME,
 8 
	   pkg.PKG_NAME,
9 
	   pkg.WIN_ELECTRONIC_NAME,
 9 
	   pkg.WIN_ELECTRONIC_NAME,
10 
	   pv.PKG_VERSION,
 10 
	   pv.PKG_VERSION,
- 
 
 11 
	   pv.PATCH_ELECTRONIC_NAME,
11 
	   pv.MODIFIED_STAMP,
 12 
	   pv.MODIFIED_STAMP,
12 
	   pv.IS_PATCH
 13 
	   pv.IS_PATCH
13 
  FROM NETWORK_NODES nn,
 14 
  FROM NETWORK_NODES nn,
14 
  	   BOM_CONTENTS bc,
 15 
  	   BOM_CONTENTS bc,
15 
	   OPERATING_SYSTEMS os,
 16 
	   OPERATING_SYSTEMS os,
Line 29... Line 30...
29 
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID
 30 
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID
30 
   AND be.BOS_ID = bt.BOS_ID
 31 
   AND be.BOS_ID = bt.BOS_ID
31 
   AND bt.BOS_ID IN (1)	-- Windows only
 32 
   AND bt.BOS_ID IN (1)	-- Windows only
32 
   AND os.NOT_XML IS NULL
33 
   AND os.NOT_XML IS NULL
33 
   AND nn.NODE_ID = :NODE_ID
 34 
   AND nn.NODE_ID = :NODE_ID
- 
 
 35 
   AND osc.NOT_XML IS NULL
34 
ORDER BY osc.SEQ_NUM
 36 
ORDER BY osc.SEQ_NUM