SELECT F.FUNCTION_ID FUNCTION_ID , L1.MEANING DATA_TYPE_MEANING , L1.LOOKUP_CODE DATA_TYPE_CODE FROM EGO_FUNCTIONS_B F , FND_LOOKUP_VALUES L1 WHERE L1.LOOKUP_TYPE LIKE 'EGO_EF_FUNC_PARAM_DATA_TYPE%' AND SUBSTR(L1.LOOKUP_TYPE , 29 , 1) = F.FUNCTION_TYPE AND L1.VIEW_APPLICATION_ID = 0 AND L1.LANGUAGE = USERENV('LANG')