[Home] [Help]
[Dependency Information]
| Object Name: | EGO_PUBLICATION_BATCH_GT |
|---|---|
| Object Type: | TABLE |
| Owner: | EGO |
| FND Design Data: | EGO.EGO_PUBLICATION_BATCH_GT
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: | ![]() |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| 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 |
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;
EGO.EGO_PUBLICATION_BATCH_GT does not reference any database object
EGO.EGO_PUBLICATION_BATCH_GT is referenced by following:
APPS
EGO_PUBLICATION_BATCH_GT
|
|
|
|