Subversion Repositories DevTools

/* Network Nodes List */
SELECT nn.NODE_ID,
           nn.NODE_NAME,
           nn.NODE_VERSION,
           nn.NODE_LIFE_CYCLE,
           br.BRANCH_NAME,
           bn.BOM_NAME ||''|| b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION
  FROM BOM_CONTENTS bc,
       NETWORK_NODES nn,
           BRANCHES br,
           BOMS b,
           BOM_NAMES bn
 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 nn.NOT_XML IS NULL
   AND bn.BOM_NAME_ID = b.BOM_NAME_ID