[Home] [Help] [Dependency Information]
Object Name: | WSH_PR_WORKERS |
---|---|
Object Type: | TABLE |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
Pick Release Workers
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_PR_WORKERS_N1 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_INTERFACE | NVL("INVENTORY_ITEM_ID",(-99)) |
WSH_PR_WORKERS_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | DELIVERY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | Batch Id of the pick release request | |
TYPE | VARCHAR2 | (10) | Yes | Type of the Worker Record ('PICK','DOC','WMS','PS','PRINTER') |
ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
MO_HEADER_ID | NUMBER | Move Order Header Id | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
MO_START_LINE_NUMBER | NUMBER | Move Order Line Starting Number | ||
MO_LINE_COUNT | NUMBER | Move Order Line Count | ||
DETAILED_COUNT | NUMBER | Count of Records Detailed | ||
PA_SC_BATCH_ID | NUMBER | 'Auto Pack'/'Auto Ship Confirm' Batch Id | ||
DELIVERY_ID | NUMBER | Delivery Id | ||
PICKUP_LOCATION_ID | NUMBER | Pickup Location Id | ||
AP_LEVEL | NUMBER | Auto Pack Level | ||
SC_RULE_ID | NUMBER | Ship Confirm Rule Id | ||
PROCESSED | VARCHAR2 | (1) | Processed (Y/N) | |
PRINTER_NAME | VARCHAR2 | (30) | Printer Name | |
CONC_PROGRAM_NAME | VARCHAR2 | (30) | Concurrent Program Name |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, TYPE
, ORGANIZATION_ID
, MO_HEADER_ID
, INVENTORY_ITEM_ID
, MO_START_LINE_NUMBER
, MO_LINE_COUNT
, DETAILED_COUNT
, PA_SC_BATCH_ID
, DELIVERY_ID
, PICKUP_LOCATION_ID
, AP_LEVEL
, SC_RULE_ID
, PROCESSED
, PRINTER_NAME
, CONC_PROGRAM_NAME
FROM WSH.WSH_PR_WORKERS;
WSH.WSH_PR_WORKERS does not reference any database object
WSH.WSH_PR_WORKERS is referenced by following:
|
|
|