Subversion Repositories DevTools

Rev

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

Rev 15 Rev 19
Line 5... Line 5...
5 
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
 5 
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
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.SUNOS_ELECTRONIC_NAME,
 9 
	   pkg.SUNOS_ELECTRONIC_NAME,
- 
 
 10 
	   pv.PATCH_ELECTRONIC_NAME,
10 
	   pv.PKG_VERSION,
 11 
	   pv.PKG_VERSION,
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,
Line 27... Line 28...
27 
   AND osc.PROD_ID = pv.PV_ID
28 
   AND osc.PROD_ID = pv.PV_ID
28 
   AND obe.OS_ID = os.OS_ID
 29 
   AND obe.OS_ID = os.OS_ID
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 (2)	-- Solaris only
 32 
   AND bt.BOS_ID IN (2)	-- Solaris only
32 
   AND os.NOT_XML IS NULL
33 
   AND os.NOT_XML IS NULL
- 
 
 34 
   AND osc.NOT_XML IS NULL
33 
   AND nn.NODE_ID = :NODE_ID
 35 
   AND nn.NODE_ID = :NODE_ID
34 
ORDER BY osc.SEQ_NUM
 36 
ORDER BY osc.SEQ_NUM