/* 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 VERSION