DBA Data[Home] [Help] [Dependency Information]

VIEW: FTE.FTE_LOCATION_PARAMETERS#

Object Details
Object Name: FTE_LOCATION_PARAMETERS#
Object Type: VIEW
Owner: FTE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FACILITY_ID NUMBER
Yes
FACILITY_CODE VARCHAR2 (60) Yes
LOCATION_ID NUMBER
Yes
DESCRIPTION VARCHAR2 (250)
CONSOLIDATION_ALLOWED VARCHAR2 (1)
DECONSOLIDATION_ALLOWED VARCHAR2 (1)
CROSSDOCKING_ALLOWED VARCHAR2 (1)
PARCEL_LTL_CONSOLIDATION VARCHAR2 (1)
PARCEL_TL_CONSOLIDATION VARCHAR2 (1)
LTL_TL_CONSOLIDATION VARCHAR2 (1)
LTL_LTL_CONSOLIDATION VARCHAR2 (1)
LTL_PARCEL_DECONSOLIDATION VARCHAR2 (1)
TL_PARCEL_DECONSOLIDATION VARCHAR2 (1)
TL_LTL_DECONSOLIDATION VARCHAR2 (1)
LTL_LTL_DECONSOLIDATION VARCHAR2 (1)
PARCEL_INBOUND_CROSSDOCKING VARCHAR2 (1)
LTL_INBOUND_CROSSDOCKING VARCHAR2 (1)
TL_INBOUND_CROSSDOCKING VARCHAR2 (1)
PARCEL_OUTBOUND_CROSSDOCKING VARCHAR2 (1)
LTL_OUTBOUND_CROSSDOCKING VARCHAR2 (1)
TL_OUTBOUND_CROSSDOCKING VARCHAR2 (1)
STORAGE_FACILITY VARCHAR2 (1)
CARRIER_DROP_TRAILER_ALLOWED VARCHAR2 (1)
CARRIER_OWNED_HAUL VARCHAR2 (30)
NUM_DOCKS NUMBER

NUM_SHIPPING_DOCKS NUMBER

NUM_RECEIVING_DOCKS NUMBER

NUM_PARKING_SPOTS NUMBER

HANDLING_CAPACITY NUMBER

DOCK_HANDLING_RATE NUMBER

HANDLING_UNIT VARCHAR2 (30)
WEIGHT_UOM VARCHAR2 (30)
VOLUME_UOM VARCHAR2 (30)
TIME_UOM VARCHAR2 (3)
FLOW_THROUGH_TIME NUMBER

LOADING_TIME NUMBER

UNLOADING_TIME NUMBER

NON_ADJACENT_LOADING VARCHAR2 (1)
NON_ADJACENT_UNLOADING VARCHAR2 (1)
PRIVATE_RESIDENCE VARCHAR2 (1) Yes
MAXIMUM_VEHICLE_HEIGHT NUMBER

MAXIMUM_VEHICLE_WIDTH NUMBER

MAXIMUM_VEHICLE_LENGTH NUMBER

DIMENSIONAL_UOM VARCHAR2 (3)
LOAD_UNLOAD_PROTOCOL VARCHAR2 (30) Yes
EQUIPMENT_REQ_CODE1 VARCHAR2 (30)
EQUIPMENT_REQ_CODE2 VARCHAR2 (30)
EQUIPMENT_REQ_CODE3 VARCHAR2 (30)
EQUIPMENT_REQ_CODE4 VARCHAR2 (30)
MODIFIER_LIST NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

EFFECTIVE_DATE_FROM DATE
Yes
EFFECTIVE_DATE_TO DATE

FLOW_THROUGH_TIME_UOM VARCHAR2 (3)
HANDLE_STACKED_PALLETS VARCHAR2 (1)
NONPALLETIZED_LOADING_RATE NUMBER

NONPALLETIZED_UNLOADING_RATE NUMBER

NONPALLETIZED_HANDLING_UOM VARCHAR2 (30)
NONPALLETIZED_HANDLING_TYPE VARCHAR2 (30)
PALLETIZED_LOADING_RATE NUMBER

PALLETIZED_UNLOADING_RATE NUMBER

PALLETIZED_HANDLING_UOM VARCHAR2 (30)
PALLETIZED_HANDLING_TYPE VARCHAR2 (30)
LOAD_UNLOAD_TIME_UOM VARCHAR2 (3)
HANDLING_CAPACITY_TIME_UOM VARCHAR2 (3)
HANDLING_CAPACITY_TYPE VARCHAR2 (30)
INCLUDE_MILEAGE_FLAG VARCHAR2 (1)
FACILITY_CONTACT_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

FTE.FTE_LOCATION_PARAMETERS# references the following:

SchemaFTE
TableFTE_LOCATION_PARAMETERS
FTE.FTE_LOCATION_PARAMETERS# is referenced by following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS