/* Base Environment Details */
SELECT be.BASE_ENV_ID,
	   be.BASE_ENV_NAME,
	   be.BOM_ID,
	   be.BOS_ID
  FROM BASE_ENV be
 WHERE be.BASE_ENV_ID = :BASE_ENV_ID  