View: EGO_FP_DATA_TYPES_V

Product:	EGO - Advanced Product Catalog
Description:	View with Function Parameter types.
Implementation/DBA Data:	APPS.EGO_FP_DATA_TYPES_V

View Text

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')

Columns