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: TableWSH.WSH_DELIVERY_LEGS
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSH_DELIVERY_LEGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERY_LEG_ID
WSH_DELIVERY_LEGS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERY_ID
WSH_DELIVERY_LEGS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPICK_UP_STOP_ID
WSH_DELIVERY_LEGS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDROP_OFF_STOP_ID
WSH_DELIVERY_LEGS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_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:

SchemaAPPS
SynonymWSH_DELIVERY_LEGS