Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Os List */
2 
SELECT DECODE( bt.BOS_ICON,
3 
	   		   NULL, 'i_generic_os.gif',
4 
			   bt.bos_icon
5 
	   		  ) AS BOS_ICON,
6 
	   os.os_id,
7 
	   osbe.base_env_id,
8 
	   os.os_name,
9 
	   os.node_id,
10 
	   os.os_comments
11 
  FROM operating_systems os,
12 
  	   BASE_ENV be,
13 
	   BOS_TYPES bt,
14 
	   OS_BASE_ENV osbe
15 
 WHERE be.BOS_ID = bt.BOS_ID (+)
16 
   AND osbe.OS_ID (+) = os.OS_ID
17 
   AND osbe.BASE_ENV_ID = be.BASE_ENV_ID (+)
18 
   AND os.NODE_ID = :NODE_ID
19 
ORDER BY UPPER(os.os_name)
20