View: EGO_FUNCTIONS_V

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

View Text

SELECT FN.FUNCTION_ID FUNCTION_ID
, FN.INTERNAL_NAME INTERNAL_NAME
, FN_TL.DISPLAY_NAME DISPLAY_NAME
, FN_TL.DESCRIPTION DESCRIPTION
, FN.FUNCTION_TYPE FUNC_TYPE_CODE
, L1.MEANING FUNC_TYPE_MEANING
, FN.FUNCTION_INFO_1 FUNCTION_INFO_1
, FN.FUNCTION_INFO_2 FUNCTION_INFO_2
FROM EGO_FUNCTIONS_B FN
, EGO_FUNCTIONS_TL FN_TL
, FND_LOOKUP_VALUES L1
WHERE FN.FUNCTION_ID = FN_TL.FUNCTION_ID
AND FN_TL.LANGUAGE = USERENV('LANG')
AND L1.LOOKUP_TYPE = 'EGO_EF_FUNCTION_TYPE'
AND L1.LOOKUP_CODE = FN.FUNCTION_TYPE
AND L1.VIEW_APPLICATION_ID = 0
AND L1.LANGUAGE = USERENV('LANG')

Columns