/* OS Details */
SELECT os.OS_ID,
	   os.OS_NAME,
	   os.NODE_ID,
	   os.OS_COMMENTS,
                 os.NODE_SPEC_FILE,
	   os.NOT_XML,		
	   obe.base_env_id,
       be.BASE_ENV_NAME  
  FROM OPERATING_SYSTEMS os,
	   BASE_ENV be,
       OS_BASE_ENV obe 
 WHERE os.OS_ID = :OS_ID
   AND obe.OS_ID (+) = os.OS_ID
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID (+)
