Search Results qp_modifier_summary_v




Overview
Explore in AI Chat

Overview

QP_MODIFIER_SUMMARY_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, within the Advanced Pricing (QP) product family. It is documented as VALID in both release 12.1.1 and 12.2.2. The view presents modifier summary information for modifier lists and serves as the data source for the summary block of the Modifiers form. Because it consolidates pricing attribute resolution, list line attributes, and price list line utility logic into a single queryable structure, it is also widely used in custom reporting and integration work where a flattened, denormalized representation of modifier configuration is required without navigating the Modifiers setup form directly.

Underlying Base Objects

The view is defined over two base objects documented in the ETRM metadata: the QP_LIST_LINES synonym and the QP_PRICING_ATTRIBUTES synonym. The view text confirms the primary source is QP_LIST_LINES (aliased QL), which stores every modifier and price list line in Advanced Pricing. A hint, USE_NL(QL, QPA) with INDEX(QL QP_LIST_LINES_N5), forces a nested-loop join and drives the query through the QP_LIST_LINES_N5 index.

The metadata also lists two package dependencies: QP_PRICE_LIST_LINE_UTIL and QP_QP_FORM_PRICING_ATTR. The former exposes utility functions that resolve pricing attributes and derived line values; the latter supplies form-level pricing attribute logic used by the Modifiers form. These packages are invoked rather than joined as tables, so the view's effective row source is the QP_LIST_LINES record with computed columns layered on top.

Key Columns

Common Use Cases and Queries

Typical usage includes auditing modifier qualification, extracting active discounts for a date range, and feeding downstream pricing analysis. A representative query returns all active lines for a given modifier list:

  • SELECT list_line_id, list_line_type_code, modifier_level_code, list_price, operand, arithmetic_operator, start_date_active, end_date_active FROM qp_modifier_summary_v WHERE list_header_id = :p_header AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE)+1);
  • SELECT list_line_no, inventory_item_id, substitution_context, substitution_attribute, substitution_value, list_price FROM qp_modifier_summary_v WHERE modifier_level_code = 'LINE' AND price_break_type_code = 'POINT';

Because the view applies nested-loop access through QP_LIST_LINES_N5, predicates on LIST_HEADER_ID perform well, whereas unqualified full scans of very large modifier lists should be avoided. All access is read-only, so the view is unsafe for DML; corresponding DML must target QP_LIST_LINES through the supported Advanced Pricing APIs.