[Home] [Help] [Dependency Information]
Object Name: | ZPB_WRITEBACK_TASKS |
---|---|
Object Type: | TABLE |
Owner: | ZPB |
Subobject Name: | |
Status: | VALID |
Stores the common parameters used by a specific Writeback concurrent request
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZPB_WRITEBACK_TASKS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TASK_SEQ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_TYPE | VARCHAR2 | (4) | Task type | |
USER_ID | VARCHAR2 | (80) | Yes | User identifier |
RESP_ID | VARCHAR2 | (100) | Yes | Responsibility identifier |
SESSION_ID | NUMBER | Yes | Session identifier | |
TASK_SEQ | NUMBER | Yes | Task sequence | |
PRIORITY | NUMBER | (1) | Task priority | |
SUBMIT_DATE | DATE | Submission date | ||
STATUS | VARCHAR2 | (12) | Yes | Task status |
COMPLETION_DATE | DATE | Task completion date | ||
WRITE_AWS | VARCHAR2 | (80) | ||
READ_AWS | VARCHAR2 | (80) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
BUSINESS_AREA_ID | NUMBER | (15) | Yes | Business area identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_TYPE
, USER_ID
, RESP_ID
, SESSION_ID
, TASK_SEQ
, PRIORITY
, SUBMIT_DATE
, STATUS
, COMPLETION_DATE
, WRITE_AWS
, READ_AWS
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, BUSINESS_AREA_ID
FROM ZPB.ZPB_WRITEBACK_TASKS;
ZPB.ZPB_WRITEBACK_TASKS does not reference any database object
ZPB.ZPB_WRITEBACK_TASKS is referenced by following:
|
|
|