Subversion Repositories DevTools

SELECT 
           prj.PROJ_NAME, br.BRANCH_NAME, bn.BOM_NAME,
           b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS SBOM_VERSION,
           b.BOM_VERSION,
           b.BOM_LIFECYCLE,
           nn.NODE_NAME,
           os.OS_NAME, 
           os.NODE_SPEC_FILE            
FROM 
           BOMS b,
           BRANCHES br,
           DM_PROJECTS prj,
           OPERATING_SYSTEMS os,
           NETWORK_NODES nn,
           BOM_CONTENTS bc,
           BOM_NAMES bn
WHERE  
           os.OS_ID = :OS_ID
AND    b.BRANCH_ID = br.BRANCH_ID
AND    br.PROJ_ID = prj.PROJ_ID
AND    os.NODE_ID = nn.NODE_ID
AND    bc.NODE_ID = nn.NODE_ID
AND    bc.BOM_ID = b.BOM_ID
AND    bn.BOM_NAME_ID = b.BOM_NAME_ID