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