View: EGO_ACTION_DISPLAYS_V

Product:	EGO - Advanced Product Catalog
Description:	This view contains particulars for UI interface for the actions
Implementation/DBA Data:	APPS.EGO_ACTION_DISPLAYS_V

View Text

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'

Columns