Subversion Repositories DevTools

Rev

Rev 29 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* SBOM Combo */
2 
SELECT BOM_ID,
3 
	BOM_NAME ||' '||BOM_VERSION ||'.'||BOM_LIFECYCLE AS VERSION,
4 
	DECODE ( :BOM_ID,
5 
	   			BOM_ID, 'selected',
6 
				NULL ) AS SELECTED
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