[Home] [Help]
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
Name |
FUNCTION_ID |
INTERNAL_NAME |
DISPLAY_NAME |
DESCRIPTION |
FUNC_TYPE_CODE |
FUNC_TYPE_MEANING |
FUNCTION_INFO_1 |
FUNCTION_INFO_2 |