Results for “qpfv_modifier_lines”

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

Overview

QPFV_MODIFIER_LINES is a reporting view owned by the APPS schema within the Oracle Advanced Pricing (QP) module. In Oracle EBS 12.1.1 and 12.2.2, it presents a consolidated, denormalized projection of modifier "summary" lines held in the pricing engine. Specifically, the view exposes header-level information for Discounts, Surcharges, Freight and Special Charges, Price Break Headers, Other Item Discounts, and Promotional Goods. For Price Break modifiers only the header line is returned, and for promotional (buy/get) modifiers only the qualifying "Buy" line is returned.

The view exists to simplify reporting and integration against the QP_LIST_LINES table, replacing opaque coded values with their lookup meanings and joining unit-of-measure codes so that external reports, extracts, and interfaces can consume modifier definitions without replicating the pricing engine's validation logic. It is registered as a VALID object in ETRM, indicating it is a supported artifact for inquiry purposes rather than a transactional entry point.

Underlying Base Objects

The documented base objects for QPFV_MODIFIER_LINES are QP_LIST_LINES (SYNONYM), MTL_UNITS_OF_MEASURE (SYNONYM), QP_QP_FORM_PRICING_ATTR (PACKAGE, referenced indirectly through form attributes), and QP_RLTD_MODIFIERS (SYNONYM). The core driving table is QP_LIST_LINES, aliased LL, which stores every modifier line including price breaks and promotional buy lines. MTL_UNITS_OF_MEASURE is joined twice — once as MTL1 for the benefit unit of measure and once as MTL2 for the expiration period unit of measure. QP_RLTD_MODIFIERS supports the relationships between related modifier lines, and QP_QP_FORM_PRICING_ATTR provides the form-level attribute context used by the pricing UI.

The view filters QP_LIST_LINES to LIST_LINE_TYPE_CODE values of 'DIS' (Discount), 'SUR' (Surcharge), 'FREIGHT_CHARGE', 'PBH' (Price Break Header), 'OID' (Other Item Discount), and 'PRG' (Promotional Goods). Child price-break lines and the "Get" side of promotional modifiers are excluded by the view's NOT EXISTS predicate, which is why only header and buy lines appear. Lookup meanings are injected directly by the view text using the '_LA:' convention (e.g., LIST_LINE_TYPE_CODE mapped against QP_LOOKUPS), meaning the returned columns already contain display values rather than raw codes.

Key Columns

Identity and versioning columns include LIST_HEADER_ID, LIST_LINE_ID, LIST_LINE_NO, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY. Pricing behavior is governed by OPERAND, ARITHMETIC_OPERATOR, and its decoded meaning; PRICING_PHASE_ID; PRODUCT_PRECEDENCE; PRICING_GROUP_SEQUENCE and its lookup meaning; OVERRIDE_FLAG; and PRICE_BY_FORMULA_ID. Application terms are captured by MODIFIER_LEVEL_CODE, PRICE_BREAK_TYPE_CODE, LIST_LINE_TYPE_CODE, CHARGE_TYPE_CODE, CHARGE_SUBTYPE_CODE, REBATE_TRANSACTION_TYPE_CODE, and INCOMPATIBILITY_GRP_CODE — each paired with a corresponding lookup MEANING column.

Accrual and benefit data appear as ACCRUAL_FLAG, ESTIM_ACCRUAL_RATE, ACCRUAL_CONVERSION_RATE, BENEFIT_QTY, and BENEFIT_UOM_CODE (with MTL1.UNIT_OF_MEASURE as the decoded UOM). Currency and date control is provided by START_DATE_ACTIVE, END_DATE_ACTIVE, EXPIRATION_PERIOD_START_DATE, NUMBER_EXPIRATION_PERIODS, EXPIRATION_PERIOD_UOM (decoded through MTL2.UNIT_OF_MEASURE), and EXPIRATION_DATE. The '_DF:QP:QP_LIST_LINES:LL' descriptor identifies the view as a flexfield-enabled display for the QP_LIST_LINES entity.

Common Use Cases and Queries

Typical uses include auditing modifier setup, extracting promotional and price-break headers for downstream systems, and validating effective dating of discounts and surcharges. A basic inventory of promotion and price-break modifiers can be produced as follows:

• SELECT list_header_id, list_line_id, list_line_type_code, operand, arithmetic_operator, start_date_active, end_date_active FROM qpfv_modifier_lines WHERE list_line_type_code IN ('PBH','PRG');
• SELECT list_header_id, modifier_level_code, pricing_group_sequence, benefit_qty, benefit_uom_code FROM qpfv_modifier_lines WHERE accrual_flag = 'Y' ORDER BY list_header_id;
• SELECT list_header_id, charge_type_code, charge_subtype_code FROM qpfv_modifier_lines WHERE list_line_type_code = 'FREIGHT_CHARGE';

Because the view joins MTL_UNITS_OF_MEASURE and embeds QP_LOOKUPS translations, reports run against it return presentable values without additional joins, making it suitable for concurrent-program extracts and BI Publisher reports over pricing modifiers.