Subversion Repositories DevTools

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