Subversion Repositories DevTools

Rev

Rev 5513 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* SBOM Combo */
2 
SELECT BOM_ID,
5640 dpurdie 3 
    BOM_NAME ||' '|| BOM_VERSION ||'.'|| BOM_LIFECYCLE AS VERSION,
4 
    DECODE ( :BOM_ID,
5 
              BOM_ID, 'selected',
6 
              NULL ) AS SELECTED
13 rsolanki 7 
FROM BOMS, BOM_NAMES
8 
WHERE BRANCH_ID =:BRANCH_ID
9 
AND BOM_NAMES.BOM_NAME_ID = BOMS.BOM_NAME_ID
29 jtweddle 10 
ORDER BY UPPER(BOM_NAME), BOM_VERSION desc, TO_NUMBER(BOM_LIFECYCLE) desc