[Home] [Help] [Dependency Information]
Object Name: | WMS_DIRECT_SHIP_TEMP |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.WMS_DIRECT_SHIP_TEMP |
Subobject Name: | |
Status: | VALID |
WMS_DIRECT_SHIP_TEMP temporarily stores the records with LPN and Sales Order Information for processing the direct ship of LPN against the Sales Oder/Sales Order Line without Pick Release and Pick Confirm.
.
.
.
The records in this table get inserted through the Mobile Page 'Load Truck' . The Mobile Page 'Load Truck' is available only if WMS is installed. After processing, the records in this table are deleted.
.
.
.
A set of temporary records in this table get same GROUP_ID, so that they can be processed together. If a record in WMS_DIRECT_SHIP_TEMP(WDST) has Sales Order line whose Item is Serial Controlled at Sales Order Issue, then the Serials are captured in the table MTL_SERIAL_NUMBERS_TEMP(MSNT). In this case, WDST.TRANSACTION_TEMP_ID joins to MSNT.TRANSACTION_TEMP_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_DS_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
GROUP_ID
ORGANIZATION_ID DOCK_DOOR_ID LPN_ID |
WMS_DS_TEMP_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
LPN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Yes | Group Identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
DOCK_DOOR_ID | NUMBER | Yes | Dock Door Identifer | |
LPN_ID | NUMBER | Yes | LPN Identifier | |
ORDER_HEADER_ID | NUMBER | Order Header Identifier | ||
ORDER_LINE_ID | NUMBER | Order Line Identifier | ||
LINE_ITEM_ID | NUMBER | Line Item Identifier | ||
TRANSACTION_TEMP_ID | NUMBER | Transaction Temp Identifer | ||
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
REQUEST_ID | NUMBER | Concurrent WHO Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent WHO Column | ||
PROGRAM_ID | NUMBER | Concurrent WHO Column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent WHO Column | ||
PROCESSED_QUANTITY | NUMBER | Processed Quantity | ||
PROCESSED_FLAG | VARCHAR2 | (1) | Processed the quantity or not | |
SERIAL_REQUIRED_FLAG | VARCHAR2 | (1) | Serial Control of Order Line Item |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_ID
, ORGANIZATION_ID
, DOCK_DOOR_ID
, LPN_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, LINE_ITEM_ID
, TRANSACTION_TEMP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROCESSED_QUANTITY
, PROCESSED_FLAG
, SERIAL_REQUIRED_FLAG
FROM WMS.WMS_DIRECT_SHIP_TEMP;
WMS.WMS_DIRECT_SHIP_TEMP does not reference any database object
WMS.WMS_DIRECT_SHIP_TEMP is referenced by following:
|
|
|