View: EGO_FUNC_PARAMS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains information about User-Defined Functions - Function Parameters.
Implementation/DBA Data:	APPS.EGO_FUNC_PARAMS_V

View Text

SELECT FP.FUNC_PARAM_ID FUNC_PARAM_ID
, FP.FUNCTION_ID FUNCTION_ID
, FP.SEQUENCE SEQUENCE
, FP.INTERNAL_NAME INTERNAL_NAME
, FP_TL.DISPLAY_NAME DISPLAY_NAME
, FP_TL.DESCRIPTION DESCRIPTION
, FP.DATA_TYPE DATA_TYPE_CODE
, L1.MEANING DATA_TYPE_MEANING
, F.FUNCTION_TYPE FUNC_TYPE_CODE
, L3.MEANING FUNC_TYPE_MEANING
, FP.PARAM_TYPE PARAM_TYPE_CODE
, L2.MEANING PARAM_TYPE_MEANING
FROM EGO_FUNC_PARAMS_B FP
, EGO_FUNC_PARAMS_TL FP_TL
, EGO_FUNCTIONS_B F
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L3
WHERE FP.FUNC_PARAM_ID = FP_TL.FUNC_PARAM_ID
AND F.FUNCTION_ID = FP.FUNCTION_ID
AND FP_TL.LANGUAGE = USERENV('LANG')
AND 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')
AND L1.LOOKUP_CODE = FP.DATA_TYPE
AND L2.LOOKUP_TYPE = 'EGO_EF_FUNC_PARAM_TYPE'
AND L2.VIEW_APPLICATION_ID = 0
AND L2.LANGUAGE = USERENV('LANG')
AND L2.LOOKUP_CODE = FP.PARAM_TYPE
AND L3.LOOKUP_TYPE = 'EGO_EF_FUNCTION_TYPE'
AND L3.VIEW_APPLICATION_ID = 0
AND L3.LANGUAGE = USERENV('LANG')
AND L3.LOOKUP_CODE = F.FUNCTION_TYPE

Columns