Subversion Repositories DevTools

/* 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)