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

TABLE: WSH.WSH_PR_WORKERS

Object Details
Object Name: WSH_PR_WORKERS
Object Type: TABLE
Owner: WSH
Subobject Name:
Status: VALID


Pick Release Workers


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSH_PR_WORKERS_N1 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnNVL("INVENTORY_ITEM_ID",(-99))
WSH_PR_WORKERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnDELIVERY_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

WSH.WSH_PR_WORKERS does not reference any database object

WSH.WSH_PR_WORKERS is referenced by following:

SchemaWSH
ViewWSH_PR_WORKERS#