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