Subversion Repositories DevTools

/* SBOM Combo */
SELECT BOM_ID, 
        BOM_NAME ||' '||BOM_VERSION ||'.'||BOM_LIFECYCLE AS VERSION,
        DECODE ( :BOM_ID,
                                BOM_ID, 'selected',
                                NULL ) AS SELECTED
FROM BOMS, BOM_NAMES
WHERE BRANCH_ID =:BRANCH_ID
AND BOM_NAMES.BOM_NAME_ID = BOMS.BOM_NAME_ID
ORDER BY UPPER(BOM_NAME), BOM_VERSION desc, TO_NUMBER(BOM_LIFECYCLE) desc