Product: | FTE - Transportation Execution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT LOAD_ID
, LOAD_NUMBER
, DESCRIPTION
, PARENT_LOAD_ID
, RECIPIENT_ID
, RECIPIENT_NAME
, LANE_ID
, SCHEDULE_ID
, LANE_NAME
, SCHEDULE_NAME
, BOOKING_TYPE_CODE
, BOOKING_TYPE_DESC
, STATUS_CODE
, STATUS_DESC
, BOOKING_NUMBER
, TO_CHAR(EST_DATE_OF_DEPARTURE
, 'DD-MM-YYYY HH24:MI:SS') AS EST_DATE_OF_DEPARTURE
, TO_CHAR(EST_DATE_OF_ARRIVAL
, 'DD-MM-YYYY HH24:MI:SS') AS EST_DATE_OF_ARRIVAL
, CLOSING_TIME
, ORDER_NUMBER
, SHIPPER_REFERENCE_NUMBER
, BOOKING_OFFICE_DESC
, 'TOTWEIGHT' "TOTAL_WEIGHT_QUALIFIER"
, TOTAL_WEIGHT
, WEIGHT_UOM
, 'VOLUME' "TOTAL_VOLUME_QUALIFIER"
, TOTAL_VOLUME
, VOLUME_UOM
, TEMPERATURE_FROM
, TEMPERATURE_TO
, TEMP_UOM
, HOUSE_WAYBILL_NUMBER
, MASTER_WAYBILL_NUMBER
, EID_FLAG
, EXPORT_LICENSE_NUMBER
, COUNTRY_OF_ORIGIN_CODE
, COUNTRY_OF_ORIGIN_DESC
, PORT_OF_LOADING_CODE
, PORT_OF_LOADING_DESC
, PORT_OF_DISCHARGE_CODE
, PORT_OF_DISCHARGE_DESC
, SERVICE_REQUIRED_FLAG
, TRANSPORT_DETAILS_FLAG
, HANDLING_INFORMATION
, SERVICE_TYPE
, MOVEMENT_TYPE
, SHIPPER_ID
, SHIPPER_LOCATION_ID
, SHIPPER_NAME
, SHIPPER_ADDRESS_LINE_1
, SHIPPER_ADDRESS_LINE_2
, SHIPPER_TOWN
, SHIPPER_STATE
, SHIPPER_COUNTRY
, SHIPPER_POSTAL_CODE
, SHIPPER_PHONE_NUMBER
, CONSIGNEE_ID
, CONSIGNEE_NAME
, CONSIGNEE_ADDRESS_LINE_1
, CONSIGNEE_ADDRESS_LINE_2
, CONSIGNEE_TOWN
, CONSIGNEE_STATE
, CONSIGNEE_COUNTRY
, CONSIGNEE_POSTAL_CODE
, CONSIGNEE_PHONE_NUMBER
, WHO_NAME
, WHO_ADDRESS_LINE_1
, WHO_ADDRESS_LINE_2
, WHO_TOWN
, WHO_STATE
, WHO_COUNTRY
, WHO_POSTAL_CODE
, WHO_PHONE_NUMBER
, WHD_NAME
, WHD_ADDRESS_LINE_1
, WHD_ADDRESS_LINE_2
, WHD_TOWN
, WHD_STATE
, WHD_COUNTRY
, WHD_POSTAL_CODE
, WHD_PHONE_NUMBER
, NOTIFYA_NAME
, NOTIFYA_ADDRESS_LINE_1
, NOTIFYA_ADDRESS_LINE_2
, NOTIFYA_TOWN
, NOTIFYA_STATE
, NOTIFYA_COUNTRY
, NOTIFYA_POSTAL_CODE
, NOTIFYA_PHONE_NUMBER
, NOTIFYB_NAME
, NOTIFYB_ADDRESS_LINE_1
, NOTIFYB_ADDRESS_LINE_2
, NOTIFYB_TOWN
, NOTIFYB_STATE
, NOTIFYB_COUNTRY
, NOTIFYB_POSTAL_CODE
, NOTIFYB_PHONE_NUMBER
, CARRIAGE_VALUE_CURR_CODE
, CARRIAGE_VAUE_AMOUNT
, CUSTOMS_VALUE_CURR_CODE
, CUSTOMS_VAUE_AMOUNT
, INSURANCE_VALUE_CURR_CODE
, INSURANCE_VAUE_AMOUNT
, FREIGHT_PAYABLE_AT
, FREIGHT_COLLECT_AT
, OHPC_CODE
, OPPC_CODE
, BFPC_CODE
, DPPC_CODE
, DHPC_CODE
, REMARKS
, FOB
, DOCUMENT_SENT_BY_ID
, DOCUMENT_SENT_BY_NAME
, DOCUMENT_TRANSMISSION_TIME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OPERATOR_ID
, PARTIAL_ACCPT_FLAG
, TO_CHAR(LATEST_PICKUP_DATE
, 'DD-MM-YYYY HH24:MI:SS') AS LATEST_PICKUP_DATE
, TO_CHAR(EARLIEST_ARRIVAL_DATE
, 'DD-MM-YYYY HH24:MI:SS') AS EARLIEST_ARRIVAL_DATE
, EXCHANGE_MEMBER
, SOURCE_CODE
, SOURCE_SHIPMENT_STATUS
, TRANSACTION_SEQUENCE
FROM FTE_LOAD_HEADERS