[Home] [Help]
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
Name |
ACTION_GROUP_ID |
OBJ_ID |
OBJ_NAME |
OBJ_DISPLAY_NAME |
CLASSIFICATION_CODE |
SEQUENCE |
INTERNAL_NAME |
DISPLAY_NAME |
DESCRIPTION |