Results for “qpbv_modifier_lines”

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

Overview

QPBV_MODIFIER_LINES is an APPS-owned read-only view in the Oracle Advanced Pricing (QP) module. It presents "summary" or header-level modifier definitions drawn from the pricing list line infrastructure. According to the ETRM metadata, the view exposes information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other Item Discount, and Promotional Goods ("Buy" line) type modifiers. Its defining characteristic is that it returns only the top-level or header line for a modifier — for example, the header of a Price Break rather than its detail break rows, and the "Buy" line of a promotional goods modifier rather than its associated "Get" lines. This makes it a convenient source for reporting, integration, and inquiry screens that need a flat, deduplicated list of modifier definitions without the noise of child pricing lines. Because the view is defined WITH READ ONLY, it is strictly a query object and cannot be used for DML.

Underlying Base Objects

The view is defined over two documented base objects: QP_LIST_LINES (a synonym) and QP_RLTD_MODIFIERS (a synonym). QP_LIST_LINES is the primary source; every column projected by the view originates from this table (aliased LL in the view text). QP_LIST_LINES stores all pricing list lines, including both header lines and detail lines for modifiers. QP_RLTD_MODIFIERS, aliased RLTD, is used solely in an anti-join predicate. The view filters QP_LIST_LINES to lines whose LIST_LINE_TYPE_CODE is one of 'DIS' (discount), 'SUR' (surcharge), 'FREIGHT_CHARGE', 'PBH' (price break header), 'OID' (other item discount), or 'PRG' (promotional goods). It then excludes any line that appears as a related modifier target, using NOT EXISTS against QP_RLTD_MODIFIERS where LIST_LINE_ID equals TO_RLTD_MODIFIER_ID. This anti-join removes "Get" lines and other child modifiers that are linked to a parent, leaving only standalone top-level modifier lines.

Key Columns

• LIST_HEADER_ID — Identifies the pricing list (modifier list) to which the line belongs; the primary grouping key for a modifier.
• LIST_LINE_ID — Unique identifier of the individual modifier line within QP_LIST_LINES.
• LIST_LINE_TYPE_CODE — Distinguishes the modifier category: DIS, SUR, FREIGHT_CHARGE, PBH, OID, or PRG.
• CHARGE_TYPE_CODE / CHARGE_SUBTYPE_CODE — Classify the charge; for freight-related modifiers these describe the freight/special charge nature, directly relevant to the "freight_charge" search term.
• PRICE_BREAK_TYPE_CODE — Indicates the price break type for PBH-header records.
• ARITHMETIC_OPERATOR, OPERAND, PRICE_BY_FORMULA_ID — Define the adjustment calculation applied by the modifier.
• MODIFIER_LEVEL_CODE — Indicates whether the modifier applies at line, group, or other level.
• START_DATE_ACTIVE / END_DATE_ACTIVE, EXPIRATION_DATE, EXPIRATION_PERIOD_* — Date and expiration controls governing modifier validity.
• PRODUCT_PRECEDENCE, PRICING_PHASE_ID, PRICING_GROUP_SEQUENCE — Determine evaluation order and precedence during pricing.
• OVERRIDE_FLAG, INCLUDE_ON_RETURNS_FLAG, INCOMPATIBILITY_GRP_CODE — Behavioral controls for overriding, returns eligibility, and incompatibility grouping.
• ACCRUAL_FLAG, ESTIM_ACCRUAL_RATE, REBATE_TRANSACTION_TYPE_CODE, ACCRUAL_CONVERSION_RATE, BENEFIT_QTY, BENEFIT_UOM_CODE — Accrual and rebate attributes associated with the modifier.

Common Use Cases and Queries

Typical uses include reporting all active modifier headers for a list, auditing freight and special charges, and enumerating discounts or promotional "Buy" lines. The following sample retrieves freight charge modifiers for a given list:

• SELECT list_header_id, list_line_id, charge_type_code, charge_subtype_code, arithmetic_operator, operand FROM qpbv_modifier_lines WHERE list_line_type_code = 'FREIGHT_CHARGE' AND list_header_id = :p_list_header_id;
• SELECT list_line_type_code, COUNT(*) FROM qpbv_modifier_lines GROUP BY list_line_type_code; — summarises modifier headers by type.
• SELECT l.list_header_id, l.list_line_id, l.list_line_type_code, l.start_date_active, l.end_date_active FROM qpbv_modifier_lines l WHERE TRUNC(SYSDATE) BETWEEN l.start_date_active AND NVL(l.end_date_active, TRUNC(SYSDATE)+1); — lists currently effective modifier headers.

Because the view already filters out child and related lines, these queries return clean header-level results suitable for integration extracts and reporting without additional anti-join logic.