/* Node Base Configurations*/   
SELECT nn.NODE_ID,
	   os.OS_ID,
	   os.OS_NAME AS OS,	
	   obe.BASE_ENV_ID,
	   bec.PROD_ID,
	   pkg.PKG_NAME,  
	   pkg.WIN_ELECTRONIC_NAME,
	   pv.PKG_VERSION,
	   pv.PATCH_ELECTRONIC_NAME,
	   pv.MODIFIED_STAMP,
	   pv.IS_PATCH,
	   be.BOS_ID,
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
	   LOWER( bt.ELECTRONIC_NAME ) AS OS_NAME
FROM   NETWORK_NODES nn,
  	   BOM_CONTENTS bc,
	   OPERATING_SYSTEMS os,
	   OS_BASE_ENV obe,
	   BASE_ENV_CONTENTS bec,
   	   PACKAGE_VERSIONS pv,
	   PACKAGES pkg,
	   BASE_ENV be,
	   BOS_TYPES bt   
WHERE  bc.BOM_ID = :BOM_ID
   AND nn.NODE_ID = :NODE_ID
   AND bc.NODE_ID = nn.NODE_ID
   AND os.NODE_ID = nn.NODE_ID
   AND obe.OS_ID = os.OS_ID
   AND bec.BASE_ENV_ID = obe.BASE_ENV_ID
   AND bec.PROD_ID = pv.PV_ID
   AND pkg.PKG_ID = pv.PKG_ID
   AND be.BASE_ENV_ID =obe.BASE_ENV_ID
   AND bt.BOS_ID = be.BOS_ID
   AND bt.BOS_ID IN (1)	-- Windows only   
   AND os.NOT_XML IS NULL 
   AND bec.NOT_XML IS NULL
   AND pv.IS_OBSOLETE IS NULL	
   
ORDER BY bec.SEQ_NUM 	