VIEW: APPS.EGO_ACTIONS_V

Source

View Text - Preformatted

SELECT AC.ACTION_ID AS ACTION_ID , AC.OBJECT_ID AS OBJECT_ID , AC.CLASSIFICATION_CODE AS CLASSIFICATION_CODE , AC.ENABLE_KEY_ATTRIBUTES AS ENABLE_KEY_ATTRIBUTES , OBJ.OBJ_NAME AS OBJ_NAME , OBJ_TL.DISPLAY_NAME AS OBJ_DISP_NAME , AC.ATTR_GROUP_ID AS ATTR_GROUP_ID , EXT.APPLICATION_ID AS ATTR_GRP_APPLICATION_ID , EXT.DESCRIPTIVE_FLEXFIELD_NAME AS ATTR_GROUP_TYPE , EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE AS ATTR_GROUP_NAME , AG_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME AS ATTR_GROUP_DISP_NAME , AC.SEQUENCE AS SEQUENCE , AC.ACTION_NAME AS ACTION_NAME , AC_TL.DESCRIPTION AS DESCRIPTION , AC.FUNCTION_ID AS FUNCTION_ID , FN_TL.DISPLAY_NAME AS FUNC_DISPLAY_NAME , AC.SECURITY_PRIVILEGE_ID AS SECURITY_PRIVILEGE_ID , SEC_TL.USER_FUNCTION_NAME AS SECURITY_PRIVILEGE_NAME FROM EGO_ACTIONS_B AC , EGO_ACTIONS_TL AC_TL , FND_OBJECTS OBJ , FND_OBJECTS_TL OBJ_TL , EGO_FND_DSC_FLX_CTX_EXT EXT , FND_DESCR_FLEX_CONTEXTS_TL AG_TL , EGO_FUNCTIONS_TL FN_TL , FND_FORM_FUNCTIONS_TL SEC_TL WHERE AC.ACTION_ID = AC_TL.ACTION_ID AND AC_TL.LANGUAGE = USERENV('LANG') AND AC.OBJECT_ID = OBJ.OBJECT_ID AND OBJ_TL.OBJECT_ID = AC.OBJECT_ID AND OBJ_TL.LANGUAGE = USERENV('LANG') AND AC.ATTR_GROUP_ID = EXT.ATTR_GROUP_ID(+) AND AG_TL.APPLICATION_ID (+) = EXT.APPLICATION_ID AND AG_TL.DESCRIPTIVE_FLEXFIELD_NAME (+) = EXT.DESCRIPTIVE_FLEXFIELD_NAME AND AG_TL.DESCRIPTIVE_FLEX_CONTEXT_CODE (+) = EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE AND AG_TL.LANGUAGE (+) = USERENV('LANG') AND AC.FUNCTION_ID = FN_TL.FUNCTION_ID AND FN_TL.LANGUAGE = USERENV('LANG') AND AC.SECURITY_PRIVILEGE_ID = SEC_TL.FUNCTION_ID (+) AND SEC_TL.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT AC.ACTION_ID AS ACTION_ID
, AC.OBJECT_ID AS OBJECT_ID
, AC.CLASSIFICATION_CODE AS CLASSIFICATION_CODE
, AC.ENABLE_KEY_ATTRIBUTES AS ENABLE_KEY_ATTRIBUTES
, OBJ.OBJ_NAME AS OBJ_NAME
, OBJ_TL.DISPLAY_NAME AS OBJ_DISP_NAME
, AC.ATTR_GROUP_ID AS ATTR_GROUP_ID
, EXT.APPLICATION_ID AS ATTR_GRP_APPLICATION_ID
, EXT.DESCRIPTIVE_FLEXFIELD_NAME AS ATTR_GROUP_TYPE
, EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE AS ATTR_GROUP_NAME
, AG_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME AS ATTR_GROUP_DISP_NAME
, AC.SEQUENCE AS SEQUENCE
, AC.ACTION_NAME AS ACTION_NAME
, AC_TL.DESCRIPTION AS DESCRIPTION
, AC.FUNCTION_ID AS FUNCTION_ID
, FN_TL.DISPLAY_NAME AS FUNC_DISPLAY_NAME
, AC.SECURITY_PRIVILEGE_ID AS SECURITY_PRIVILEGE_ID
, SEC_TL.USER_FUNCTION_NAME AS SECURITY_PRIVILEGE_NAME
FROM EGO_ACTIONS_B AC
, EGO_ACTIONS_TL AC_TL
, FND_OBJECTS OBJ
, FND_OBJECTS_TL OBJ_TL
, EGO_FND_DSC_FLX_CTX_EXT EXT
, FND_DESCR_FLEX_CONTEXTS_TL AG_TL
, EGO_FUNCTIONS_TL FN_TL
, FND_FORM_FUNCTIONS_TL SEC_TL
WHERE AC.ACTION_ID = AC_TL.ACTION_ID
AND AC_TL.LANGUAGE = USERENV('LANG')
AND AC.OBJECT_ID = OBJ.OBJECT_ID
AND OBJ_TL.OBJECT_ID = AC.OBJECT_ID
AND OBJ_TL.LANGUAGE = USERENV('LANG')
AND AC.ATTR_GROUP_ID = EXT.ATTR_GROUP_ID(+)
AND AG_TL.APPLICATION_ID (+) = EXT.APPLICATION_ID
AND AG_TL.DESCRIPTIVE_FLEXFIELD_NAME (+) = EXT.DESCRIPTIVE_FLEXFIELD_NAME
AND AG_TL.DESCRIPTIVE_FLEX_CONTEXT_CODE (+) = EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND AG_TL.LANGUAGE (+) = USERENV('LANG')
AND AC.FUNCTION_ID = FN_TL.FUNCTION_ID
AND FN_TL.LANGUAGE = USERENV('LANG')
AND AC.SECURITY_PRIVILEGE_ID = SEC_TL.FUNCTION_ID (+)
AND SEC_TL.LANGUAGE (+) = USERENV('LANG')