Results for “qp_pricing_attr_get_v”

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

Overview

QP_PRICING_ATTR_GET_V is an Advanced Pricing (QP) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. According to the ETRM metadata, it is documented as a "View of Benefit or Get Products for a Modifier" and is consumed by the Modifiers Form. Its purpose is to present the qualifying and benefit product attribute rules attached to a price list line, joining each pricing attribute record to its parent list line so the modifier form can retrieve and display the complete rule context in a single query.

The name reflects its function: "GET" refers to the get/benefit side of a modifier, and "PRICING_ATTR" refers to the pricing attribute conditions that drive the modifier. The view is a reporting and form-support construct rather than a stored table, so it is read-only and exposes no DML. It is relevant to the user's search term "benefit_price_list_line_id" because the underlying list line key (LIST_LINE_ID) is the identifier that links an attribute back to the benefit price list line on which the modifier is defined.

Underlying Base Objects

The view is defined over three documented base objects: QP_LIST_LINES, QP_PRICING_ATTRIBUTES, and QP_RLTD_MODIFIERS, all referenced through APPS synonyms. QP_LIST_LINES supplies the list line header context — the benefit line on which the modifier hangs. QP_PRICING_ATTRIBUTES supplies the attribute-level rule rows, including the comparison operator, attribute context, and value ranges. QP_RLTD_MODIFIERS provides the linkage between modifiers and their related lines, tying the get and benefit sides together.

In the view SQL, columns prefixed QL come from QP_LIST_LINES, and columns prefixed QPA come from QP_PRICING_ATTRIBUTES. The join is established through the pricing attribute's LIST_LINE_ID, which corresponds to the benefit price list line identifier the user searched for. The view carries QL.ROWID as ROW_ID, giving the form a handle to the underlying list line for downstream processing.

Key Columns

• PRICING_ATTRIBUTE_ID / LIST_LINE_ID — primary identifiers linking the attribute rule to the benefit list line (the "benefit_price_list_line_id" concept).
• COMPARISON_OPERATOR_CODE — the operator (=, >=, BETWEEN, etc.) applied to the pricing attribute value.
• PRODUCT_ATTRIBUTE / PRODUCT_ATTR_VALUE / PRODUCT_UOM_CODE — the get-side product qualification data.
• PRICING_ATTRIBUTE / PRICING_ATTR_VALUE_FROM / PRICING_ATTR_VALUE_TO — the pricing attribute and numeric range evaluated for the modifier.
• PRODUCT_ATTRIBUTE_CONTEXT / PRICING_ATTRIBUTE_CONTEXT / CONTEXT — the descriptive flexfield context governing attribute meanings.
• EXCLUDER_FLAG — indicates whether the attribute acts as an exclusion.
• ATTRIBUTE_GROUPING_NO — groups attributes logically within a modifier.
• LIST_LINE_NO, LIST_HEADER_ID, LIST_LINE_TYPE_CODE — list line identity, number, and type from QP_LIST_LINES.
• ARITHMETIC_OPERATOR, OPERAND, PRORATION_TYPE_CODE, BENEFIT_LIMIT — benefit-side modifier behavior, including accrual and proration controls.
• ATTRIBUTE1–ATTRIBUTE15 — DFF segments inherited from the list line.
• Creation/audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID for concurrent program traceability.

Common Use Cases and Queries

The view supports modifier troubleshooting, pricing rule audits, and reconciliation reporting. A typical query groups attributes by their owning benefit line:

• List all pricing attributes for a specific benefit line: SELECT pricing_attribute, comparison_operator_code, pricing_attr_value_from, pricing_attr_value_to FROM qp_pricing_attr_get_v WHERE list_line_id = :p_benefit_line_id;
• Find modifiers where a product attribute is used as a get qualifier: SELECT list_line_id, product_attribute, product_attr_value FROM qp_pricing_attr_get_v WHERE product_attribute = :p_attr;
• Audit benefit limits and proration by line: SELECT list_line_no, arithmetic_operator, operand, benefit_limit, proration_type_code FROM qp_pricing_attr_get_v WHERE list_header_id = :p_header_id ORDER BY list_line_no;

Because the view joins QP_LIST_LINES, QP_PRICING_ATTRIBUTES, and QP_RLTD_MODIFIERS, it is best used for read-only reporting. Any correction to modifier logic should be performed through the Advanced Pricing Modifiers Form or the corresponding base tables under controlled DML, not through the view itself.