eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FTE_SCHEDULES_V

Product:	FTE - Transportation Execution
Description:	Internal view
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
LANE_ID
ORIGIN_ID
DESTINATION_ID
SCHEDULES_ID
VESSEL
DEPARTURE_DATE
ARRIVAL_DATE
VOYAGE
EQUIPMENT_TYPE
SERVICE_TYPE
TRANSIT_TIME
FREQUENCY
ORIGIN
DESTINATION
SUPPLIER_ID
SUPPLIER_NAME
BUYER_ID
CARRIER_ID
MODE_OF_TRANSPORTATION
MODE_OF_TRANSPORTATION_CODE
PORT_OF_LOADING
PORT_OF_DISCHARGE
BASIS
PRICELIST_ID
LANE_NUMBER
EFFECTIVE_DATE
EXPIRY_DATE
ARRIVAL_DATE_INDICATOR
CFS_CLOSING_DATE
CY_CLOSING_DATE
FREQUENCY_ARRIVAL