[Home] [Help] [Dependency Information]
Object Name: | WMS_PR_WORKERS |
---|---|
Object Type: | TABLE |
Owner: | WMS |
Subobject Name: | |
Status: | VALID |
WMS Pick Release Workers
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_PR_WORKERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRANSACTION_BATCH_ID |
WMS_PR_WORKERS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CARTONIZATION_ID |
WMS_PR_WORKERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BATCH_ID
WORKER_MODE PROCESSED_FLAG |
WMS_PR_WORKERS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | batch id | |
WORKER_MODE | VARCHAR2 | (10) | Yes | worker mode |
PROCESSED_FLAG | VARCHAR2 | (1) | Yes | processed flag |
ORGANIZATION_ID | NUMBER | Yes | organization id | |
MO_HEADER_ID | NUMBER | Yes | move order header id | |
TRANSACTION_BATCH_ID | NUMBER | transaction batch id | ||
CARTONIZATION_ID | NUMBER | cartonization id | ||
DETAILED_COUNT | NUMBER | detailed count |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, WORKER_MODE
, PROCESSED_FLAG
, ORGANIZATION_ID
, MO_HEADER_ID
, TRANSACTION_BATCH_ID
, CARTONIZATION_ID
, DETAILED_COUNT
FROM WMS.WMS_PR_WORKERS;
WMS.WMS_PR_WORKERS does not reference any database object
WMS.WMS_PR_WORKERS is referenced by following:
|
|
|