/* Os List */
SELECT DECODE( bt.BOS_ICON,
	   		   NULL, 'i_generic_os.gif',
			   bt.bos_icon 
	   		  ) AS BOS_ICON,
	   os.os_id, 
	   osbe.base_env_id, 
	   os.os_name, 
	   os.node_id, 
	   os.os_comments
  FROM operating_systems os,
  	   BASE_ENV be,
	   BOS_TYPES bt,
	   OS_BASE_ENV osbe
 WHERE be.BOS_ID = bt.BOS_ID (+)
   AND osbe.OS_ID (+) = os.OS_ID
   AND osbe.BASE_ENV_ID = be.BASE_ENV_ID (+)
   AND os.NODE_ID = :NODE_ID
ORDER BY UPPER(os.os_name)

