DBA Data[Home] [Help] [Dependency Information]

TABLE: GME.GME_ERES_GTMP

Object Details
Object Name: GME_ERES_GTMP
Object Type: TABLE
Owner: GME
FND Design Data: TableGME.GME_ERES_GTMP
Subobject Name:
Status: VALID

Temporary Table Details

GME.GME_ERES_GTMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
EVENT_NAME VARCHAR2 (240)
Name of Event
EVENT_KEY VARCHAR2 (30)
Identify key of the event
TASK VARCHAR2 (32)
Task
ACTION_CODE VARCHAR2 (10)
Action of the event
USER_KEY_LABEL VARCHAR2 (240)
User defined key label of the event
USER_KEY_VALUE VARCHAR2 (240)
User defined key value of the event
POST_OP_API VARCHAR2 (4)
API to be executed after ERES
PARENT_EVENT VARCHAR2 (30)
Related event of ERES
PARENT_EVENT_KEY VARCHAR2 (30)
Related event Key
PARENT_ERECORD_ID NUMBER (32)
Related event ERES record key
ERECORD_ID NUMBER (32)
Task ERES record key
XML_GENERATION_API VARCHAR2 (300)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_NAME
,      EVENT_KEY
,      TASK
,      ACTION_CODE
,      USER_KEY_LABEL
,      USER_KEY_VALUE
,      POST_OP_API
,      PARENT_EVENT
,      PARENT_EVENT_KEY
,      PARENT_ERECORD_ID
,      ERECORD_ID
,      XML_GENERATION_API
FROM GME.GME_ERES_GTMP;

Dependencies

[top of page]

GME.GME_ERES_GTMP does not reference any database object

GME.GME_ERES_GTMP is referenced by following:

SchemaAPPS
SynonymGME_ERES_GTMP