Subversion Repositories DevTools

Rev

Rev 5513 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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

            11