Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Paste OS List */
2 
 SELECT os.OS_ID AS ITEM_ID,
3 
 	    os.OS_NAME AS ITEM_NAME,
4 
		DECODE ( bt.BOS_ICON,
5 
				 NULL, 'i_generic_os.gif',
6 
				 bt.BOS_ICON ) AS ITEM_ICON
7 
   FROM OPERATING_SYSTEMS os,
8 
   	    OS_BASE_ENV obe,
9 
		BASE_ENV be,
10 
		BOS_TYPES bt
11 
  WHERE be.BOS_ID = bt.BOS_ID (+)
12 
    AND obe.BASE_ENV_ID = be.BASE_ENV_ID (+)
13 
	AND obe.OS_ID (+) = os.OS_ID
14 
  	AND os.NODE_ID = :FROM_ID
15 
  	AND os.OS_ID IN (
16 
				   	 SELECT *
17 
				   	   FROM THE ( SELECT CAST( IN_LIST_NUMBER( :ITEM_ID_LIST ) AS DEPMGR_NUMBER_TAB_t ) FROM dual )
18 
   	   			   	)
19 
 ORDER BY UPPER(os.OS_NAME)