Subversion Repositories DevTools

/* Network Nodes Spec Files List */
SELECT nn.NODE_ID,
           nn.NODE_NAME,
           nn.NODE_VERSION,
           nn.NODE_LIFE_CYCLE,
           br.BRANCH_NAME,
           b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION,
           os.NODE_SPEC_FILE,
           os.OS_NAME,
           bm.BOM_NAME,
           dp.PROJ_NAME,
           os.OS_ID
  FROM BOM_CONTENTS bc,
       NETWORK_NODES nn,
           BRANCHES br,
           BOMS b,
           OPERATING_SYSTEMS os,
           BOM_NAMES bm,
           DM_PROJECTS dp
 WHERE bc.NODE_ID = nn.NODE_ID
   AND bc.BOM_ID = :BOM_ID
   AND br.BRANCH_ID = b.BRANCH_ID
   AND b.BOM_ID = bc.BOM_ID      
   AND os.NODE_ID = nn.NODE_ID
   AND os.NODE_SPEC_FILE IS NOT NULL
   AND bm.BOM_NAME_ID = b.BOM_NAME_ID
   AND dp.PROJ_ID = br.PROJ_ID