Subversion Repositories DevTools

Rev

Details | 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
10 
ORDER BY VERSION