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

VIEW: WSH.WSH_DELIVERY_LEGS#

Object Details
Object Name: WSH_DELIVERY_LEGS#
Object Type: VIEW
Owner: WSH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DELIVERY_LEG_ID NUMBER
Yes
DELIVERY_ID NUMBER
Yes
SEQUENCE_NUMBER NUMBER
Yes
LOADING_ORDER_FLAG VARCHAR2 (2)
PICK_UP_STOP_ID NUMBER
Yes
DROP_OFF_STOP_ID NUMBER
Yes
GROSS_WEIGHT NUMBER

NET_WEIGHT NUMBER

WEIGHT_UOM_CODE VARCHAR2 (3)
VOLUME NUMBER

VOLUME_UOM_CODE VARCHAR2 (3)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

LOAD_TENDER_STATUS VARCHAR2 (1)
SHIPPER_TITLE VARCHAR2 (20)
SHIPPER_PHONE VARCHAR2 (20)
POD_FLAG VARCHAR2 (1)
POD_BY VARCHAR2 (150)
POD_DATE DATE

EXPECTED_POD_DATE DATE

BOOKING_OFFICE VARCHAR2 (50)
SHIPPER_EXPORT_REF VARCHAR2 (30)
CARRIER_EXPORT_REF VARCHAR2 (30)
DOC_NOTIFY_PARTY VARCHAR2 (30)
AETC_NUMBER VARCHAR2 (30)
SHIPPER_SIGNED_BY VARCHAR2 (150)
SHIPPER_DATE DATE

CARRIER_SIGNED_BY VARCHAR2 (150)
CARRIER_DATE DATE

DOC_ISSUE_OFFICE VARCHAR2 (150)
DOC_ISSUED_BY VARCHAR2 (150)
DOC_DATE_ISSUED DATE

SHIPPER_HM_BY VARCHAR2 (150)
SHIPPER_HM_DATE DATE

CARRIER_HM_BY VARCHAR2 (150)
CARRIER_HM_DATE DATE

BOOKING_NUMBER VARCHAR2 (30)
PORT_OF_LOADING VARCHAR2 (150)
PORT_OF_DISCHARGE VARCHAR2 (150)
SERVICE_CONTRACT VARCHAR2 (30)
BILL_FREIGHT_TO VARCHAR2 (1000)
FTE_TRIP_ID NUMBER

REPRICE_REQUIRED VARCHAR2 (1)
ACTUAL_ARRIVAL_DATE DATE

ACTUAL_DEPARTURE_DATE DATE

ACTUAL_RECEIPT_DATE DATE

TRACKING_DRILLDOWN_FLAG VARCHAR2 (1)
STATUS_CODE VARCHAR2 (30)
TRACKING_REMARKS VARCHAR2 (4000)
CARRIER_EST_DEPARTURE_DATE DATE

CARRIER_EST_ARRIVAL_DATE DATE

LOADING_START_DATETIME DATE

LOADING_END_DATETIME DATE

UNLOADING_START_DATETIME DATE

UNLOADING_END_DATETIME DATE

DELIVERED_QUANTITY NUMBER

LOADED_QUANTITY NUMBER

RECEIVED_QUANTITY NUMBER

ORIGIN_STOP_ID NUMBER

DESTINATION_STOP_ID NUMBER

PARENT_DELIVERY_LEG_ID NUMBER

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# references the following:

SchemaWSH
TableWSH_DELIVERY_LEGS
WSH.WSH_DELIVERY_LEGS# is referenced by following:

SchemaAPPS
SynonymWSH_DELIVERY_LEGS