Subversion Repositories DevTools

/*  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_base_env obe,
       base_env_contents bec,
           OPERATING_SYSTEMS os,
           NETWORK_NODES nn,
           NODE_TYPES nt,
           BOM_CONTENTS bc,
           PACKAGE_VERSIONS pv,
           PACKAGES pkg
 WHERE 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 bec.PROD_ID = :PROD_ID
   AND pv.PKG_ID = pkg.PKG_ID   
   AND obe.os_id = os.os_id
   AND bec.base_env_id = obe.base_env_id
   AND bec.prod_id = pv.pv_id   
 ORDER BY UPPER(nn.NODE_NAME), UPPER(os.OS_NAME)