VIEW: WSH.WSH_DELIVERY_LEGS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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