View: EGO_ACTIONS_V

Product:	EGO - Advanced Product Catalog
Description:	This view contains information about User-Defined Actions.
Implementation/DBA Data:	APPS.EGO_ACTIONS_V

View Text

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')

Columns