eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WMS.WMS_DIRECT_SHIP_TEMP

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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
SECONDARY_PROCESSED_QTY	NUMBER			Secondary Processed Quantity

Query Text

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
,      SECONDARY_PROCESSED_QTY
FROM WMS.WMS_DIRECT_SHIP_TEMP;

Dependencies

[top of page]

WMS.WMS_DIRECT_SHIP_TEMP does not reference any database object

WMS.WMS_DIRECT_SHIP_TEMP is referenced by following:

WMS: WMS_DIRECT_SHIP_TEMP#