Results for “pricing_attribute”

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

Overview

The APPS.OE_PRICE_FORMULA_ATTRIBS_V view is a reporting and integration object within the Oracle Order Management (ONT) product family. Its documented purpose is to expose the pricing formula attributes associated with freight charges. In Oracle E-Business Suite 12.1.1 and 12.2.2, freight and service charges on an order line are often driven by Advanced Pricing formulas rather than flat rate lists, and this view provides a denormalized, query-ready projection that joins the order-side price adjustment to the pricing-side list line and formula detail. The view is owned by the APPS schema and is documented with a status of VALID. It is defined entirely as a SELECT over existing base tables and therefore contains no persisted data of its own; all values are derived at query time.

For functional and technical consultants, the view is significant because it bridges two otherwise separate model layers: the Order Management freight/surcharge charge definitions (OE_PRICE_ADJUSTMENTS) and the Advanced Pricing list and formula structures (QP_LIST_LINES, QP_PRICE_FORMULA_LINES). This makes it useful for diagnostics, freight charge audits, and downstream reporting where the formula attribute context and attribute values behind a freight charge must be examined directly.

Underlying Base Objects

The view is defined over three base objects, each referenced through APPS synonyms:

• OE_PRICE_ADJUSTMENTS — the Order Management table holding price adjustment (freight/surcharge) definitions; aliased as OEP in the view definition.
• QP_LIST_LINES — the Advanced Pricing list line table, holding header and line identity plus the PRICE_BY_FORMULA_ID link; aliased as QPL.
• QP_PRICE_FORMULA_LINES — the Advanced Pricing formula line table, holding step, line type, attribute context, attribute name, and numeric constant; aliased as QPF.

The join is a three-way equijoin. OEP.LIST_HEADER_ID and OEP.LIST_LINE_ID are matched to the corresponding QPL columns, establishing the relationship between the order-side adjustment and its pricing list line. QPL.PRICE_BY_FORMULA_ID is then matched to QPF.PRICE_FORMULA_ID, resolving the formula that governs how the attribute is applied. Only adjustments whose list lines are formula-driven will return rows, since an inner join is used throughout. This is precisely the relationship users are looking for when they search on qp_price_formula_lines, and the view is effectively the order-management-facing window onto that table.

Key Columns

• PRICE_ADJUSTMENT_ID — identifier of the source Order Management price adjustment (freight charge definition).
• LIST_HEADER_ID / LIST_LINE_ID — the pricing list header and line to which the adjustment is attached; also the join keys back to QP_LIST_LINES.
• PRICE_FORMULA_ID — the Advanced Pricing formula that the list line is priced by.
• STEP_NUMBER — the sequence position of the formula line within the formula.
• PRICE_FORMULA_LINE_ID — unique identifier of the individual formula line.
• PRICE_FORMULA_LINE_TYPE_CODE — indicates the nature of the formula step (for example, a constant, an attribute reference, or a computed component).
• PRICING_ATTRIBUTE_CONTEXT / PRICING_ATTRIBUTE — the context and name of the pricing attribute consumed by the formula step.
• NUMERIC_CONSTANT — literal numeric value used where the formula line type references a constant.
• PRICE_LIST_LINE_ID / PRICE_MODIFIER_LIST_ID — optional references to source list lines or modifier lists used within the formula.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns inherited from QP_PRICE_FORMULA_LINES.

Common Use Cases and Queries

Typical uses include validating freight formulas configured for a price list, auditing which pricing attributes drive a freight charge, and extracting formula detail for migration or reconciliation. A basic listing is shown below:

• SELECT price_adjustment_id, list_header_id, list_line_id, price_formula_id, step_number, price_formula_line_type_code, pricing_attribute_context, pricing_attribute, numeric_constant FROM oe_price_formula_attribs_v ORDER BY price_adjustment_id, step_number;
• To inspect all formula steps for a specific adjustment: SELECT step_number, price_formula_line_type_code, pricing_attribute_context, pricing_attribute, numeric_constant FROM oe_price_formula_attribs_v WHERE price_adjustment_id = :adjustment_id ORDER BY step_number;
• To find adjustments referencing a particular attribute: SELECT price_adjustment_id, list_line_id, pricing_attribute FROM oe_price_formula_attribs_v WHERE pricing_attribute = :attribute_name;

Because the view is defined with inner joins, adjustments that are not formula-driven are not represented; consultants should query QP_PRICE_FORMULA_LINES directly when formula metadata outside the freight adjustment context is required.