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_LEGS

Object Details

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

WSH_DELIVERY_LEGS maps deliveries to their pick up and drop off stops.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_DELIVERY_LEGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DELIVERY_LEG_ID
WSH_DELIVERY_LEGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_ID
WSH_DELIVERY_LEGS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PICK_UP_STOP_ID
WSH_DELIVERY_LEGS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DROP_OFF_STOP_ID
WSH_DELIVERY_LEGS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_DELIVERY_LEG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_LEG_ID	NUMBER		Yes	Primary Key for delivery leg
DELIVERY_ID	NUMBER		Yes	Delivery identifier for this leg
SEQUENCE_NUMBER	NUMBER		Yes	Sequence number of legs for this delivery
LOADING_ORDER_FLAG	VARCHAR2	(2)		Order in which delivery is loaded
PICK_UP_STOP_ID	NUMBER		Yes	Pick-up stop identifier for the leg
DROP_OFF_STOP_ID	NUMBER		Yes	Drop-off stop identifier for the leg
GROSS_WEIGHT	NUMBER			Gross Weight
NET_WEIGHT	NUMBER			Net Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)		Unit of Measure for weight
VOLUME	NUMBER			Volume
VOLUME_UOM_CODE	VARCHAR2	(3)		Unit of Measure for volume
CREATION_DATE	DATE		Yes	Standard Who columns
CREATED_BY	NUMBER		Yes	Standard Who columns
LAST_UPDATE_DATE	DATE		Yes	Standard Who columns
LAST_UPDATED_BY	NUMBER		Yes	Standard Who columns
LAST_UPDATE_LOGIN	NUMBER			Standard Who columns
PROGRAM_APPLICATION_ID	NUMBER			Standard Who columns
PROGRAM_ID	NUMBER			Standard Who columns
PROGRAM_UPDATE_DATE	DATE			Standard Who columns
REQUEST_ID	NUMBER			Standard Who columns
LOAD_TENDER_STATUS	VARCHAR2	(1)		Load Tender Status: N - Not tendered, L - tendered, D - Retendered, A - Accepted, C - Canceled, R - Rejected
SHIPPER_TITLE	VARCHAR2	(20)		Shipper Title
SHIPPER_PHONE	VARCHAR2	(20)		Shipper Phone Number
POD_FLAG	VARCHAR2	(1)		Proof Of Delivery Identifier
POD_BY	VARCHAR2	(150)		Name of the Person who signed the Proof of delivery
POD_DATE	DATE			Date the proof of delivery was signed
EXPECTED_POD_DATE	DATE			Date the proof od delivery is expected by the Shipper.
BOOKING_OFFICE	VARCHAR2	(50)		Booking Office
SHIPPER_EXPORT_REF	VARCHAR2	(30)		Export Reference of the Shipper.
CARRIER_EXPORT_REF	VARCHAR2	(30)		Export Reference of the Carrier.
DOC_NOTIFY_PARTY	VARCHAR2	(30)		Party to notify when the goods have been delivered to a specified location
AETC_NUMBER	VARCHAR2	(30)		AETC Number associated with the document
SHIPPER_SIGNED_BY	VARCHAR2	(150)		Person who signed off on the document for the shipper.
SHIPPER_DATE	DATE			Date the document was signed off by the Shipper.
CARRIER_SIGNED_BY	VARCHAR2	(150)		Name of the Person who signed off on the Document for the Carrier.
CARRIER_DATE	DATE			Date the Carrier signed off on the Document.
DOC_ISSUE_OFFICE	VARCHAR2	(150)		Name of the Office that issued the document
DOC_ISSUED_BY	VARCHAR2	(150)		Person or company that issued the document.
DOC_DATE_ISSUED	DATE			Date the document was issued.
SHIPPER_HM_BY	VARCHAR2	(150)		Name of the Person who signed off on the Hazardous Materials in the Load for the Shipper.
SHIPPER_HM_DATE	DATE			Date the Shipper signed off on the Hazardous Materials on the Document
CARRIER_HM_BY	VARCHAR2	(150)		Name of the Person who signed off on the Hazardous Materials in the load for the Carrier.
CARRIER_HM_DATE	DATE			Date the carrier signed off on the Hazardous Materials on the document.
BOOKING_NUMBER	VARCHAR2	(30)		Number referring to the booking of the document.
PORT_OF_LOADING	VARCHAR2	(150)		Port where the goods were loaded onto the carrier's transport.
PORT_OF_DISCHARGE	VARCHAR2	(150)		Port where the goods were unloaded from the Carrier's Transport.
SERVICE_CONTRACT	VARCHAR2	(30)		Service Contract Number
BILL_FREIGHT_TO	VARCHAR2	(1000)		Person or Company the freight charges are to be paid to
FTE_TRIP_ID	NUMBER			Foreign key to FTE_TRIPS to associate a delivery leg with an advanced trip
REPRICE_REQUIRED	VARCHAR2	(1)		Re-price required (Y/N)
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 the pick-up stop
ACTUAL_RECEIPT_DATE	DATE			Date on which the delivery was received. Applicable only if last leg for a delivery
TRACKING_DRILLDOWN_FLAG	VARCHAR2	(1)		Tracking Drilldown Flag (Y - entire delivery was not picked up/dropped off at the same time, N - entire delivery was picked up/dropped off at the same time)
STATUS_CODE	VARCHAR2	(30)		Delivery Leg's status code of lookup type WSH_DELIVERY_LEG_STATUS
TRACKING_REMARKS	VARCHAR2	(4000)		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
DELIVERED_QUANTITY	NUMBER			Delivered Quantity
LOADED_QUANTITY	NUMBER			Loaded Quantity
RECEIVED_QUANTITY	NUMBER			Received Quantity. Applicable only if last leg for a delivery
ORIGIN_STOP_ID	NUMBER			Foreign key to WSH_TRIP_STOPS. Used by FTE application to indicate the stop/location from which the lane originates (first stop of trip).
DESTINATION_STOP_ID	NUMBER			Foreign key to WSH_TRIP_STOPS. Used by FTE application to indicate the stop/location at which the lane ends (last stop of trip).
PARENT_DELIVERY_LEG_ID	NUMBER			Parent delivery leg identifier

Query Text

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


SELECT DELIVERY_LEG_ID
,      DELIVERY_ID
,      SEQUENCE_NUMBER
,      LOADING_ORDER_FLAG
,      PICK_UP_STOP_ID
,      DROP_OFF_STOP_ID
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LOAD_TENDER_STATUS
,      SHIPPER_TITLE
,      SHIPPER_PHONE
,      POD_FLAG
,      POD_BY
,      POD_DATE
,      EXPECTED_POD_DATE
,      BOOKING_OFFICE
,      SHIPPER_EXPORT_REF
,      CARRIER_EXPORT_REF
,      DOC_NOTIFY_PARTY
,      AETC_NUMBER
,      SHIPPER_SIGNED_BY
,      SHIPPER_DATE
,      CARRIER_SIGNED_BY
,      CARRIER_DATE
,      DOC_ISSUE_OFFICE
,      DOC_ISSUED_BY
,      DOC_DATE_ISSUED
,      SHIPPER_HM_BY
,      SHIPPER_HM_DATE
,      CARRIER_HM_BY
,      CARRIER_HM_DATE
,      BOOKING_NUMBER
,      PORT_OF_LOADING
,      PORT_OF_DISCHARGE
,      SERVICE_CONTRACT
,      BILL_FREIGHT_TO
,      FTE_TRIP_ID
,      REPRICE_REQUIRED
,      ACTUAL_ARRIVAL_DATE
,      ACTUAL_DEPARTURE_DATE
,      ACTUAL_RECEIPT_DATE
,      TRACKING_DRILLDOWN_FLAG
,      STATUS_CODE
,      TRACKING_REMARKS
,      CARRIER_EST_DEPARTURE_DATE
,      CARRIER_EST_ARRIVAL_DATE
,      LOADING_START_DATETIME
,      LOADING_END_DATETIME
,      UNLOADING_START_DATETIME
,      UNLOADING_END_DATETIME
,      DELIVERED_QUANTITY
,      LOADED_QUANTITY
,      RECEIVED_QUANTITY
,      ORIGIN_STOP_ID
,      DESTINATION_STOP_ID
,      PARENT_DELIVERY_LEG_ID
FROM WSH.WSH_DELIVERY_LEGS;

Dependencies

[top of page]

WSH.WSH_DELIVERY_LEGS does not reference any database object

WSH.WSH_DELIVERY_LEGS is referenced by following:

APPS: WSH_DELIVERY_LEGS