/* Paste OS List */
 SELECT os.OS_ID AS ITEM_ID,
 	    os.OS_NAME AS ITEM_NAME,
		DECODE ( bt.BOS_ICON,
				 NULL, 'i_generic_os.gif',
				 bt.BOS_ICON ) AS ITEM_ICON
   FROM OPERATING_SYSTEMS os,
   	    OS_BASE_ENV obe,
		BASE_ENV be,
		BOS_TYPES bt
  WHERE be.BOS_ID = bt.BOS_ID (+)
    AND obe.BASE_ENV_ID = be.BASE_ENV_ID (+)
	AND obe.OS_ID (+) = os.OS_ID
  	AND os.NODE_ID = :FROM_ID
  	AND os.OS_ID IN (
				   	 SELECT *
				   	   FROM THE ( SELECT CAST( IN_LIST_NUMBER( :ITEM_ID_LIST ) AS DEPMGR_NUMBER_TAB_t ) FROM dual ) 
   	   			   	)	
 ORDER BY UPPER(os.OS_NAME)	