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: WSH.WSH_DELIVERY_LEG_DETAILS

Object Details

Object Name:	WSH_DELIVERY_LEG_DETAILS
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_DELIVERY_LEG_DETAILS
Subobject Name:
Status:	VALID

WSH_DELIVERY_LEG_DETAILS stores pick-up/drop-off information for each delivery line of a delivery leg.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_DELIVERY_LEG_DETAILS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_LEG_ID DELIVERY_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_LEG_ID	NUMBER		Yes	Delivery leg identifier (foreign key to WSH_DELIVERY_LEGS)
DELIVERY_DETAIL_ID	NUMBER		Yes	Delivery detail identifier (foreign key to WSH_DELIVERY_DETAILS)
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
DELIVERED_QUANTITY	NUMBER			Delivered Quantity
LOADED_QUANTITY	NUMBER			Loaded Quantity
RECEIVED_QUANTITY	NUMBER			Received Quantity. Applicable only if last leg for a delivery
ACTUAL_ARRIVAL_DATE	DATE			Date on which the delivery arrived at the drop-off stop
ACTUAL_DEPARTURE_DATE	DATE			Date on which the delivery departed from pick-up stop.
ACTUAL_RECEIPT_DATE	DATE			Date on which the delivery was received. Applicable only if last leg for a delivery.
STATUS_CODE	VARCHAR2	(240)		Leg Detail Status Code based on lookup type WSH_DELIVERY_LEG_DETAILS_STATUS
TRACKING_REMARKS	VARCHAR2	(240)		Tracking related remarks
CARRIER_EST_DEPARTURE_DATE	DATE			Departure Date estimated by Carrier
CARRIER_EST_ARRIVAL_DATE	DATE			Arrival Date estimated by Carrier
LOADING_START_DATETIME	DATE			Date/Time when Loading started
LOADING_END_DATETIME	DATE			Date/Time when Loading ended
UNLOADING_START_DATETIME	DATE			Date/Time when Unloading started
UNLOADING_END_DATETIME	DATE			Date/Time when Unloading ended

Query Text

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


SELECT DELIVERY_LEG_ID
,      DELIVERY_DETAIL_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      DELIVERED_QUANTITY
,      LOADED_QUANTITY
,      RECEIVED_QUANTITY
,      ACTUAL_ARRIVAL_DATE
,      ACTUAL_DEPARTURE_DATE
,      ACTUAL_RECEIPT_DATE
,      STATUS_CODE
,      TRACKING_REMARKS
,      CARRIER_EST_DEPARTURE_DATE
,      CARRIER_EST_ARRIVAL_DATE
,      LOADING_START_DATETIME
,      LOADING_END_DATETIME
,      UNLOADING_START_DATETIME
,      UNLOADING_END_DATETIME
FROM WSH.WSH_DELIVERY_LEG_DETAILS;

Dependencies

[top of page]

WSH.WSH_DELIVERY_LEG_DETAILS does not reference any database object

WSH.WSH_DELIVERY_LEG_DETAILS is referenced by following:

APPS: WSH_DELIVERY_LEG_DETAILS