/* Bom Base Env Combo */
SELECT be.BASE_ENV_ID,
	   be.BASE_ENV_NAME,
	   DECODE( :BASE_ENV_NAME,
	   		   be.BASE_ENV_NAME, 'selected',
			   NULL
	   		  ) AS SELECTED
  FROM BASE_ENV be
 WHERE be.BOM_ID = :BOM_ID  
ORDER BY UPPER(be.BASE_ENV_NAME)
 