Subversion Repositories DevTools

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