VIEW: FTE.FTE_LANES#

Source

View Text - Preformatted

select LANE_ID LANE_ID, LANE_NUMBER LANE_NUMBER, OWNER_ID OWNER_ID, CARRIER_ID CARRIER_ID, ORIGIN_ID ORIGIN_ID, DESTINATION_ID DESTINATION_ID, MODE_OF_TRANSPORTATION_CODE MODE_OF_TRANSPORTATION_CODE, PORT_OF_DISCHARGE PORT_OF_DISCHARGE, PORT_OF_LOADING PORT_OF_LOADING, TRANSIT_TIME TRANSIT_TIME, TRANSIT_TIME_UOM TRANSIT_TIME_UOM, SPECIAL_HANDLING SPECIAL_HANDLING, ADDITIONAL_INSTRUCTIONS ADDITIONAL_INSTRUCTIONS, COMMODITY_DETAIL_FLAG COMMODITY_DETAIL_FLAG, EQUIPMENT_DETAIL_FLAG EQUIPMENT_DETAIL_FLAG, SERVICE_DETAIL_FLAG SERVICE_DETAIL_FLAG, COMM_FC_CLASS_CODE COMM_FC_CLASS_CODE, COMMODITY_CATG_ID COMMODITY_CATG_ID, EQUIPMENT_TYPE_CODE EQUIPMENT_TYPE_CODE, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, DISTANCE DISTANCE, DISTANCE_UOM DISTANCE_UOM, SCHEDULES_FLAG SCHEDULES_FLAG, PRICELIST_ID PRICELIST_ID, PRICELIST_VIEW_FLAG PRICELIST_VIEW_FLAG, BASIS BASIS, EFFECTIVE_DATE EFFECTIVE_DATE, EXPIRY_DATE EXPIRY_DATE, EDITABLE_FLAG EDITABLE_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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, LANE_TYPE LANE_TYPE, TARIFF_NAME TARIFF_NAME from "FTE"."FTE_LANES"

View Text - HTML Formatted

SELECT LANE_ID LANE_ID
, LANE_NUMBER LANE_NUMBER
, OWNER_ID OWNER_ID
, CARRIER_ID CARRIER_ID
, ORIGIN_ID ORIGIN_ID
, DESTINATION_ID DESTINATION_ID
, MODE_OF_TRANSPORTATION_CODE MODE_OF_TRANSPORTATION_CODE
, PORT_OF_DISCHARGE PORT_OF_DISCHARGE
, PORT_OF_LOADING PORT_OF_LOADING
, TRANSIT_TIME TRANSIT_TIME
, TRANSIT_TIME_UOM TRANSIT_TIME_UOM
, SPECIAL_HANDLING SPECIAL_HANDLING
, ADDITIONAL_INSTRUCTIONS ADDITIONAL_INSTRUCTIONS
, COMMODITY_DETAIL_FLAG COMMODITY_DETAIL_FLAG
, EQUIPMENT_DETAIL_FLAG EQUIPMENT_DETAIL_FLAG
, SERVICE_DETAIL_FLAG SERVICE_DETAIL_FLAG
, COMM_FC_CLASS_CODE COMM_FC_CLASS_CODE
, COMMODITY_CATG_ID COMMODITY_CATG_ID
, EQUIPMENT_TYPE_CODE EQUIPMENT_TYPE_CODE
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, DISTANCE DISTANCE
, DISTANCE_UOM DISTANCE_UOM
, SCHEDULES_FLAG SCHEDULES_FLAG
, PRICELIST_ID PRICELIST_ID
, PRICELIST_VIEW_FLAG PRICELIST_VIEW_FLAG
, BASIS BASIS
, EFFECTIVE_DATE EFFECTIVE_DATE
, EXPIRY_DATE EXPIRY_DATE
, EDITABLE_FLAG EDITABLE_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
, LANE_TYPE LANE_TYPE
, TARIFF_NAME TARIFF_NAME
FROM "FTE"."FTE_LANES"