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.FTE_LOCATION_PARAMETERS#

Source

View Text - Preformatted


select FACILITY_ID FACILITY_ID, FACILITY_CODE FACILITY_CODE, LOCATION_ID LOCATION_ID, DESCRIPTION DESCRIPTION, CONSOLIDATION_ALLOWED CONSOLIDATION_ALLOWED, DECONSOLIDATION_ALLOWED DECONSOLIDATION_ALLOWED, CROSSDOCKING_ALLOWED CROSSDOCKING_ALLOWED, PARCEL_LTL_CONSOLIDATION PARCEL_LTL_CONSOLIDATION, PARCEL_TL_CONSOLIDATION PARCEL_TL_CONSOLIDATION, LTL_TL_CONSOLIDATION LTL_TL_CONSOLIDATION, LTL_LTL_CONSOLIDATION LTL_LTL_CONSOLIDATION, LTL_PARCEL_DECONSOLIDATION LTL_PARCEL_DECONSOLIDATION, TL_PARCEL_DECONSOLIDATION TL_PARCEL_DECONSOLIDATION, TL_LTL_DECONSOLIDATION TL_LTL_DECONSOLIDATION, LTL_LTL_DECONSOLIDATION LTL_LTL_DECONSOLIDATION, PARCEL_INBOUND_CROSSDOCKING PARCEL_INBOUND_CROSSDOCKING, LTL_INBOUND_CROSSDOCKING LTL_INBOUND_CROSSDOCKING, TL_INBOUND_CROSSDOCKING TL_INBOUND_CROSSDOCKING, PARCEL_OUTBOUND_CROSSDOCKING PARCEL_OUTBOUND_CROSSDOCKING, LTL_OUTBOUND_CROSSDOCKING LTL_OUTBOUND_CROSSDOCKING, TL_OUTBOUND_CROSSDOCKING TL_OUTBOUND_CROSSDOCKING, STORAGE_FACILITY STORAGE_FACILITY, CARRIER_DROP_TRAILER_ALLOWED CARRIER_DROP_TRAILER_ALLOWED, CARRIER_OWNED_HAUL CARRIER_OWNED_HAUL, NUM_DOCKS NUM_DOCKS, NUM_SHIPPING_DOCKS NUM_SHIPPING_DOCKS, NUM_RECEIVING_DOCKS NUM_RECEIVING_DOCKS, NUM_PARKING_SPOTS NUM_PARKING_SPOTS, HANDLING_CAPACITY HANDLING_CAPACITY, DOCK_HANDLING_RATE DOCK_HANDLING_RATE, HANDLING_UNIT HANDLING_UNIT, WEIGHT_UOM WEIGHT_UOM, VOLUME_UOM VOLUME_UOM, TIME_UOM TIME_UOM, FLOW_THROUGH_TIME FLOW_THROUGH_TIME, LOADING_TIME LOADING_TIME, UNLOADING_TIME UNLOADING_TIME, NON_ADJACENT_LOADING NON_ADJACENT_LOADING, NON_ADJACENT_UNLOADING NON_ADJACENT_UNLOADING, PRIVATE_RESIDENCE PRIVATE_RESIDENCE, MAXIMUM_VEHICLE_HEIGHT MAXIMUM_VEHICLE_HEIGHT, MAXIMUM_VEHICLE_WIDTH MAXIMUM_VEHICLE_WIDTH, MAXIMUM_VEHICLE_LENGTH MAXIMUM_VEHICLE_LENGTH, DIMENSIONAL_UOM DIMENSIONAL_UOM, LOAD_UNLOAD_PROTOCOL LOAD_UNLOAD_PROTOCOL, EQUIPMENT_REQ_CODE1 EQUIPMENT_REQ_CODE1, EQUIPMENT_REQ_CODE2 EQUIPMENT_REQ_CODE2, EQUIPMENT_REQ_CODE3 EQUIPMENT_REQ_CODE3, EQUIPMENT_REQ_CODE4 EQUIPMENT_REQ_CODE4, MODIFIER_LIST MODIFIER_LIST, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM, EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO, FLOW_THROUGH_TIME_UOM FLOW_THROUGH_TIME_UOM, HANDLE_STACKED_PALLETS HANDLE_STACKED_PALLETS, NONPALLETIZED_LOADING_RATE NONPALLETIZED_LOADING_RATE, NONPALLETIZED_UNLOADING_RATE NONPALLETIZED_UNLOADING_RATE, NONPALLETIZED_HANDLING_UOM NONPALLETIZED_HANDLING_UOM, NONPALLETIZED_HANDLING_TYPE NONPALLETIZED_HANDLING_TYPE, PALLETIZED_LOADING_RATE PALLETIZED_LOADING_RATE, PALLETIZED_UNLOADING_RATE PALLETIZED_UNLOADING_RATE, PALLETIZED_HANDLING_UOM PALLETIZED_HANDLING_UOM, PALLETIZED_HANDLING_TYPE PALLETIZED_HANDLING_TYPE, LOAD_UNLOAD_TIME_UOM LOAD_UNLOAD_TIME_UOM, HANDLING_CAPACITY_TIME_UOM HANDLING_CAPACITY_TIME_UOM, HANDLING_CAPACITY_TYPE HANDLING_CAPACITY_TYPE, INCLUDE_MILEAGE_FLAG INCLUDE_MILEAGE_FLAG, FACILITY_CONTACT_ID FACILITY_CONTACT_ID from "FTE"."FTE_LOCATION_PARAMETERS"

View Text - HTML Formatted

SELECT FACILITY_ID FACILITY_ID
, FACILITY_CODE FACILITY_CODE
, LOCATION_ID LOCATION_ID
, DESCRIPTION DESCRIPTION
, CONSOLIDATION_ALLOWED CONSOLIDATION_ALLOWED
, DECONSOLIDATION_ALLOWED DECONSOLIDATION_ALLOWED
, CROSSDOCKING_ALLOWED CROSSDOCKING_ALLOWED
, PARCEL_LTL_CONSOLIDATION PARCEL_LTL_CONSOLIDATION
, PARCEL_TL_CONSOLIDATION PARCEL_TL_CONSOLIDATION
, LTL_TL_CONSOLIDATION LTL_TL_CONSOLIDATION
, LTL_LTL_CONSOLIDATION LTL_LTL_CONSOLIDATION
, LTL_PARCEL_DECONSOLIDATION LTL_PARCEL_DECONSOLIDATION
, TL_PARCEL_DECONSOLIDATION TL_PARCEL_DECONSOLIDATION
, TL_LTL_DECONSOLIDATION TL_LTL_DECONSOLIDATION
, LTL_LTL_DECONSOLIDATION LTL_LTL_DECONSOLIDATION
, PARCEL_INBOUND_CROSSDOCKING PARCEL_INBOUND_CROSSDOCKING
, LTL_INBOUND_CROSSDOCKING LTL_INBOUND_CROSSDOCKING
, TL_INBOUND_CROSSDOCKING TL_INBOUND_CROSSDOCKING
, PARCEL_OUTBOUND_CROSSDOCKING PARCEL_OUTBOUND_CROSSDOCKING
, LTL_OUTBOUND_CROSSDOCKING LTL_OUTBOUND_CROSSDOCKING
, TL_OUTBOUND_CROSSDOCKING TL_OUTBOUND_CROSSDOCKING
, STORAGE_FACILITY STORAGE_FACILITY
, CARRIER_DROP_TRAILER_ALLOWED CARRIER_DROP_TRAILER_ALLOWED
, CARRIER_OWNED_HAUL CARRIER_OWNED_HAUL
, NUM_DOCKS NUM_DOCKS
, NUM_SHIPPING_DOCKS NUM_SHIPPING_DOCKS
, NUM_RECEIVING_DOCKS NUM_RECEIVING_DOCKS
, NUM_PARKING_SPOTS NUM_PARKING_SPOTS
, HANDLING_CAPACITY HANDLING_CAPACITY
, DOCK_HANDLING_RATE DOCK_HANDLING_RATE
, HANDLING_UNIT HANDLING_UNIT
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_UOM VOLUME_UOM
, TIME_UOM TIME_UOM
, FLOW_THROUGH_TIME FLOW_THROUGH_TIME
, LOADING_TIME LOADING_TIME
, UNLOADING_TIME UNLOADING_TIME
, NON_ADJACENT_LOADING NON_ADJACENT_LOADING
, NON_ADJACENT_UNLOADING NON_ADJACENT_UNLOADING
, PRIVATE_RESIDENCE PRIVATE_RESIDENCE
, MAXIMUM_VEHICLE_HEIGHT MAXIMUM_VEHICLE_HEIGHT
, MAXIMUM_VEHICLE_WIDTH MAXIMUM_VEHICLE_WIDTH
, MAXIMUM_VEHICLE_LENGTH MAXIMUM_VEHICLE_LENGTH
, DIMENSIONAL_UOM DIMENSIONAL_UOM
, LOAD_UNLOAD_PROTOCOL LOAD_UNLOAD_PROTOCOL
, EQUIPMENT_REQ_CODE1 EQUIPMENT_REQ_CODE1
, EQUIPMENT_REQ_CODE2 EQUIPMENT_REQ_CODE2
, EQUIPMENT_REQ_CODE3 EQUIPMENT_REQ_CODE3
, EQUIPMENT_REQ_CODE4 EQUIPMENT_REQ_CODE4
, MODIFIER_LIST MODIFIER_LIST
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, FLOW_THROUGH_TIME_UOM FLOW_THROUGH_TIME_UOM
, HANDLE_STACKED_PALLETS HANDLE_STACKED_PALLETS
, NONPALLETIZED_LOADING_RATE NONPALLETIZED_LOADING_RATE
, NONPALLETIZED_UNLOADING_RATE NONPALLETIZED_UNLOADING_RATE
, NONPALLETIZED_HANDLING_UOM NONPALLETIZED_HANDLING_UOM
, NONPALLETIZED_HANDLING_TYPE NONPALLETIZED_HANDLING_TYPE
, PALLETIZED_LOADING_RATE PALLETIZED_LOADING_RATE
, PALLETIZED_UNLOADING_RATE PALLETIZED_UNLOADING_RATE
, PALLETIZED_HANDLING_UOM PALLETIZED_HANDLING_UOM
, PALLETIZED_HANDLING_TYPE PALLETIZED_HANDLING_TYPE
, LOAD_UNLOAD_TIME_UOM LOAD_UNLOAD_TIME_UOM
, HANDLING_CAPACITY_TIME_UOM HANDLING_CAPACITY_TIME_UOM
, HANDLING_CAPACITY_TYPE HANDLING_CAPACITY_TYPE
, INCLUDE_MILEAGE_FLAG INCLUDE_MILEAGE_FLAG
, FACILITY_CONTACT_ID FACILITY_CONTACT_ID
FROM "FTE"."FTE_LOCATION_PARAMETERS"