Subversion Repositories DevTools

SELECT BOM_ID, BOM_VERSION ||'.'||BOM_LIFECYCLE AS VERSION 
FROM DEPLOYMENT_MANAGER.BOMS
WHERE BRANCH_ID =:BRANCH_ID
AND BOM_VERSION ||'.'||BOM_LIFECYCLE = :BOM_VERSION
ORDER BY VERSION