Results for “pricing_engine”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FTE_PRC_VIEW_PRICE_UI_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the FTE – Transportation Execution product family. Its documented purpose is to display freight rates calculated for a delivery leg. The view consolidates pricing engine output held in WSH_FREIGHT_COSTS with delivery, item, and assignment attributes, and presents the result in a single row set suitable for user interface display and downstream reporting. Because it is a view rather than a table, no data is stored in it; every query executes the underlying SQL against the base synonyms at runtime.

Conceptually, the view returns two categories of rows. The first category represents detail-level pricing lines tied to a delivery detail, where each row carries the item, container, weight, and volume attributes of the shipment. The second category, produced by a UNION, represents an aggregate line for the delivery leg as a whole, identified by the lookup meaning for the FTE_PRC_UI_COST_TYPE value of DELIVERY_LEG_TOTAL. This dual structure allows the Transportation Execution rate display to show both per-line charges and the consolidated leg total from one query surface.

Underlying Base Objects

The documented base objects referenced by the view are WSH_FREIGHT_COSTS, WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERY_LEGS, WSH_NEW_DELIVERIES, and WSH_FREIGHT_COST_TYPES (all exposed as synonyms), together with MTL_SYSTEM_ITEMS_KFV (synonym) and the package FTE_FREIGHT_PRICING_UTIL. Joins are driven primarily by DELIVERY_DETAIL_ID across WSH_FREIGHT_COSTS, WSH_DELIVERY_DETAILS, and WSH_DELIVERY_ASSIGNMENTS, and by INVENTORY_ITEM_ID plus ORGANIZATION_ID to MTL_SYSTEM_ITEMS_KFV. Filtering restricts the result to LINE_TYPE_CODE values of PRICE and SUMMARY where CHARGE_SOURCE_CODE equals PRICING_ENGINE, ensuring only pricing-engine-derived charges are returned. The package FTE_FREIGHT_PRICING_UTIL is invoked through GET_LOOKUP_MEANING to translate codes such as CONTAINER_TYPE and FTE_PRC_UI_COST_TYPE into descriptive text.

Key Columns

• ENTITY_ID – For detail rows, the DELIVERY_DETAIL_ID; for the unioned leg-total row, the DELIVERY_LEG_ID.
• PARENT_ENTITY_ID – The parent delivery detail ID where one exists, otherwise the DELIVERY_LEG_ID; the leg-total row carries a constant of -1.
• DELIVERY_LEG_ID – The delivery leg identifier, present on every row and the primary key users filter on when querying pricing for a specific leg.
• ENTITY_NAME – The delivery detail ID rendered as text, or the lookup meaning for DELIVERY_LEG_TOTAL on the aggregate row.
• ITEM_NAME – Concatenated item segments from MTL_SYSTEM_ITEMS_KFV; null on the leg-total row.
• CONTAINER_TYPE, WEIGHT, VOLUME – Descriptive shipment attributes; weight uses gross weight for container-flagged details and otherwise net weight falling back to gross, concatenated with its UOM code.
• PRICE – The total amount concatenated with the currency code from WSH_FREIGHT_COSTS.
• Audit columns – CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID inherited from WSH_FREIGHT_COSTS.

Common Use Cases and Queries

The view is typically used to render the Freight Pricing UI panel for a delivery leg and to support ad hoc price verification. A frequent access pattern filters directly on the documented delivery_leg_id column:

• SELECT delivery_leg_id, entity_id, item_name, container_type, weight, volume, price FROM fte_prc_view_price_ui_v WHERE delivery_leg_id = :delivery_leg_id;
• Aggregating price by leg for reporting: SELECT delivery_leg_id, price FROM fte_prc_view_price_ui_v WHERE entity_name = 'Delivery Leg Total';
• Joining to delivery details or assignments using entity_id to reconcile priced lines against shipped quantities.

Because the view includes a UNION and package function calls, queries should always include a selective predicate such as delivery_leg_id to avoid full scans of WSH_FREIGHT_COSTS. The same view definition applies to both EBS 12.1.1 and 12.2.2.