[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FTE_LOCATION_PARAMETERS |
|---|---|
| Object Type: | TABLE |
| Owner: | FTE |
| FND Design Data: |  FTE.FTE_LOCATION_PARAMETERS
|
| Subobject Name: | |
| Status: | VALID |
Stores Facility definition and it's parameters.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FTE_LOCATION_PARAMETERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 FACILITY_ID
|
| FTE_LOCATION_PARAMETERS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
LOCATION_ID
|
| FTE_LOCATION_PARAMETERS_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
FACILITY_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FACILITY_ID | NUMBER | Yes | Primary Key of the Table | |
| FACILITY_CODE | VARCHAR2 | (60) | Yes | Unique Facility Identifier |
| LOCATION_ID | NUMBER | Yes | Foreign Key to WSH_LOCATIONS.wsh_location_id | |
| DESCRIPTION | VARCHAR2 | (250) | Optional User Description | |
| CONSOLIDATION_ALLOWED | VARCHAR2 | (1) | Consolidation Activity Allowed : Yes / No | |
| DECONSOLIDATION_ALLOWED | VARCHAR2 | (1) | Deconsolidation Activity Allowed : Yes / No | |
| CROSSDOCKING_ALLOWED | VARCHAR2 | (1) | Cross-docking Activity Allowed : Yes / No | |
| PARCEL_LTL_CONSOLIDATION | VARCHAR2 | (1) | Parcel to LTL Consolidation Allowed : Yes / No | |
| PARCEL_TL_CONSOLIDATION | VARCHAR2 | (1) | Parcel to TL Consolidation Allowed : Yes / No | |
| LTL_TL_CONSOLIDATION | VARCHAR2 | (1) | LTL to TL Consolidation Allowed : Yes / No | |
| LTL_LTL_CONSOLIDATION | VARCHAR2 | (1) | LTL to LTL Consolidation Allowed : Yes / No | |
| LTL_PARCEL_DECONSOLIDATION | VARCHAR2 | (1) | LTL to Parcel Deconsolidation Allowed : Yes / No | |
| TL_PARCEL_DECONSOLIDATION | VARCHAR2 | (1) | TL to Parcel Deconsolidation Allowed : Yes / No | |
| TL_LTL_DECONSOLIDATION | VARCHAR2 | (1) | TL to LTL Deconsolidation Allowed : Yes / No | |
| LTL_LTL_DECONSOLIDATION | VARCHAR2 | (1) | LTL to LTL Deconsolidation Allowed : Yes / No | |
| PARCEL_INBOUND_CROSSDOCKING | VARCHAR2 | (1) | Inbound Cross-docking allowed for Parcel : Yes / No | |
| LTL_INBOUND_CROSSDOCKING | VARCHAR2 | (1) | Inbound Cross-docking allowed for LTL : Yes / No | |
| TL_INBOUND_CROSSDOCKING | VARCHAR2 | (1) | Inbound Cross-docking allowed for TL : Yes / No | |
| PARCEL_OUTBOUND_CROSSDOCKING | VARCHAR2 | (1) | Outbound Cross-docking allowed for Parcel : Yes / No | |
| LTL_OUTBOUND_CROSSDOCKING | VARCHAR2 | (1) | Outbound Cross-docking allowed for LTL : Yes / No | |
| TL_OUTBOUND_CROSSDOCKING | VARCHAR2 | (1) | Outbound Cross-docking allowed for TL : Yes / No | |
| STORAGE_FACILITY | VARCHAR2 | (1) | Flag to Indicate whether this is only a Trans shipment Facility : Applicable to Carrier Facility only | |
| CARRIER_DROP_TRAILER_ALLOWED | VARCHAR2 | (1) | ||
| CARRIER_OWNED_HAUL | VARCHAR2 | (30) | Whether the Carrier performs Line haul or Local haul in case of consolidation/deconsolidation - Applicable to Carrier facility only | |
| NUM_DOCKS | NUMBER | Total number of docks at the facility | ||
| NUM_SHIPPING_DOCKS | NUMBER | Total number of shipping docks at the facility | ||
| NUM_RECEIVING_DOCKS | NUMBER | Total number of Receiving docks at the facility | ||
| NUM_PARKING_SPOTS | NUMBER | Total number of Parking spots at the facility | ||
| HANDLING_CAPACITY | NUMBER | Facility handling capacity as throughput | ||
| DOCK_HANDLING_RATE | NUMBER | |||
| HANDLING_UNIT | VARCHAR2 | (30) | Handling Unit of Measure | |
| WEIGHT_UOM | VARCHAR2 | (30) | ||
| VOLUME_UOM | VARCHAR2 | (30) | ||
| TIME_UOM | VARCHAR2 | (3) | ||
| FLOW_THROUGH_TIME | NUMBER | Flowthrough time between loading zone and unloading zone at the facility | ||
| LOADING_TIME | NUMBER | |||
| UNLOADING_TIME | NUMBER | |||
| NON_ADJACENT_LOADING | VARCHAR2 | (1) | Whether loading can be done adjacent to the vehicle | |
| NON_ADJACENT_UNLOADING | VARCHAR2 | (1) | Whetherun loading can be done adjacent to the vehicle | |
| PRIVATE_RESIDENCE | VARCHAR2 | (1) | Yes | Private Residence Indicator : Yes / No |
| MAXIMUM_VEHICLE_HEIGHT | NUMBER | Maximum Allowed Vehicle Height | ||
| MAXIMUM_VEHICLE_WIDTH | NUMBER | Maximum Allowed Vehicle Width | ||
| MAXIMUM_VEHICLE_LENGTH | NUMBER | Maximum Allowed Vehicle Length | ||
| DIMENSIONAL_UOM | VARCHAR2 | (3) | Dimension Unit of Measure for Vehicle Dimensions | |
| LOAD_UNLOAD_PROTOCOL | VARCHAR2 | (30) | Yes | Facility Charge Protocol : Facility / Carrier / Joint |
| EQUIPMENT_REQ_CODE1 | VARCHAR2 | (30) | ||
| EQUIPMENT_REQ_CODE2 | VARCHAR2 | (30) | ||
| EQUIPMENT_REQ_CODE3 | VARCHAR2 | (30) | ||
| EQUIPMENT_REQ_CODE4 | VARCHAR2 | (30) | ||
| MODIFIER_LIST | NUMBER | Facility Ratechart Id : Foreign Key to QP_LIST_HEADERS_B.LIST_HEADER_ID | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Attribute Category | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Flexfield Attribute Columns | |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| CREATED_BY | NUMBER | Yes | Standard WHO Column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard WHO Column | ||
| PROGRAM_ID | NUMBER | Standard WHO Column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard WHO Column | ||
| REQUEST_ID | NUMBER | Standard WHO Column | ||
| EFFECTIVE_DATE_FROM | DATE | Yes | Effecitivity Start Date | |
| EFFECTIVE_DATE_TO | DATE | Effecitivity End Date | ||
| FLOW_THROUGH_TIME_UOM | VARCHAR2 | (3) | Flowthrough time unit of measure | |
| HANDLE_STACKED_PALLETS | VARCHAR2 | (1) | Whether the Facility can handle stacked pallets - Yes / No | |
| NONPALLETIZED_LOADING_RATE | NUMBER | Non Palletized Loading Rate | ||
| NONPALLETIZED_UNLOADING_RATE | NUMBER | Non Palletized Unloading Rate | ||
| NONPALLETIZED_HANDLING_UOM | VARCHAR2 | (30) | Non Palletized Loading/Unloading Handling Unit of Measure | |
| NONPALLETIZED_HANDLING_TYPE | VARCHAR2 | (30) | Non Palletized Loading/Unloading Handling Unit Type | |
| PALLETIZED_LOADING_RATE | NUMBER | Palletized Loading Rate | ||
| PALLETIZED_UNLOADING_RATE | NUMBER | Palletized Unloading Rate | ||
| PALLETIZED_HANDLING_UOM | VARCHAR2 | (30) | Palletized Loading/Unloading Handling Unit of Measure | |
| PALLETIZED_HANDLING_TYPE | VARCHAR2 | (30) | Palletized Loading/Unloading Handling Unit Type | |
| LOAD_UNLOAD_TIME_UOM | VARCHAR2 | (3) | Loading/Unloading Time Unit of Measure | |
| HANDLING_CAPACITY_TIME_UOM | VARCHAR2 | (3) | Handling capacity time unit of measure | |
| HANDLING_CAPACITY_TYPE | VARCHAR2 | (30) | Handling capacity unit type : WEIGHT / VOLUME / PIECE / PALLET | |
| INCLUDE_MILEAGE_FLAG | VARCHAR2 | (1) | Include in Mileage Calculation - Yes / No | |
| FACILITY_CONTACT_ID | NUMBER | Facility Contact Id - Foreign Key to HZ_PARTIES.PARTY_ID |
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;
FTE.FTE_LOCATION_PARAMETERS does not reference any database object
FTE.FTE_LOCATION_PARAMETERS is referenced by following:
APPS
FTE_LOCATION_PARAMETERS
|
|
|
|