View: EGO_ACTION_GROUPS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains information regarding User-Defined Actions Groups. (This table is obsolete)
Implementation/DBA Data:	APPS.EGO_ACTION_GROUPS_V

View Text

SELECT AG.ACTION_GROUP_ID ACTION_GROUP_ID
, AG.OBJECT_ID OBJ_ID
, OBJ.OBJ_NAME OBJ_NAME
, OBJ_TL.DISPLAY_NAME OBJ_DISPLAY_NAME
, AG.CLASSIFICATION_CODE CLASSIFICATION_CODE
, AG.SEQUENCE SEQUENCE
, AG.INTERNAL_NAME INTERNAL_NAME
, AG_TL.DISPLAY_NAME DISPLAY_NAME
, AG_TL.DESCRIPTION DESCRIPTION
FROM EGO_ACTION_GROUPS_B AG
, EGO_ACTION_GROUPS_TL AG_TL
, FND_OBJECTS OBJ
, FND_OBJECTS_TL OBJ_TL
WHERE AG.ACTION_GROUP_ID = AG_TL.ACTION_GROUP_ID
AND AG_TL.LANGUAGE = USERENV('LANG')
AND AG.OBJECT_ID = OBJ.OBJECT_ID
AND AG.OBJECT_ID = OBJ_TL.OBJECT_ID
AND OBJ_TL.LANGUAGE = USERENV('LANG')

Columns