Search Results lane_commodity_id

Overview

The FTE_LANE_COMMODITIES table is a core data object within the Oracle E-Business Suite (EBS) Transportation Execution (FTE) module. It functions as a junction table that establishes and stores the specific commodity classifications associated with transportation lanes. A lane defines a route between a source and a destination location, and this table enriches that definition by detailing the types of goods or commodities that are typically or permitted to be moved along that route. Its primary role is to support detailed freight planning, rate management, and carrier selection by linking the logistical path (lane) with the nature of the cargo (commodity), which is a critical factor in transportation costing and compliance.

Key Information Stored

The table's structure centers on linking lane and commodity identifiers. The primary key, LANE_COMMODITY_ID, uniquely identifies each lane-commodity association. The two most critical foreign key columns are LANE_ID, which references the FTE_LANES table to identify the specific transportation route, and COMMODITY_CATG_ID, which references the MTL_CATEGORIES_B table. This link to the Inventory module's category schema allows the system to leverage the standardized, hierarchical commodity classifications already defined within EBS. While the provided metadata does not list all columns, typical implementations may also include attributes to denote a primary commodity for the lane or control the commodity's active status for sourcing and rating purposes.

Common Use Cases and Queries

This table is essential for queries that filter or analyze freight data based on commodity type. A common use case is identifying all available lanes suitable for shipping a specific commodity class, which is fundamental for automated freight rate sourcing. For reporting, it enables the analysis of freight costs or carrier performance segmented by commodity. A typical SQL pattern involves joining this table to the lane and category master tables.

• Finding Lanes for a Commodity: SELECT l.lane_number, cat.segment1 FROM fte_lane_commodities lc, fte_lanes l, mtl_categories_b cat WHERE lc.lane_id = l.lane_id AND lc.commodity_catg_id = cat.category_id AND cat.segment1 = 'ELECTRONICS';
• Listing Commodities for a Lane: SELECT cat.concatenated_segments FROM fte_lane_commodities lc, mtl_categories_b_kfv cat WHERE lc.commodity_catg_id = cat.category_id AND lc.lane_id = 1000;

Related Objects

The FTE_LANE_COMMODITIES table sits at the intersection of two key master data sets. Its primary relationship is with the FTE_LANES table, which holds the master definition of transportation routes. Its second crucial relationship is with the Inventory module's MTL_CATEGORIES_B table, which provides the standardized list of item categories used as commodity codes. This design ensures commodity data consistency across procurement, inventory, and transportation processes. The table is also intrinsically linked to the freight rating and sourcing engines within FTE, which consult these lane-commodity associations to determine applicable rates and service levels.