Search Results fte_lane_equipments_pk

Overview

The FTE_LANE_EQUIPMENTS table is a core data object within the Oracle Transportation Execution (FTE) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a transactional repository for equipment details associated with specific transportation lanes. A lane defines a route between an origin and a destination, and this table enables the assignment of permissible or required equipment types—such as specific trailer sizes, container types, or specialized units—to those lanes. This linkage is fundamental for accurate freight planning, carrier rate management, and shipment execution, ensuring that equipment constraints are considered during the procurement and tendering processes.

Key Information Stored

The table's primary function is to map equipment to lanes. Its structure, as indicated by the provided metadata, centers on a unique identifier and foreign key relationships. The most critical columns include:

• LANE_EQUIPMENT_ID: The primary key (FTE_LANE_EQUIPMENTS_PK) that uniquely identifies each equipment assignment record.
• LANE_ID: A foreign key column linking directly to the FTE_LANES table. This defines the specific transportation route for which the equipment is valid.
• Additional columns (implied by the table's purpose but not detailed in the excerpt) would typically store the EQUIPMENT_TYPE or a reference to a master equipment definition, along with attributes like priority, effective dates, and creation/modification audit information.

Common Use Cases and Queries

This table is primarily accessed during lane definition, rate management, and shipment planning workflows. A common operational query retrieves all valid equipment for a given lane to populate lists during shipment creation. For example:

SELECT equipment_type
FROM fte_lane_equipments
WHERE lane_id = :p_lane_id
AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Conversely, logistics analysts may query to find all lanes that support a specific piece of equipment for network capacity analysis. The table is also critical for reporting on lane-specific equipment constraints and validating carrier compliance against lane equipment requirements during freight audit processes.

Related Objects

FTE_LANE_EQUIPMENTS has a direct and essential relationship with the FTE_LANES table, as enforced by its foreign key constraint. This establishes a one-to-many relationship where one lane can have multiple associated equipment records. The table is a child entity to FTE_LANES. Its data is likely referenced by or integrated with key FTE transactional entities such as shipments (FTE_SHIPMENTS) and rates (FTE_RATES), where lane and equipment are key determinants. While not specified in the metadata, it is common for such setups to have associated views (e.g., FTE_LANE_EQUIPMENTS_V) for reporting and public APIs for programmatic access within the FTE module.