Results for “qp_pricing_attr_v”

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

Overview

QP_PRICING_ATTR_V is an Advanced Pricing (QP) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the qualification attributes and pricing attribute ranges that define which products or product categories qualify for a modifier list line. The view is intended for use by the Modifiers Form, specifically the Additional Buy Products block, where users specify secondary product qualification criteria attached to an existing modifier. It joins list line definitions from QP_LIST_LINES to the qualification attribute rows in QP_PRICING_ATTRIBUTES, presenting a denormalized, form-friendly record set that combines qualifier context, comparison operators, value ranges, and list line pricing attributes such as accrual and rebate metadata.

Because it consolidates modifier header context, list line pricing behavior, and additional qualification attributes into a single row, the view is also useful for reporting and integration purposes where a flat representation of modifier qualification is required. Any column prefixed with QL originates from the list line side, while columns prefixed with QPA originate from the pricing attribute side. The ROW_ID column is derived from QP_LIST_LINES.ROWID, which allows downstream tools that expect a row identifier to update the underlying list line through the view.

Underlying Base Objects

The ETRM documentation identifies three referenced base objects for QP_PRICING_ATTR_V: QP_LIST_LINES, QP_PRICING_ATTRIBUTES, and QP_RLTD_MODIFIERS, all accessed through APPS synonyms. QP_LIST_LINES is the primary list line table and supplies the header-level attributes, pricing attributes, and who columns aliased as QL. QP_PRICING_ATTRIBUTES supplies the per-row qualification detail aliased as QPA. QP_RLTD_MODIFIERS participates in the join used to relate additional qualification rows to the applicable modifier lines, typically on a list line identifier. The view text confirms the aliases, with QL.ROWID exposed as ROW_ID and the descriptive flexfield segment columns CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 sourced from the list line. The view is defined as a non-updatable join over these tables; DML against the modifier and its qualification rows must be performed against the base tables or through the Modifiers Form, not directly through the view.

Key Columns

• ROW_ID — ROWID of the underlying QP_LIST_LINES row, useful for direct row addressing.
• PRICING_ATTRIBUTE_ID — Surrogate key from QP_PRICING_ATTRIBUTES identifying the qualification attribute record.
• LIST_LINE_ID, LIST_HEADER_ID — Link the qualification row to its modifier list line and to the owning modifier list.
• PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE, PRODUCT_ATTR_VALUE, PRODUCT_UOM_CODE — Define the buy product side of the qualification (for example, an item or category attribute and its matching value and unit of measure).
• PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE, PRICING_ATTR_VALUE_FROM, PRICING_ATTR_VALUE_TO — Define the pricing qualifier and its from/to range; the range columns support interval-based qualification.
• COMPARISON_OPERATOR_CODE — The comparison operator applied between the pricing attribute and the supplied value, for example equals, between, or greater than.
• ATTRIBUTE_GROUPING_NO, EXCLUDER_FLAG — Grouping sequence for qualification conditions and the flag indicating whether the row is an inclusion or exclusion condition.
• ATTRIBUTE1 through ATTRIBUTE15, CONTEXT — Descriptive flexfield columns carried from the list line for extensibility.
• ESTIM_ACCRUAL_RATE — Estimated accrual rate carried from QP_LIST_LINES; relevant for accrual and rebate processing that estimates the cost of a modifier benefit.
• REBATE_TRANSACTION_TYPE_CODE — Rebate transaction classification associated with the list line.
• ARITHMETIC_OPERATOR, OPERAND, PRICE_BY_FORMULA_ID — Pricing mechanics of the line, including constant offsets and formula references.
• PRORATION_TYPE_CODE, LIST_LINE_TYPE_CODE — Governs how the benefit prorates across qualifying lines and identifies the line type.
• Standard who columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID.

Common Use Cases and Queries

The view is most often queried to enumerate the additional buy product qualifications attached to modifiers, and to audit qualification ranges including pricing attributes. A representative query retrieving qualification detail for a known list header follows:

• SELECT list_line_id, list_header_id, pricing_attribute_context, pricing_attribute, pricing_attr_value_from, pricing_attr_value_to, comparison_operator_code, excluder_flag FROM qp_pricing_attr_v WHERE list_header_id = :p_header_id ORDER BY list_line_id, attribute_grouping_no; — Lists the qualification conditions for each modifier line under a given header.
• SELECT list_line_id, pricing_attribute, estim_accrual_rate, rebate_transaction_type_code FROM qp_pricing_attr_v WHERE estim_accrual_rate IS NOT NULL; — Identifies modifier lines that carry an estimated accrual rate, useful for accrual and liability reporting where the searched term estim_accrual_rate applies.
• SELECT COUNT(*) FROM qp_pricing_attr_v WHERE product_attribute = :p_item_attribute AND product_attr_value = :p_item_value; — Counts modifier qualifications that reference a specific product attribute value.
• SELECT h.name, v.list_line_id, v.product_attribute, v.product_attr_value, v.pricing_attr_value_from, v.pricing_attr_value_to FROM qp_pricing_attr_v v, qp_list_headers_vl h WHERE v.list_header_id = h.list_header_id AND v.excluder_flag = 'Y'; — Reports exclusion qualifiers, which are critical when diagnosing why a modifier did not apply.
• SELECT list_line_id, attribute1, attribute2 FROM qp_pricing_attr_v WHERE context = :p_dff_context; — Extracts descriptive flexfield attributes carried from the list line.

Analysts commonly join the view to QP_LIST_HEADERS, QP_LIST_LINES, and item or modifier tables to reconcile configuration against expected behavior. In 12.2.2 the object remains valid and the structure is consistent with 12.1.1. Because the view is a join, performance benefits from predicates on LIST_HEADER_ID and LIST_LINE_ID, which allow the optimizer to drive from the list line tables rather than scanning all qualification rows.