/* Bom Name Version List */
SELECT bo.BOM_ID,
	   bn.BOM_NAME,
	   bo.BOM_VERSION,
	   bo.BOM_LIFECYCLE,
	   bo.IS_READONLY,
	   bo.IS_REJECTED
  FROM BOMS bo,
  	   BOM_NAMES bn
 WHERE bo.BOM_NAME_ID = bn.BOM_NAME_ID 
   AND bn.BOM_NAME_ID = :BOM_NAME_ID
 ORDER BY UPPER(bo.BOM_VERSION) DESC, UPPER(bo.BOM_LIFECYCLE) DESC   