eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EGO_FUNC_PARAMS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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