VIEW: APPS.EGO_ACTION_GROUPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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