VIEW: FTE.FTE_SCHEDULES#

Source

View Text - Preformatted

select SCHEDULES_ID SCHEDULES_ID, LANE_ID LANE_ID, LANE_NUMBER LANE_NUMBER, VESSEL_TYPE VESSEL_TYPE, VESSEL_NAME VESSEL_NAME, VOYAGE_NUMBER VOYAGE_NUMBER, DEPARTURE_DATE DEPARTURE_DATE, DEPARTURE_TIME DEPARTURE_TIME, ARRIVAL_DATE ARRIVAL_DATE, ARRIVAL_TIME ARRIVAL_TIME, ARRIVAL_DATE_INDICATOR ARRIVAL_DATE_INDICATOR, FREQUENCY_TYPE FREQUENCY_TYPE, FREQUENCY FREQUENCY, FREQUENCY_ARRIVAL FREQUENCY_ARRIVAL, TRANSIT_TIME TRANSIT_TIME, TRANSIT_TIME_UOM TRANSIT_TIME_UOM, PORT_OF_LOADING PORT_OF_LOADING, PORT_OF_DISCHARGE PORT_OF_DISCHARGE, EFFECTIVE_DATE EFFECTIVE_DATE, EXPIRY_DATE EXPIRY_DATE, EDITABLE_FLAG EDITABLE_FLAG, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "FTE"."FTE_SCHEDULES"

View Text - HTML Formatted

SELECT SCHEDULES_ID SCHEDULES_ID
, LANE_ID LANE_ID
, LANE_NUMBER LANE_NUMBER
, VESSEL_TYPE VESSEL_TYPE
, VESSEL_NAME VESSEL_NAME
, VOYAGE_NUMBER VOYAGE_NUMBER
, DEPARTURE_DATE DEPARTURE_DATE
, DEPARTURE_TIME DEPARTURE_TIME
, ARRIVAL_DATE ARRIVAL_DATE
, ARRIVAL_TIME ARRIVAL_TIME
, ARRIVAL_DATE_INDICATOR ARRIVAL_DATE_INDICATOR
, FREQUENCY_TYPE FREQUENCY_TYPE
, FREQUENCY FREQUENCY
, FREQUENCY_ARRIVAL FREQUENCY_ARRIVAL
, TRANSIT_TIME TRANSIT_TIME
, TRANSIT_TIME_UOM TRANSIT_TIME_UOM
, PORT_OF_LOADING PORT_OF_LOADING
, PORT_OF_DISCHARGE PORT_OF_DISCHARGE
, EFFECTIVE_DATE EFFECTIVE_DATE
, EXPIRY_DATE EXPIRY_DATE
, EDITABLE_FLAG EDITABLE_FLAG
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "FTE"."FTE_SCHEDULES"