Product: | FTE - Transportation Execution |
---|---|
Description: | Internal view |
Implementation/DBA Data: | Not implemented in this database |
SELECT SC.LANE_ID
, LAN.ORIGIN_ID
, LAN.DESTINATION_ID
, SC.SCHEDULES_ID
, SC.VESSEL
, SC.DEPARTURE_DATE
, SC.ARRIVAL_DATE
, SC.VOYAGE
, LAN.CTX_EQUIPMENT_TYPE
, LAN.CTX_SERVICE_TYPE
, SC.TRANSIT_TIME
, SC.FREQUENCY
, LAN.CTX_ORIGIN
, LAN.CTX_DESTINATION
, LAN.SUPPLIER_ID
, HZ.PARTY_NAME
, LAN.BUYER_ID
, LAN.CARRIER_ID
, LAN.MODE_OF_TRANSPORTATION
, LAN.MODE_OF_TRANSPORTATION_CODE
, SC.PORT_OF_LOADING
, SC.PORT_OF_DISCHARGE
, LAN.BASIS
, LAN.PRICELIST_ID
, SC.LANE_NUMBER
, SC.EFFECTIVE_DATE
, SC.EXPIRY_DATE
, SC.ARRIVAL_DATE_INDICATOR
, SC.CFS_CLOSING_DATE
, SC.CY_CLOSING_DATE
, SC.FREQUENCY_ARRIVAL
FROM FTE_SCHEDULES SC
, FTE_LANES LAN
, HZ_PARTIES HZ
WHERE SC.LANE_ID = LAN.LANE_ID
AND LAN.CARRIER_ID = HZ.PARTY_ID