Product: | FTE - Transportation Execution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT LOAD_ID
, LOAD_SCHEDULE_ID
, LOAD_SCHEDULE_NAME
, ORIGINAL_SCHEDULE_ID
, LANE_ID
, LANE_NAME
, CARRIER_ID
, CARRIER_NAME
, MODE_OF_TRANSPORTATION
, CONTRACT_REFERENCE
, CHARTER_SERVICE_FLAG
, TO_CHAR(DEPARTURE_DATE
, 'DD-MM-YYYY HH24:MI:SS') AS DEPARTURE_DATE
, TO_CHAR(ARRIVAL_DATE
, 'DD-MM-YYYY HH24:MI:SS')AS ARRIVAL_DATE
, PORT_OF_LOADING
, PORT_OF_DISCHARGE
, VESSEL_TYPE
, VOYAGE
, EQUIPMENT_TYPE
, SERVICE_TYPE
, STATUS_CODE
, SEQUENCE_NUMBER
, PICK_UP_STOP_ID
, DROP_OFF_STOP_ID
, EID_FLAG
, FREQUENCY
, 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
, WORKFLOW_NAME
, WORKFLOW_PROCESS
, EST_DEPARTURE_DATE
, EST_ARRIVAL_DATE
, DOCK_CODE
, FLAG
, VESSEL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, CARRIER_REMARKS
, FOB
, FOB_CODE
, FREIGHT_TERMS
, FREIGHT_TERMS_CODE
, PRICE
, CURRENCY
, RECEIVE_CONF_NOTICES_FLAG
, AUTO_TENDER_FLAG
, QUOTATION_NUMBER
, BOOKING_NUMBER
, CARRIER_TRACKING_NUMBER
, POD_SENT
, POR_SENT
, CARRIER_NOTES
, CONSIGNEE_NOTES
, TO_CHAR(DELIVERY_DATE
, 'DD-MM-YYYY HH24:MI:SS') AS DELIVERY_DATE
, TO_CHAR(RECEIPT_DATE
, 'DD-MM-YYYY HH24:MI:SS') AS RECEIPT_DATE
, DELIVERED_TO
, RECEIVED_BY
, TO_CHAR(SHIP_DATE
, 'DD-MM-YYYY HH24:MI:SS') AS SHIP_DATE
FROM FTE_LOAD_SCHEDULES