VIEW: FTE.FTE_SHIPMENT_STATUS_HEADERS#

Source

View Text - Preformatted

select DELIVERY_ID DELIVERY_ID, DELIVERY_LEG_ID DELIVERY_LEG_ID, MESSAGE_TYPE MESSAGE_TYPE, SHIPMENT_STATUS_ID SHIPMENT_STATUS_ID, CARRIER_NAME CARRIER_NAME, GENERATION_DATE GENERATION_DATE, STATUS STATUS, TRACKING_ID TRACKING_ID, TRACKING_ID_TYPE TRACKING_ID_TYPE, BILL_OF_LADING BILL_OF_LADING, CARRIER_SERVICE_LEVEL CARRIER_SERVICE_LEVEL, CONTAINER_ID CONTAINER_ID, CONTAINER_SEAL CONTAINER_SEAL, ARRIVAL_DATE ARRIVAL_DATE, RECEIVED_DATE RECEIVED_DATE, DELIVERY_SCHEDULED_DATE DELIVERY_SCHEDULED_DATE, DEPARTURE_DATE DEPARTURE_DATE, ESTIMATED_ARRIVAL_DATE ESTIMATED_ARRIVAL_DATE, ESTIMATED_DEPARTURE_DATE ESTIMATED_DEPARTURE_DATE, BEGIN_LOADING_DATE BEGIN_LOADING_DATE, END_LOADING_DATE END_LOADING_DATE, PROMISED_SHIPMENT_DATE PROMISED_SHIPMENT_DATE, PROMISED_DELIVERY_DATE PROMISED_DELIVERY_DATE, SHIPPED_DATE SHIPPED_DATE, EXPECTED_SHIPMENT_DATE EXPECTED_SHIPMENT_DATE, BEGIN_UNLOADING_DATE BEGIN_UNLOADING_DATE, END_UNLOADING_DATE END_UNLOADING_DATE, DESCRIPTION DESCRIPTION, FREIGHT_CLASS FREIGHT_CLASS, HAZARDOUS_MATERIAL HAZARDOUS_MATERIAL, LOAD_POINT LOAD_POINT, NOTES1 NOTES1, NOTES2 NOTES2, NOTES3 NOTES3, NOTES4 NOTES4, NOTES5 NOTES5, NOTES6 NOTES6, NOTES7 NOTES7, NOTES8 NOTES8, NOTES9 NOTES9, SHIP_UNIT_QUANTITY SHIP_UNIT_QUANTITY, SHIP_UNIT_UOM SHIP_UNIT_UOM, VOLUME VOLUME, VOLUME_UOM VOLUME_UOM, WEIGHT WEIGHT, WEIGHT_UOM WEIGHT_UOM, ROUTE_ID ROUTE_ID, ROUTE_TYPE ROUTE_TYPE, SHIP_NOTES SHIP_NOTES, SHIPPER_NUMBER SHIPPER_NUMBER, SHIP_POINT SHIP_POINT, SPECIAL_HANDLING SPECIAL_HANDLING, STOP_NUMBER STOP_NUMBER, SHIPPING_METHOD SHIPPING_METHOD, SHIP_FROM_PARTNER SHIP_FROM_PARTNER, SHIP_TO_PARTNER SHIP_TO_PARTNER, CARRIER_PARTNER CARRIER_PARTNER, BILL_TO_PARTNER BILL_TO_PARTNER, NOTIFY_PARTNER NOTIFY_PARTNER, HOLD_AT_PARTNER HOLD_AT_PARTNER, RETURN_TO_PARTNER RETURN_TO_PARTNER, MARK_FOR_PARTNER MARK_FOR_PARTNER, IMPORTER_PARTNER IMPORTER_PARTNER, EXPORTER_PARTNER EXPORTER_PARTNER, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REASON_CODE REASON_CODE, TRANSACTION_ID TRANSACTION_ID, ACTIVITY_ID ACTIVITY_ID, VEHICLE_NUMBER VEHICLE_NUMBER, OPERATOR OPERATOR, CARRIER_REF_NUMBER CARRIER_REF_NUMBER, WF_ITEM_KEY WF_ITEM_KEY from "FTE"."FTE_SHIPMENT_STATUS_HEADERS"

View Text - HTML Formatted

SELECT DELIVERY_ID DELIVERY_ID
, DELIVERY_LEG_ID DELIVERY_LEG_ID
, MESSAGE_TYPE MESSAGE_TYPE
, SHIPMENT_STATUS_ID SHIPMENT_STATUS_ID
, CARRIER_NAME CARRIER_NAME
, GENERATION_DATE GENERATION_DATE
, STATUS STATUS
, TRACKING_ID TRACKING_ID
, TRACKING_ID_TYPE TRACKING_ID_TYPE
, BILL_OF_LADING BILL_OF_LADING
, CARRIER_SERVICE_LEVEL CARRIER_SERVICE_LEVEL
, CONTAINER_ID CONTAINER_ID
, CONTAINER_SEAL CONTAINER_SEAL
, ARRIVAL_DATE ARRIVAL_DATE
, RECEIVED_DATE RECEIVED_DATE
, DELIVERY_SCHEDULED_DATE DELIVERY_SCHEDULED_DATE
, DEPARTURE_DATE DEPARTURE_DATE
, ESTIMATED_ARRIVAL_DATE ESTIMATED_ARRIVAL_DATE
, ESTIMATED_DEPARTURE_DATE ESTIMATED_DEPARTURE_DATE
, BEGIN_LOADING_DATE BEGIN_LOADING_DATE
, END_LOADING_DATE END_LOADING_DATE
, PROMISED_SHIPMENT_DATE PROMISED_SHIPMENT_DATE
, PROMISED_DELIVERY_DATE PROMISED_DELIVERY_DATE
, SHIPPED_DATE SHIPPED_DATE
, EXPECTED_SHIPMENT_DATE EXPECTED_SHIPMENT_DATE
, BEGIN_UNLOADING_DATE BEGIN_UNLOADING_DATE
, END_UNLOADING_DATE END_UNLOADING_DATE
, DESCRIPTION DESCRIPTION
, FREIGHT_CLASS FREIGHT_CLASS
, HAZARDOUS_MATERIAL HAZARDOUS_MATERIAL
, LOAD_POINT LOAD_POINT
, NOTES1 NOTES1
, NOTES2 NOTES2
, NOTES3 NOTES3
, NOTES4 NOTES4
, NOTES5 NOTES5
, NOTES6 NOTES6
, NOTES7 NOTES7
, NOTES8 NOTES8
, NOTES9 NOTES9
, SHIP_UNIT_QUANTITY SHIP_UNIT_QUANTITY
, SHIP_UNIT_UOM SHIP_UNIT_UOM
, VOLUME VOLUME
, VOLUME_UOM VOLUME_UOM
, WEIGHT WEIGHT
, WEIGHT_UOM WEIGHT_UOM
, ROUTE_ID ROUTE_ID
, ROUTE_TYPE ROUTE_TYPE
, SHIP_NOTES SHIP_NOTES
, SHIPPER_NUMBER SHIPPER_NUMBER
, SHIP_POINT SHIP_POINT
, SPECIAL_HANDLING SPECIAL_HANDLING
, STOP_NUMBER STOP_NUMBER
, SHIPPING_METHOD SHIPPING_METHOD
, SHIP_FROM_PARTNER SHIP_FROM_PARTNER
, SHIP_TO_PARTNER SHIP_TO_PARTNER
, CARRIER_PARTNER CARRIER_PARTNER
, BILL_TO_PARTNER BILL_TO_PARTNER
, NOTIFY_PARTNER NOTIFY_PARTNER
, HOLD_AT_PARTNER HOLD_AT_PARTNER
, RETURN_TO_PARTNER RETURN_TO_PARTNER
, MARK_FOR_PARTNER MARK_FOR_PARTNER
, IMPORTER_PARTNER IMPORTER_PARTNER
, EXPORTER_PARTNER EXPORTER_PARTNER
, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REASON_CODE REASON_CODE
, TRANSACTION_ID TRANSACTION_ID
, ACTIVITY_ID ACTIVITY_ID
, VEHICLE_NUMBER VEHICLE_NUMBER
, OPERATOR OPERATOR
, CARRIER_REF_NUMBER CARRIER_REF_NUMBER
, WF_ITEM_KEY WF_ITEM_KEY
FROM "FTE"."FTE_SHIPMENT_STATUS_HEADERS"