Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - FTE Tables and Views

TABLE - FTE.FTE_BULKLOAD_DATA
TABLE - FTE.FTE_BULKLOAD_FILE
TABLE - FTE.FTE_DELIVERY_PROOF
TABLE - FTE.FTE_ESTIMATE_RATES_DEL_TEMP
TABLE - FTE.FTE_FACILITY_CARRIERS
TABLE - FTE.FTE_FAILURE_REASONS
TABLE - FTE.FTE_FREIGHT_COSTS_TEMP
TABLE - FTE.FTE_FREIGHT_ESTIMATE_TEMP
TABLE - FTE.FTE_INTERFACE_LANES
TABLE - FTE.FTE_INTERFACE_ZONES
TABLE - FTE.FTE_INVOICE_HEADERS
TABLE - FTE.FTE_INVOICE_HISTORY
TABLE - FTE.FTE_INVOICE_LINES
TABLE - FTE.FTE_LANES
TABLE - FTE.FTE_LANE_COMMODITIES
TABLE - FTE.FTE_LANE_EQUIPMENTS
TABLE - FTE.FTE_LANE_GROUPS
TABLE - FTE.FTE_LANE_GROUP_COMPONENTS
TABLE - FTE.FTE_LANE_RATE_CHARTS
TABLE - FTE.FTE_LANE_SERVICES
TABLE - FTE.FTE_LANE_VEHICLES
TABLE - FTE.FTE_LOCATION_MILEAGES
TABLE - FTE.FTE_LOCATION_PARAMETERS
TABLE - FTE.FTE_MESSAGE_ADDRESS
TABLE - FTE.FTE_MESSAGE_CONTACT
TABLE - FTE.FTE_MESSAGE_LOCATION
TABLE - FTE.FTE_MESSAGE_PARTNER
TABLE - FTE.FTE_MILE_ATTRIBUTES
TABLE - FTE.FTE_MILE_COLUMN_ATTRIBUTES
TABLE - FTE.FTE_MILE_DOWNLOAD_FILES
TABLE - FTE.FTE_MILE_DOWNLOAD_LINES
TABLE - FTE.FTE_MILE_TEMPLATES
TABLE - FTE.FTE_MILE_TEMPLATE_COLUMNS
TABLE - FTE.FTE_MOVES
TABLE - FTE.FTE_MOVES_INTERFACE
TABLE - FTE.FTE_PRC_PARAMETERS
TABLE - FTE.FTE_PRC_PARAMETER_DEFAULTS
TABLE - FTE.FTE_PTRK_EVENTS
TABLE - FTE.FTE_PTRK_PAGES
TABLE - FTE.FTE_PTRK_PARAMS
TABLE - FTE.FTE_PTRK_SOURCES
TABLE - FTE.FTE_SCHEDULES
TABLE - FTE.FTE_SEL_ATTRIBUTES
TABLE - FTE.FTE_SEL_ATTRIBUTES_TMP
TABLE - FTE.FTE_SEL_GROUPS
TABLE - FTE.FTE_SEL_GROUP_ASSIGNMENTS
TABLE - FTE.FTE_SEL_GROUP_ATTRIBUTES
TABLE - FTE.FTE_SEL_OBJECTS
TABLE - FTE.FTE_SEL_RESULTS
TABLE - FTE.FTE_SEL_RESULT_ASSIGNMENTS
TABLE - FTE.FTE_SEL_RESULT_ATTRIBUTES
TABLE - FTE.FTE_SEL_RULES
TABLE - FTE.FTE_SEL_RULE_RESTRICTIONS
TABLE - FTE.FTE_SHIPMENT_STATUS_DETAILS
TABLE - FTE.FTE_SHIPMENT_STATUS_EXCEPTIONS
TABLE - FTE.FTE_SHIPMENT_STATUS_HEADERS
TABLE - FTE.FTE_TARIFF_CARRIERS
TABLE - FTE.FTE_TENDER_SNAPSHOT
TABLE - FTE.FTE_TRIPS
TABLE - FTE.FTE_TRIP_MOVES
TABLE - FTE.FTE_TRIP_MOVES_INTERFACE
TABLE - FTE.FTE_VEHICLE_FEATURES
TABLE - FTE.FTE_VEHICLE_TYPES
TABLE - FTE.FTE_WSH_TRIPS
VIEW - APPS.FTE_PRC_LANE_COMP_UI_V
VIEW - APPS.FTE_PRC_VIEW_PRICE_UI_V
VIEW - APPS.FTE_PTRK_TOKENS_V

Table: FTE_BULKLOAD_DATA

Description: This table is used to store data related to download and upload for the Bulkload processing.
Primary Key: FTE_BULKLOAD_DATA_PK
  1. LOAD_ID

[top of page]

FTE.FTE_BULKLOAD_DATA does not reference any database object

FTE.FTE_BULKLOAD_DATA is referenced by following:

FTE
VIEW - FTE_BULKLOAD_DATA#

[top of page]

Table: FTE_BULKLOAD_FILE

Description: This table is used to store data related to download LTL files.

[top of page]

FTE.FTE_BULKLOAD_FILE does not reference any database object

FTE.FTE_BULKLOAD_FILE is referenced by following:

FTE
VIEW - FTE_BULKLOAD_FILE#

[top of page]

Table: FTE_DELIVERY_PROOF

Description: Proof of Delivery Message
Primary Key: FTE_DELIVERY_PROOF_PK
  1. ID

[top of page]

FTE.FTE_DELIVERY_PROOF does not reference any database object

FTE.FTE_DELIVERY_PROOF is referenced by following:

FTE
VIEW - FTE_DELIVERY_PROOF#

[top of page]

Table: FTE_ESTIMATE_RATES_DEL_TEMP

Description:

[top of page]

FTE.FTE_ESTIMATE_RATES_DEL_TEMP does not reference any database object

FTE.FTE_ESTIMATE_RATES_DEL_TEMP is referenced by following:

APPS
SYNONYM - FTE_ESTIMATE_RATES_DEL_TEMP

[top of page]

Table: FTE_FACILITY_CARRIERS

Description: Stores the data for the association between a Facility location and a Carrier.

[top of page]

FTE.FTE_FACILITY_CARRIERS does not reference any database object

FTE.FTE_FACILITY_CARRIERS is referenced by following:

FTE
VIEW - FTE_FACILITY_CARRIERS#

[top of page]

Table: FTE_FAILURE_REASONS

Description: This table is used to store failure reasons for FPA
Primary Key: FTE_FAILUER_REASONS_PK
  1. INVOICE_REJECT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_FAILURE_REASONS.PARENT_ID %
FTE_FAILURE_REASONS.PARENT_ID FTE_INVOICE_LINES

[top of page]

FTE.FTE_FAILURE_REASONS does not reference any database object

FTE.FTE_FAILURE_REASONS is referenced by following:

FTE
VIEW - FTE_FAILURE_REASONS#

[top of page]

Table: FTE_FREIGHT_COSTS_TEMP

Description: Stores temporary data for rating estimates
Primary Key: FTE_FREIGHT_COSTS_TEMP_PK1
  1. FREIGHT_COST_ID

[top of page]

FTE.FTE_FREIGHT_COSTS_TEMP does not reference any database object

FTE.FTE_FREIGHT_COSTS_TEMP is referenced by following:

FTE
VIEW - FTE_FREIGHT_COSTS_TEMP#

[top of page]

Table: FTE_FREIGHT_ESTIMATE_TEMP

Description:

[top of page]

FTE.FTE_FREIGHT_ESTIMATE_TEMP does not reference any database object

FTE.FTE_FREIGHT_ESTIMATE_TEMP is referenced by following:

APPS
SYNONYM - FTE_FREIGHT_ESTIMATE_TEMP

[top of page]

Table: FTE_INTERFACE_LANES

Description: Interface table for Lanes.

[top of page]

FTE.FTE_INTERFACE_LANES does not reference any database object

FTE.FTE_INTERFACE_LANES is referenced by following:

FTE
VIEW - FTE_INTERFACE_LANES#

[top of page]

Table: FTE_INTERFACE_ZONES

Description: Interface table for Zones.

[top of page]

FTE.FTE_INTERFACE_ZONES does not reference any database object

FTE.FTE_INTERFACE_ZONES is referenced by following:

FTE
VIEW - FTE_INTERFACE_ZONES#

[top of page]

Table: FTE_INVOICE_HEADERS

Description: Table to store invoice header information
Primary Key: FTE_INVOICE_HEADERS_PK
  1. INVOICE_HEADER_ID

[top of page]

FTE.FTE_INVOICE_HEADERS does not reference any database object

FTE.FTE_INVOICE_HEADERS is referenced by following:

FTE
VIEW - FTE_INVOICE_HEADERS#

[top of page]

Table: FTE_INVOICE_HISTORY

Description: Table to store invoice history information
Primary Key: FTE_INVOICE_HISTORY_PK
  1. INVOICE_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_INVOICE_HISTORY.PARENT_ID %
FTE_INVOICE_HISTORY.PARENT_ID %

[top of page]

FTE.FTE_INVOICE_HISTORY does not reference any database object

FTE.FTE_INVOICE_HISTORY is referenced by following:

FTE
VIEW - FTE_INVOICE_HISTORY#

[top of page]

Table: FTE_INVOICE_LINES

Description: Table to store invoice line information
Primary Key: FTE_INVOICE_LINES_PK
  1. INVOICE_LINE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_FAILURE_REASONS.PARENT_ID FTE_INVOICE_LINES

[top of page]

FTE.FTE_INVOICE_LINES does not reference any database object

FTE.FTE_INVOICE_LINES is referenced by following:

FTE
VIEW - FTE_INVOICE_LINES#

[top of page]

Table: FTE_LANES

Description: Stores services catalog lane descriptions.
Primary Key: FTE_LANES_PK
  1. LANE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANES.DESTINATION_ID WSH_REGIONS
FTE_LANES.ORIGIN_ID WSH_REGIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SCHEDULES.LANE_ID FTE_LANES
FTE_LANE_COMMODITIES.LANE_ID FTE_LANES
FTE_LANE_EQUIPMENTS.LANE_ID FTE_LANES
FTE_LANE_GROUP_COMPONENTS.LANE_ID FTE_LANES
FTE_LANE_RATE_CHARTS.LANE_ID FTE_LANES
FTE_LANE_SERVICES.LANE_ID FTE_LANES
FTE_LOAD_CHARGES.LANE_ID FTE_LANES
FTE_LOAD_SCHEDULES.LANE_ID FTE_LANES
FTE_PRC_PARAMETERS.LANE_ID FTE_LANES

[top of page]

FTE.FTE_LANES does not reference any database object

FTE.FTE_LANES is referenced by following:

FTE
VIEW - FTE_LANES#

[top of page]

Table: FTE_LANE_COMMODITIES

Description: Stores commodity information for each lane
Primary Key: FTE_LANE_COMMODITIES_PK
  1. LANE_COMMODITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_COMMODITIES.LANE_ID FTE_LANES
FTE_LANE_COMMODITIES.COMMODITY_CATG_ID MTL_CATEGORIES_B

[top of page]

FTE.FTE_LANE_COMMODITIES does not reference any database object

FTE.FTE_LANE_COMMODITIES is referenced by following:

FTE
VIEW - FTE_LANE_COMMODITIES#

[top of page]

Table: FTE_LANE_EQUIPMENTS

Description: Stores equipment information for each lane
Primary Key: FTE_LANE_EQUIPMENTS_PK
  1. LANE_EQUIPMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_EQUIPMENTS.LANE_ID FTE_LANES

[top of page]

FTE.FTE_LANE_EQUIPMENTS does not reference any database object

FTE.FTE_LANE_EQUIPMENTS is referenced by following:

FTE
VIEW - FTE_LANE_EQUIPMENTS#

[top of page]

Table: FTE_LANE_GROUPS

Description: Stores header information regarding a group of lanes
Primary Key: FTE_LANE_GROUPS_PK
  1. LANE_GROUP_ID

[top of page]

FTE.FTE_LANE_GROUPS does not reference any database object

FTE.FTE_LANE_GROUPS is referenced by following:

FTE
VIEW - FTE_LANE_GROUPS#

[top of page]

Table: FTE_LANE_GROUP_COMPONENTS

Description: Details table that holds the lane components of a lane group
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_GROUP_COMPONENTS.LANE_ID FTE_LANES
FTE_LANE_GROUP_COMPONENTS.LANE_GROUP_ID %

[top of page]

FTE.FTE_LANE_GROUP_COMPONENTS does not reference any database object

FTE.FTE_LANE_GROUP_COMPONENTS is referenced by following:

FTE
VIEW - FTE_LANE_GROUP_COMPONENTS#

[top of page]

Table: FTE_LANE_RATE_CHARTS

Description: Association between lane and rate charts
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_RATE_CHARTS.LANE_ID FTE_LANES
FTE_LANE_RATE_CHARTS.LIST_HEADER_ID QP_LIST_HEADERS_B

[top of page]

FTE.FTE_LANE_RATE_CHARTS does not reference any database object

FTE.FTE_LANE_RATE_CHARTS is referenced by following:

FTE
VIEW - FTE_LANE_RATE_CHARTS#

[top of page]

Table: FTE_LANE_SERVICES

Description: Stores service information for each lane
Primary Key: FTE_LANE_SERVICES_PK
  1. LANE_SERVICE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_SERVICES.LANE_ID FTE_LANES

[top of page]

FTE.FTE_LANE_SERVICES does not reference any database object

FTE.FTE_LANE_SERVICES is referenced by following:

FTE
VIEW - FTE_LANE_SERVICES#

[top of page]

Table: FTE_LANE_VEHICLES

Description: Stores the Vehicle associated to Lanes and Lane Groups

[top of page]

FTE.FTE_LANE_VEHICLES does not reference any database object

FTE.FTE_LANE_VEHICLES is referenced by following:

FTE
VIEW - FTE_LANE_VEHICLES#

[top of page]

Table: FTE_LOCATION_MILEAGES

Description: This table is used to store the distance and transit times between two locations (origin and destination), where the locations are identified as regions. The primary key for the table is origin_id - destination_id.
Primary Key: FTE_LOCATION_MILEAGES_PK1
  1. ORIGIN_ID
  2. DESTINATION_ID

[top of page]

FTE.FTE_LOCATION_MILEAGES does not reference any database object

FTE.FTE_LOCATION_MILEAGES is referenced by following:

FTE
VIEW - FTE_LOCATION_MILEAGES#

[top of page]

Table: FTE_LOCATION_PARAMETERS

Description: Stores Facility definition and it's parameters.
Primary Key: FTE_LOCATION_PARAMETERS_PK
  1. FACILITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LOCATION_PARAMETERS.FACILITY_CONTACT_ID HZ_PARTIES

[top of page]

FTE.FTE_LOCATION_PARAMETERS does not reference any database object

FTE.FTE_LOCATION_PARAMETERS is referenced by following:

FTE
VIEW - FTE_LOCATION_PARAMETERS#

[top of page]

Table: FTE_MESSAGE_ADDRESS

Description: Stores Addresses listed in tracking messages
Primary Key: FTE_MESSAGE_ADDRESS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MESSAGE_ADDRESS.ADDRESS_TO_ID FTE_MESSAGE_PARTNER

[top of page]

FTE.FTE_MESSAGE_ADDRESS does not reference any database object

FTE.FTE_MESSAGE_ADDRESS is referenced by following:

FTE
VIEW - FTE_MESSAGE_ADDRESS#

[top of page]

Table: FTE_MESSAGE_CONTACT

Description: This stores the contact portion of the showshipstatus message
Primary Key: FTE_MESSAGE_CONTACT_PK
  1. CONTACT_ID

[top of page]

FTE.FTE_MESSAGE_CONTACT does not reference any database object

FTE.FTE_MESSAGE_CONTACT is referenced by following:

FTE
VIEW - FTE_MESSAGE_CONTACT#

[top of page]

Table: FTE_MESSAGE_LOCATION

Description: Stores all the locations mentioned in a shipstatus message
Primary Key: FTE_MESSAGE_LOCATION_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MESSAGE_LOCATION.LOCATION_TO_ID FTE_SHIPMENT_STATUS_DETAILS

[top of page]

FTE.FTE_MESSAGE_LOCATION does not reference any database object

FTE.FTE_MESSAGE_LOCATION is referenced by following:

FTE
VIEW - FTE_MESSAGE_LOCATION#

[top of page]

Table: FTE_MESSAGE_PARTNER

Description: This table stores all the partners listed in the Shipstatus message
Primary Key: FTE_MESSAGE_PARTNER_PK
  1. ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MESSAGE_ADDRESS.ADDRESS_TO_ID FTE_MESSAGE_PARTNER

[top of page]

FTE.FTE_MESSAGE_PARTNER does not reference any database object

FTE.FTE_MESSAGE_PARTNER is referenced by following:

FTE
VIEW - FTE_MESSAGE_PARTNER#

[top of page]

Table: FTE_MILE_ATTRIBUTES

Description: The table is used to store the attributes that make up the columns (origin, destination and return) in the download file. E.g. 'CITY', 'STATE', etc... The data in this table is seeded and is not updateable by the user.
Primary Key: FTE_MILE_ATTRIBUTES_PK1
  1. ATTRIBUTE_ID

[top of page]

FTE.FTE_MILE_ATTRIBUTES does not reference any database object

FTE.FTE_MILE_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_MILE_ATTRIBUTES#

[top of page]

Table: FTE_MILE_COLUMN_ATTRIBUTES

Description: This table is used to store the attribute data used for the relevant columns in the download/upload file.
Primary Key: FTE_MILE_COLUMN_ATTRIBUTES_PK1
  1. COLUMN_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MILE_COLUMN_ATTRIBUTES.COLUMN_ID FTE_MILE_TEMPLATE_COLUMNS

[top of page]

FTE.FTE_MILE_COLUMN_ATTRIBUTES does not reference any database object

FTE.FTE_MILE_COLUMN_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_MILE_COLUMN_ATTRIBUTES#

[top of page]

Table: FTE_MILE_DOWNLOAD_FILES

Description: This table is used to store the information of the file created for download. When uploading a file, this table will be checked to ensure that the file is valid and then to get the formatting data from the related template that was used to
Primary Key: FTE_MILE_DOWNLOAD_FILES_PK1
  1. DOWNLOAD_FILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MILE_DOWNLOAD_FILES.TEMPLATE_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MILE_DOWNLOAD_LINES.DOWNLOAD_FILE_ID FTE_MILE_DOWNLOAD_FILES

[top of page]

FTE.FTE_MILE_DOWNLOAD_FILES does not reference any database object

FTE.FTE_MILE_DOWNLOAD_FILES is referenced by following:

FTE
VIEW - FTE_MILE_DOWNLOAD_FILES#

[top of page]

Table: FTE_MILE_DOWNLOAD_LINES

Description: This table is used to store the contents of the download file. When the file is uploaded to the database the file is parsed and each related line from the file is read from the table and the origin and destination id pairs along with the di
Primary Key: FTE_MILE_DOWNLOAD_LINES_PK1
  1. DOWNLOAD_FILE_ID
  2. LINE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MILE_DOWNLOAD_LINES.DOWNLOAD_FILE_ID FTE_MILE_DOWNLOAD_FILES

[top of page]

FTE.FTE_MILE_DOWNLOAD_LINES does not reference any database object

FTE.FTE_MILE_DOWNLOAD_LINES is referenced by following:

FTE
VIEW - FTE_MILE_DOWNLOAD_LINES#

[top of page]

Table: FTE_MILE_TEMPLATES

Description: This table is used to store the template header information that is used to format the file for download and read the upload file for loading the file data into the database.
Primary Key: FTE_MILE_TEMPLATES_PK1
  1. TEMPLATE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MILE_TEMPLATE_COLUMNS.TEMPLATE_ID FTE_MILE_TEMPLATES

[top of page]

FTE.FTE_MILE_TEMPLATES does not reference any database object

FTE.FTE_MILE_TEMPLATES is referenced by following:

FTE
VIEW - FTE_MILE_TEMPLATES#

[top of page]

Table: FTE_MILE_TEMPLATE_COLUMNS

Description: This table is used to store the column data that is used to format the download/upload file.
Primary Key: FTE_MILE_TEMPLATE_COLUMNS_PK1
  1. COLUMN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MILE_TEMPLATE_COLUMNS.TEMPLATE_ID FTE_MILE_TEMPLATES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MILE_COLUMN_ATTRIBUTES.COLUMN_ID FTE_MILE_TEMPLATE_COLUMNS

[top of page]

FTE.FTE_MILE_TEMPLATE_COLUMNS does not reference any database object

FTE.FTE_MILE_TEMPLATE_COLUMNS is referenced by following:

FTE
VIEW - FTE_MILE_TEMPLATE_COLUMNS#

[top of page]

Table: FTE_MOVES

Description:
Primary Key: FTE_MOVES_PK
  1. MOVE_ID

[top of page]

FTE.FTE_MOVES does not reference any database object

FTE.FTE_MOVES is referenced by following:

FTE
VIEW - FTE_MOVES#

[top of page]

Table: FTE_MOVES_INTERFACE

Description:
Primary Key: FTE_MOVES_INTERFACE_PK
  1. MOVE_INTERFACE_ID

[top of page]

FTE.FTE_MOVES_INTERFACE does not reference any database object

FTE.FTE_MOVES_INTERFACE is referenced by following:

FTE
VIEW - FTE_MOVES_INTERFACE#

[top of page]

Table: FTE_PRC_PARAMETERS

Description: Stores pricing parameters
Primary Key: FTE_PRC_PARAMETERS_PK
  1. PARAMETER_INSTANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_PRC_PARAMETERS.LANE_ID FTE_LANES
FTE_PRC_PARAMETERS.LIST_HEADER_ID QP_LIST_HEADERS_B
FTE_PRC_PARAMETERS.PARAMETER_ID FTE_PRC_PARAMETER_DEFAULTS

[top of page]

FTE.FTE_PRC_PARAMETERS does not reference any database object

FTE.FTE_PRC_PARAMETERS is referenced by following:

FTE
VIEW - FTE_PRC_PARAMETERS#

[top of page]

Table: FTE_PRC_PARAMETER_DEFAULTS

Description: Stores default values for pricing parameters
Primary Key: FTE_PRC_PARAMETER_DEFAULTS_PK
  1. PARAMETER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_PRC_PARAMETERS.PARAMETER_ID FTE_PRC_PARAMETER_DEFAULTS

[top of page]

FTE.FTE_PRC_PARAMETER_DEFAULTS does not reference any database object

FTE.FTE_PRC_PARAMETER_DEFAULTS is referenced by following:

FTE
VIEW - FTE_PRC_PARAMETER_DEFAULTS#

[top of page]

Table: FTE_PTRK_EVENTS

Description: Table to store tracking events

[top of page]

FTE.FTE_PTRK_EVENTS does not reference any database object

FTE.FTE_PTRK_EVENTS is referenced by following:

FTE
VIEW - FTE_PTRK_EVENTS#

[top of page]

Table: FTE_PTRK_PAGES

Description: Table to store tracking header information
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_PTRK_PAGES.CARRIER_PARTY_ID HZ_PARTIES

[top of page]

FTE.FTE_PTRK_PAGES does not reference any database object

FTE.FTE_PTRK_PAGES is referenced by following:

FTE
VIEW - FTE_PTRK_PAGES#

[top of page]

Table: FTE_PTRK_PARAMS

Description: Table to store tracking parameter information

[top of page]

FTE.FTE_PTRK_PARAMS does not reference any database object

FTE.FTE_PTRK_PARAMS is referenced by following:

FTE
VIEW - FTE_PTRK_PARAMS#

[top of page]

Table: FTE_PTRK_SOURCES

Description: Table to store tracking type information

[top of page]

FTE.FTE_PTRK_SOURCES does not reference any database object

FTE.FTE_PTRK_SOURCES is referenced by following:

FTE
VIEW - FTE_PTRK_SOURCES#

[top of page]

Table: FTE_SCHEDULES

Description: Stores schedule information for each lane. This is the main catalog entity for schedules
Primary Key: FTE_SCHEDULES_PK
  1. SCHEDULES_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SCHEDULES.LANE_ID FTE_LANES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_LOAD_SCHEDULES.ORIGINAL_SCHEDULE_ID FTE_SCHEDULES

[top of page]

FTE.FTE_SCHEDULES does not reference any database object

FTE.FTE_SCHEDULES is referenced by following:

FTE
VIEW - FTE_SCHEDULES#

[top of page]

Table: FTE_SEL_ATTRIBUTES

Description: This table holds all attribute definitions. Each attribute is linked to an object defined in FTE_SEL_OBJECTS, E.g. an object could be 'Carrier_selection', and by linking attributes to that object the attributes become available for use by
Primary Key: FTE_SEL_ATTRIBUTES_PK1
  1. ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_ATTRIBUTES.OBJECT_ID FTE_SEL_OBJECTS

[top of page]

FTE.FTE_SEL_ATTRIBUTES does not reference any database object

FTE.FTE_SEL_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_SEL_ATTRIBUTES#

[top of page]

Table: FTE_SEL_ATTRIBUTES_TMP

Description: This table provides a temporary storage for input attributes and values that may be used to query the specified object, e.g. 'carrier_selection'. The attributes to be used in a single query are grouped together by the query_id value. After

[top of page]

FTE.FTE_SEL_ATTRIBUTES_TMP does not reference any database object

FTE.FTE_SEL_ATTRIBUTES_TMP is referenced by following:

FTE
VIEW - FTE_SEL_ATTRIBUTES_TMP#

[top of page]

Table: FTE_SEL_GROUPS

Description: This table is used define groups which are used to consolidate rules to an entity such as a customer, customer site , shipping organization or shipping enterprise. The assignation of groups to entities is done via the FTE_SEL_GROUP_ASSIGNME
Primary Key: FTE_SEL_GROUPS_PK1
  1. GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_GROUPS.OBJECT_ID FTE_SEL_OBJECTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SEL_GROUP_ATTRIBUTES.GROUP_ID FTE_SEL_GROUPS
FTE_SEL_GROUP_ASSIGNMENTS.GROUP_ID FTE_SEL_GROUPS
FTE_SEL_RULES.GROUP_ID FTE_SEL_GROUPS

[top of page]

FTE.FTE_SEL_GROUPS does not reference any database object

FTE.FTE_SEL_GROUPS is referenced by following:

FTE
VIEW - FTE_SEL_GROUPS#

[top of page]

Table: FTE_SEL_GROUP_ASSIGNMENTS

Description: this table provides the method to assign entities such as customer, customer site, shipping organization, etc... to a group or groups. The shipping enterprise group is not assigned in this table as the shipping enterprise is not defined as
Primary Key: FTE_SEL_GROUP_ASSIGNMENTS_PK1
  1. GROUP_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_GROUP_ASSIGNMENTS.GROUP_ID FTE_SEL_GROUPS

[top of page]

FTE.FTE_SEL_GROUP_ASSIGNMENTS does not reference any database object

FTE.FTE_SEL_GROUP_ASSIGNMENTS is referenced by following:

FTE
VIEW - FTE_SEL_GROUP_ASSIGNMENTS#

[top of page]

Table: FTE_SEL_GROUP_ATTRIBUTES

Description: This table provides the method of associating individual attributes defined in FTE_SEL_ATTRIBUTES for a specific object to a group also assigned to the object. Attributes and groups must be associated with the same object in order to be abl
Primary Key: FTE_SEL_GROUP_ATTRIBUTES_PK1
  1. GROUP_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_GROUP_ATTRIBUTES.GROUP_ID FTE_SEL_GROUPS

[top of page]

FTE.FTE_SEL_GROUP_ATTRIBUTES does not reference any database object

FTE.FTE_SEL_GROUP_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_SEL_GROUP_ATTRIBUTES#

[top of page]

Table: FTE_SEL_OBJECTS

Description: This table holds object definitions that may use the selection tables and for retrieval of certain information, e.g. defining an object such as 'carrier_selection' allows a rule-based data system for the specific purpose of selection of ca
Primary Key: FTE_SEL_OBJECTS_PK1
  1. OBJECT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SEL_ATTRIBUTES.OBJECT_ID FTE_SEL_OBJECTS
FTE_SEL_GROUPS.OBJECT_ID FTE_SEL_OBJECTS

[top of page]

FTE.FTE_SEL_OBJECTS does not reference any database object

FTE.FTE_SEL_OBJECTS is referenced by following:

FTE
VIEW - FTE_SEL_OBJECTS#

[top of page]

Table: FTE_SEL_RESULTS

Description: This table holds the result header information. Result attributes and values are stored in the FTE_SEL_RESULTS table. A result may have one or more attributes.
Primary Key: FTE_SEL_RESULTS_PK1
  1. RESULT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SEL_RESULT_ATTRIBUTES.RESULT_ID FTE_SEL_RESULTS
FTE_SEL_RESULT_ASSIGNMENTS.RESULT_ID FTE_SEL_RESULTS

[top of page]

FTE.FTE_SEL_RESULTS does not reference any database object

FTE.FTE_SEL_RESULTS is referenced by following:

FTE
VIEW - FTE_SEL_RESULTS#

[top of page]

Table: FTE_SEL_RESULT_ASSIGNMENTS

Description: This table provides the method of assigning multiple results to multiple rules.
Primary Key: FTE_SEL_RESULT_ASSIGNMENTS_PK1
  1. RESULT_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_RESULT_ASSIGNMENTS.RULE_ID FTE_SEL_RULES
FTE_SEL_RESULT_ASSIGNMENTS.RESULT_ID FTE_SEL_RESULTS

[top of page]

FTE.FTE_SEL_RESULT_ASSIGNMENTS does not reference any database object

FTE.FTE_SEL_RESULT_ASSIGNMENTS is referenced by following:

FTE
VIEW - FTE_SEL_RESULT_ASSIGNMENTS#

[top of page]

Table: FTE_SEL_RESULT_ATTRIBUTES

Description: This table holds attributes and attribute values for specific results. Each result attribute must be assigned to a result.
Primary Key: FTE_SEL_RESULT_ATTRIBUTES_PK1
  1. RESULT_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_RESULT_ATTRIBUTES.RESULT_ID FTE_SEL_RESULTS

[top of page]

FTE.FTE_SEL_RESULT_ATTRIBUTES does not reference any database object

FTE.FTE_SEL_RESULT_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_SEL_RESULT_ATTRIBUTES#

[top of page]

Table: FTE_SEL_RULES

Description: this table holds header level rule information, such as rule id and name. The attributes (or restrictions) that make up the rule are defined in the FTE_SEL_RULE_RESTRICTIONS table.
Primary Key: FTE_SEL_RULES_PK1
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_RULES.GROUP_ID FTE_SEL_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SEL_RULE_RESTRICTIONS.RULE_ID FTE_SEL_RULES
FTE_SEL_RESULT_ASSIGNMENTS.RULE_ID FTE_SEL_RULES

[top of page]

FTE.FTE_SEL_RULES does not reference any database object

FTE.FTE_SEL_RULES is referenced by following:

FTE
VIEW - FTE_SEL_RULES#

[top of page]

Table: FTE_SEL_RULE_RESTRICTIONS

Description: This table holds the arrtibutes that make up a rule. Attributes are grouped by rule_id. It is this table that is queried by the code in order to find a result (defined in FTE_SEL_RESULTS). Rule restriction may be of numeric or character typ
Primary Key: FTE_SEL_RULE_RESTRICTIONS_PK1
  1. RULE_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_RULE_RESTRICTIONS.RULE_ID FTE_SEL_RULES

[top of page]

FTE.FTE_SEL_RULE_RESTRICTIONS does not reference any database object

FTE.FTE_SEL_RULE_RESTRICTIONS is referenced by following:

FTE
VIEW - FTE_SEL_RULE_RESTRICTIONS#

[top of page]

Table: FTE_SHIPMENT_STATUS_DETAILS

Description: Holds the Detail element of the ShipStatus message
Primary Key: FTE_SHIPMENT_STATUS_DETAILS_PK
  1. SHIPMENT_STATUS_DETAIL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MESSAGE_LOCATION.LOCATION_TO_ID FTE_SHIPMENT_STATUS_DETAILS
FTE_SHIPMENT_STATUS_EXCEPTIONS.DETAIL_ID FTE_SHIPMENT_STATUS_DETAILS

[top of page]

FTE.FTE_SHIPMENT_STATUS_DETAILS does not reference any database object

FTE.FTE_SHIPMENT_STATUS_DETAILS is referenced by following:

FTE
VIEW - FTE_SHIPMENT_STATUS_DETAILS#

[top of page]

Table: FTE_SHIPMENT_STATUS_EXCEPTIONS

Description: This table holds the Exception portion of the ShowShipment message
Primary Key: FTE_SHIPMENT_STATUS_EXCEP_PK
  1. EXCEPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SHIPMENT_STATUS_EXCEPTIONS.DETAIL_ID FTE_SHIPMENT_STATUS_DETAILS

[top of page]

FTE.FTE_SHIPMENT_STATUS_EXCEPTIONS does not reference any database object

FTE.FTE_SHIPMENT_STATUS_EXCEPTIONS is referenced by following:

FTE
VIEW - FTE_SHIPMENT_STATUS_EXCEPTION#

[top of page]

Table: FTE_SHIPMENT_STATUS_HEADERS

Description: This table holds the Main body of the ShowShipment message
Primary Key: FTE_SHIPMENT_STATUS_HEADERS_PK
  1. SHIPMENT_STATUS_ID

[top of page]

FTE.FTE_SHIPMENT_STATUS_HEADERS does not reference any database object

FTE.FTE_SHIPMENT_STATUS_HEADERS is referenced by following:

FTE
VIEW - FTE_SHIPMENT_STATUS_HEADERS#

[top of page]

Table: FTE_TARIFF_CARRIERS

Description:
Primary Key: FTE_TARIFF_CARRIERS_PK
  1. TARIFF_NAME
  2. CARRIER_ID

[top of page]

FTE.FTE_TARIFF_CARRIERS does not reference any database object

FTE.FTE_TARIFF_CARRIERS is referenced by following:

FTE
VIEW - FTE_TARIFF_CARRIERS#

[top of page]

Table: FTE_TENDER_SNAPSHOT

Description: Stores the snapshot of trip stops while tendering

[top of page]

FTE.FTE_TENDER_SNAPSHOT does not reference any database object

FTE.FTE_TENDER_SNAPSHOT is referenced by following:

FTE
VIEW - FTE_TENDER_SNAPSHOT#

[top of page]

Table: FTE_TRIPS

Description: This table is use to store transporation trip information
Primary Key: FTE_TRIPS_PK
  1. FTE_TRIP_ID

[top of page]

FTE.FTE_TRIPS does not reference any database object

FTE.FTE_TRIPS is referenced by following:

FTE
VIEW - FTE_TRIPS#

[top of page]

Table: FTE_TRIP_MOVES

Description:
Primary Key: FTE_TRIP_MOVES_PK
  1. TRIP_MOVE_ID

[top of page]

FTE.FTE_TRIP_MOVES does not reference any database object

FTE.FTE_TRIP_MOVES is referenced by following:

FTE
VIEW - FTE_TRIP_MOVES#

[top of page]

Table: FTE_TRIP_MOVES_INTERFACE

Description:
Primary Key: FTE_TRIP_MOVES_INTERFACE_PK
  1. TRIP_MOVE_INTERFACE_ID

[top of page]

FTE.FTE_TRIP_MOVES_INTERFACE does not reference any database object

FTE.FTE_TRIP_MOVES_INTERFACE is referenced by following:

FTE
VIEW - FTE_TRIP_MOVES_INTERFACE#

[top of page]

Table: FTE_VEHICLE_FEATURES

Description: stores additional vehicle features of the Vehicle Type. One Vehicle Type can have more than one rows.

[top of page]

FTE.FTE_VEHICLE_FEATURES does not reference any database object

FTE.FTE_VEHICLE_FEATURES is referenced by following:

FTE
VIEW - FTE_VEHICLE_FEATURES#

[top of page]

Table: FTE_VEHICLE_TYPES

Description: stores the attributes of Vehicle Type. Inventory Item related attributes are saved in MTL_SYSTEM_ITEMS

[top of page]

FTE.FTE_VEHICLE_TYPES does not reference any database object

FTE.FTE_VEHICLE_TYPES is referenced by following:

FTE
VIEW - FTE_VEHICLE_TYPES#

[top of page]

Table: FTE_WSH_TRIPS

Description: This table records many-to-many association between transportation trips and trip segments.
Primary Key: FTE_WSH_TRIPS_PK
  1. WSH_TRIP_ID
  2. FTE_TRIP_ID

[top of page]

FTE.FTE_WSH_TRIPS does not reference any database object

FTE.FTE_WSH_TRIPS is referenced by following:

FTE
VIEW - FTE_WSH_TRIPS#

[top of page]

View: FTE_PRC_LANE_COMP_UI_V

[top of page]

APPS.FTE_PRC_LANE_COMP_UI_V references the following:

APPS
SYNONYM - FTE_FREIGHT_COSTS_TEMP
PACKAGE - FTE_FREIGHT_PRICING_UTIL
SYNONYM - FTE_LANES
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_FREIGHT_COST_TYPES
- MTL_SYSTEM_ITEMS_KFV

APPS.FTE_PRC_LANE_COMP_UI_V is not referenced by any database object

[top of page]

View: FTE_PRC_VIEW_PRICE_UI_V

[top of page]

APPS.FTE_PRC_VIEW_PRICE_UI_V references the following:

APPS
PACKAGE - FTE_FREIGHT_PRICING_UTIL
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_FREIGHT_COSTS
SYNONYM - WSH_FREIGHT_COST_TYPES
SYNONYM - WSH_NEW_DELIVERIES
- MTL_SYSTEM_ITEMS_KFV

APPS.FTE_PRC_VIEW_PRICE_UI_V is not referenced by any database object

[top of page]

View: FTE_PTRK_TOKENS_V

[top of page]

APPS.FTE_PTRK_TOKENS_V references the following:

APPS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_LOCATIONS
SYNONYM - WSH_TRIP_STOPS

APPS.FTE_PTRK_TOKENS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract