VIEW: APPS.EGO_ACTION_DISPLAYS_V

Source

View Text - Preformatted

SELECT AV.ACTION_ID ACTION_ID ,AV.OBJECT_ID OBJECT_ID ,AV.CLASSIFICATION_CODE CLASSIFICATION_CODE ,AV.OBJ_NAME OBJ_NAME ,AV.OBJ_DISP_NAME OBJ_DISP_NAME ,AV.ATTR_GROUP_ID ATTR_GROUP_ID ,AV.ATTR_GRP_APPLICATION_ID ATTR_GRP_APPLICATION_ID ,AV.ATTR_GROUP_TYPE ATTR_GROUP_TYPE ,AV.ATTR_GROUP_NAME ATTR_GROUP_NAME ,AV.ATTR_GROUP_DISP_NAME ATTR_GROUP_DISP_NAME ,AV.SEQUENCE SEQUENCE ,AV.ACTION_NAME ACTION_NAME ,AV.DESCRIPTION DESCRIPTION ,AV.FUNCTION_ID FUNCTION_ID ,AV.FUNC_DISPLAY_NAME FUNC_DISPLAY_NAME ,AV.SECURITY_PRIVILEGE_ID SECURITY_PRIVILEGE_ID ,AV.SECURITY_PRIVILEGE_NAME SECURITY_PRIVILEGE_NAME ,DP.DISPLAY_STYLE DISPLAY_STYLE_CODE ,decode (DP.EXECUTION_METHOD, 'U', (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE VIEW_APPLICATION_ID = 0 AND LANGUAGE = USERENV('LANG') AND LOOKUP_CODE = DP.DISPLAY_STYLE AND LOOKUP_TYPE = 'EGO_EF_DISPLAY_STYLE'), 'T', NULL) DISPLAY_STYLE_MEANING ,DP.PROMPT_APPLICATION_ID PROMPT_APPLICATION_ID ,decode (DP.EXECUTION_METHOD, 'U', (SELECT APPLICATION_NAME FROM FND_APPLICATION_TL WHERE APPLICATION_ID = DP.PROMPT_APPLICATION_ID AND LANGUAGE = USERENV('LANG')), 'T', NULL) PROMPT_APPLICATION_NAME ,DP.PROMPT_MESSAGE_NAME PROMPT_MESSAGE_NAME ,DP.VISIBILITY_FLAG VISIBILITY_FLAG ,decode (DP.EXECUTION_METHOD, 'U', (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE VIEW_APPLICATION_ID = 0 AND LANGUAGE = USERENV('LANG') AND LOOKUP_CODE = DP.VISIBILITY_FLAG AND LOOKUP_TYPE = 'YES_NO'), 'T', NULL) VISIBILITY_MEANING ,DP.PROMPT_FUNCTION_ID PROMPT_FUNC_ID ,decode (DP.EXECUTION_METHOD, 'U', (SELECT DISPLAY_NAME FROM EGO_FUNCTIONS_V WHERE DP.PROMPT_FUNCTION_ID = FUNCTION_ID(+)), 'T', NULL) PROMPT_FUNC_DISP_NAME ,DP.VISIBILITY_FUNC_ID VISIBILITY_FUNC_ID ,decode (DP.EXECUTION_METHOD, 'U', (SELECT DISPLAY_NAME FROM EGO_FUNCTIONS_V WHERE DP.VISIBILITY_FUNC_ID = FUNCTION_ID(+)), 'T', NULL) VISIBILITY_FUNC_DISP_NAME ,DP.EXECUTION_METHOD EXECUTION_CODE ,L1.MEANING EXECUTION_MEANING ,DP.EXECUTION_TRIGGER TRIGGER_CODE ,decode (DP.EXECUTION_METHOD, 'T', (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE VIEW_APPLICATION_ID = 0 AND LANGUAGE = USERENV('LANG') AND LOOKUP_CODE = DP.EXECUTION_TRIGGER AND LOOKUP_TYPE = 'EGO_EF_TRIGGERS'), 'U', NULL) TRIGGER_MEANING FROM EGO_ACTIONS_V AV ,EGO_ACTION_DISPLAYS_B DP ,FND_LOOKUP_VALUES L1 WHERE AV.ACTION_ID = DP.ACTION_ID AND L1.VIEW_APPLICATION_ID = 0 AND L1.LANGUAGE = USERENV('LANG') AND L1.LOOKUP_CODE = DP.EXECUTION_METHOD AND L1.LOOKUP_TYPE = 'EGO_EF_ACTION_EXEC'

View Text - HTML Formatted

SELECT AV.ACTION_ID ACTION_ID
, AV.OBJECT_ID OBJECT_ID
, AV.CLASSIFICATION_CODE CLASSIFICATION_CODE
, AV.OBJ_NAME OBJ_NAME
, AV.OBJ_DISP_NAME OBJ_DISP_NAME
, AV.ATTR_GROUP_ID ATTR_GROUP_ID
, AV.ATTR_GRP_APPLICATION_ID ATTR_GRP_APPLICATION_ID
, AV.ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, AV.ATTR_GROUP_NAME ATTR_GROUP_NAME
, AV.ATTR_GROUP_DISP_NAME ATTR_GROUP_DISP_NAME
, AV.SEQUENCE SEQUENCE
, AV.ACTION_NAME ACTION_NAME
, AV.DESCRIPTION DESCRIPTION
, AV.FUNCTION_ID FUNCTION_ID
, AV.FUNC_DISPLAY_NAME FUNC_DISPLAY_NAME
, AV.SECURITY_PRIVILEGE_ID SECURITY_PRIVILEGE_ID
, AV.SECURITY_PRIVILEGE_NAME SECURITY_PRIVILEGE_NAME
, DP.DISPLAY_STYLE DISPLAY_STYLE_CODE
, DECODE (DP.EXECUTION_METHOD
, 'U'
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE VIEW_APPLICATION_ID = 0
AND LANGUAGE = USERENV('LANG')
AND LOOKUP_CODE = DP.DISPLAY_STYLE
AND LOOKUP_TYPE = 'EGO_EF_DISPLAY_STYLE')
, 'T'
, NULL) DISPLAY_STYLE_MEANING
, DP.PROMPT_APPLICATION_ID PROMPT_APPLICATION_ID
, DECODE (DP.EXECUTION_METHOD
, 'U'
, (SELECT APPLICATION_NAME
FROM FND_APPLICATION_TL
WHERE APPLICATION_ID = DP.PROMPT_APPLICATION_ID
AND LANGUAGE = USERENV('LANG'))
, 'T'
, NULL) PROMPT_APPLICATION_NAME
, DP.PROMPT_MESSAGE_NAME PROMPT_MESSAGE_NAME
, DP.VISIBILITY_FLAG VISIBILITY_FLAG
, DECODE (DP.EXECUTION_METHOD
, 'U'
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE VIEW_APPLICATION_ID = 0
AND LANGUAGE = USERENV('LANG')
AND LOOKUP_CODE = DP.VISIBILITY_FLAG
AND LOOKUP_TYPE = 'YES_NO')
, 'T'
, NULL) VISIBILITY_MEANING
, DP.PROMPT_FUNCTION_ID PROMPT_FUNC_ID
, DECODE (DP.EXECUTION_METHOD
, 'U'
, (SELECT DISPLAY_NAME
FROM EGO_FUNCTIONS_V
WHERE DP.PROMPT_FUNCTION_ID = FUNCTION_ID(+))
, 'T'
, NULL) PROMPT_FUNC_DISP_NAME
, DP.VISIBILITY_FUNC_ID VISIBILITY_FUNC_ID
, DECODE (DP.EXECUTION_METHOD
, 'U'
, (SELECT DISPLAY_NAME
FROM EGO_FUNCTIONS_V
WHERE DP.VISIBILITY_FUNC_ID = FUNCTION_ID(+))
, 'T'
, NULL) VISIBILITY_FUNC_DISP_NAME
, DP.EXECUTION_METHOD EXECUTION_CODE
, L1.MEANING EXECUTION_MEANING
, DP.EXECUTION_TRIGGER TRIGGER_CODE
, DECODE (DP.EXECUTION_METHOD
, 'T'
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE VIEW_APPLICATION_ID = 0
AND LANGUAGE = USERENV('LANG')
AND LOOKUP_CODE = DP.EXECUTION_TRIGGER
AND LOOKUP_TYPE = 'EGO_EF_TRIGGERS')
, 'U'
, NULL) TRIGGER_MEANING
FROM EGO_ACTIONS_V AV
, EGO_ACTION_DISPLAYS_B DP
, FND_LOOKUP_VALUES L1
WHERE AV.ACTION_ID = DP.ACTION_ID
AND L1.VIEW_APPLICATION_ID = 0
AND L1.LANGUAGE = USERENV('LANG')
AND L1.LOOKUP_CODE = DP.EXECUTION_METHOD
AND L1.LOOKUP_TYPE = 'EGO_EF_ACTION_EXEC'