Subversion Repositories DevTools

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