Subversion Repositories DevTools

/* 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