/*  Bom Product Locations  */
SELECT nt.NODE_ICON,
	   nn.NODE_ID,
	   nn.NODE_NAME,
	   os.OS_ID,
	   os.OS_NAME,
	   pv.PV_ID AS PROD_ID,
	   pkg.PKG_NAME,
	   pv.PKG_VERSION
  FROM OS_CONTENTS osc,
  	   OPERATING_SYSTEMS os,
	   NETWORK_NODES nn,
	   NODE_TYPES nt,
	   BOM_CONTENTS bc,
	   PACKAGE_VERSIONS pv,
	   PACKAGES pkg
 WHERE osc.OS_ID = os.OS_ID
   AND os.NODE_ID = nn.NODE_ID
   AND nn.NODE_TYPE_ID = nt.NODE_TYPE_ID
   AND bc.NODE_ID = nn.NODE_ID
   AND bc.BOM_ID = :BOM_ID
   AND osc.PROD_ID = :PROD_ID
   AND osc.PROD_ID = pv.PV_ID
   AND pv.PKG_ID = pkg.PKG_ID	   
 ORDER BY UPPER(nn.NODE_NAME), UPPER(os.OS_NAME) 
