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

TABLE: EGO.EGO_PUBLICATION_BATCH_GT

Object Details
Object Name: EGO_PUBLICATION_BATCH_GT
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.EGO_PUBLICATION_BATCH_GT
Subobject Name:
Status: VALID

Temporary Table Details

EGO.EGO_PUBLICATION_BATCH_GT 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$SESSION. 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
BATCH_ENTITY_OBJECT_ID NUMBER

BATCH_ID NUMBER

SYSTEM_CODE VARCHAR2 (30)
PK1_VALUE VARCHAR2 (150)
PK2_VALUE VARCHAR2 (150)
PK3_VALUE VARCHAR2 (150)
PK4_VALUE VARCHAR2 (150)
PK5_VALUE VARCHAR2 (150)
STATUS VARCHAR2 (1)
MESSAGE VARCHAR2 (4000)
USER_ENTERED VARCHAR2 (1)
RETURN_STATUS VARCHAR2 (1)
RETURN_ERROR_MESSAGE VARCHAR2 (4000)
RETURN_ERROR_CODE VARCHAR2 (4000)
RET_ERR_MSG_LANG VARCHAR2 (4)
PROCESS_FLAG NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

ENTITY_TYPE_ID NUMBER

Query Text

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


SELECT BATCH_ENTITY_OBJECT_ID
,      BATCH_ID
,      SYSTEM_CODE
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      STATUS
,      MESSAGE
,      USER_ENTERED
,      RETURN_STATUS
,      RETURN_ERROR_MESSAGE
,      RETURN_ERROR_CODE
,      RET_ERR_MSG_LANG
,      PROCESS_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENTITY_TYPE_ID
FROM EGO.EGO_PUBLICATION_BATCH_GT;

Dependencies

[top of page]

EGO.EGO_PUBLICATION_BATCH_GT does not reference any database object

EGO.EGO_PUBLICATION_BATCH_GT is referenced by following:

SchemaAPPS
SynonymEGO_PUBLICATION_BATCH_GT