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_SHIPPING_TRANSACTION_TEMP

Object Details

Object Name:	WMS_SHIPPING_TRANSACTION_TEMP
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_SHIPPING_TRANSACTION_TEMP
Subobject Name:
Status:	VALID

WMS_SHIPPING_TRANSACTION_TEMP stores information to be used in mobile ship confirmation. Basically it stores all the LPNs which have been loaded to the trucks but have not been ship confirmed yet. Upon ship confirmation, the corresponding records in this table will be removed.
The context of LPNs in this table is Loaded to Truck.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_SHIPPING_TXN_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID DOCK_DOOR_ID TRIP_ID
WMS_SHIPPING_TXN_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_DETAIL_ID
WMS_SHIPPING_TXN_TEMP_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OUTERMOST_LPN_ID
WMS_SHIPPING_TXN_TEMP_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_ID INVENTORY_ITEM_ID
WMS_SHIPPING_TXN_TEMP_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_LPN_ID

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		Organization identifier
DOCK_DOOR_ID	NUMBER		Dock Door identifier
TRIP_ID	NUMBER		Trip identifier
TRIP_NAME	VARCHAR2	(30)	Trip Name
DELIVERY_ID	NUMBER		Delivery identifier
DELIVERY_NAME	VARCHAR2	(30)	Delivery Name
DELIVERY_DETAIL_ID	NUMBER		Delivery line identifier
LPN_CONTENT_ID	NUMBER		LPN content identifier
PARENT_LPN_ID	NUMBER		LPN identifier
PARENT_LPN	VARCHAR2	(30)	LPN name
OUTERMOST_LPN_ID	NUMBER		Master LPN identifier
OUTERMOST_LPN	VARCHAR2	(30)	Master LPN name
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
STAGING_LANE_ID	NUMBER		Staging lane identifier
REQUESTED_QUANTITY	NUMBER		Requested quantity
QUANTITY	NUMBER		Quantity the LPN contains
DOCK_APPOINT_FLAG	VARCHAR2	(1)	This flag indicates if the shipment is through dock loading ('Y') or not ('N')
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
DIRECT_SHIP_FLAG	VARCHAR2	(1)	Direct Ship Flag
ORIG_RELEASE_STATUS	VARCHAR2	(1)	Original Release Status

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_ID
,      DOCK_DOOR_ID
,      TRIP_ID
,      TRIP_NAME
,      DELIVERY_ID
,      DELIVERY_NAME
,      DELIVERY_DETAIL_ID
,      LPN_CONTENT_ID
,      PARENT_LPN_ID
,      PARENT_LPN
,      OUTERMOST_LPN_ID
,      OUTERMOST_LPN
,      INVENTORY_ITEM_ID
,      STAGING_LANE_ID
,      REQUESTED_QUANTITY
,      QUANTITY
,      DOCK_APPOINT_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DIRECT_SHIP_FLAG
,      ORIG_RELEASE_STATUS
FROM WMS.WMS_SHIPPING_TRANSACTION_TEMP;

Dependencies

[top of page]

WMS.WMS_SHIPPING_TRANSACTION_TEMP does not reference any database object

WMS.WMS_SHIPPING_TRANSACTION_TEMP is referenced by following:

APPS: WMS_SHIPPING_TRANSACTION_TEMP