/* BOM Combo */
SELECT bo.BOM_ID,
	   bn.BOM_NAME ||' '|| bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS ITEM_VALUE,
	   DECODE ( :BOM_ID,
	   			bo.BOM_ID, 'selected',
				NULL ) AS SELECTED
  FROM BOMS bo,
  	   BOM_NAMES bn
 WHERE bo.BRANCH_ID = :BRANCH_ID   
   AND bo.BOM_NAME_ID = bn.BOM_NAME_ID
 ORDER BY UPPER(bn.BOM_NAME), bo.BOM_VERSION, bo.BOM_LIFECYCLE 
