Search Results pattern_value_from_positive




Overview
Explore in AI Chat

Overview

QP_PRICING_ATTRIBUTES is a core table within the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the product qualification and pricing attribute definitions that determine whether a modifier, price list line, or promotion applies to a given item or transaction. Each row represents a single attribute condition associated with a price list line, capturing the item context, the attribute being qualified, the value or range of values, and the comparison logic used during pricing engine evaluation.

From a Data Vault modeling perspective, the ETRM relationship metadata classifies this table as satellite-leaning. This classification is a heuristic suggestion derived from the foreign key structure: QP_PRICING_ATTRIBUTES primarily references parent entities (QP_LIST_LINES) and carries descriptive, context-dependent attributes rather than acting as a pure junction or hub. As a satellite, it records the qualifying conditions and their history relative to the parent list line, with the primary key PRICING_ATTRIBUTE_ID providing the unique row identifier.

Key Information Stored

The table contains 57 documented columns in the 12.2.2 schema, owned by the QP schema. The most operationally significant columns include:

Common Use Cases and Queries

Typical reporting and diagnostic scenarios involve retrieving all pricing attributes for a given price list line to validate qualification logic, or reconstructing the full pricing context for troubleshooting modifier application.

  • Identify all attributes for a specific list line:
    SELECT PRICING_ATTRIBUTE_ID, PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE, PRICING_ATTR_VALUE_FROM, PRICING_ATTR_VALUE_TO, COMPARISON_OPERATOR_CODE FROM QP.QP_PRICING_ATTRIBUTES WHERE LIST_LINE_ID = :list_line_id;
  • Show attributes grouped for compound qualification:
    SELECT ATTRIBUTE_GROUPING_NO, PRICING_ATTRIBUTE, PRICING_ATTR_VALUE_FROM FROM QP.QP_PRICING_ATTRIBUTES WHERE LIST_LINE_ID = :list_line_id ORDER BY ATTRIBUTE_GROUPING_NO;
  • Join to QP_LIST_LINES to reconcile attributes with header and version information for audit reports.
  • Extract originating-system references for integration reconciliation using ORIG_SYS_PRICING_ATTR_REF.

Related Objects

  • QP_LIST_LINES — Referenced by QP_PRICING_ATTRIBUTES.LIST_LINE_ID. The immediate parent holding price list line definitions.
  • QP_PRICING_PHASES — Referenced by QP_PRICING_ATTRIBUTES.PRICING_PHASE_ID. Defines the ordering of pricing phases.
  • QP_LIST_HEADERS — Accessed indirectly through QP_LIST_LINES via LIST_HEADER_ID, providing the price list or modifier header.
  • QP_LIST_LINES_TL — Translation table for list line descriptions, joined through LIST_LINE_ID.
  • QP_PRICING_ATTRIBUTES_PK — The primary key index enforcing uniqueness on PRICING_ATTRIBUTE_ID.
  • QP_PREQ_QUALIFIERS and pricing qualification APIs — Consumed by the pricing engine to evaluate qualifiers at run time.
  • QP_PRICE_LIST_LINES and modifier setup views — Query against this table to present attribute conditions in Setup and Pricing Administrator responsibilities.

Direct DML against QP_PRICING_ATTRIBUTES is not supported; modifications should be performed through the Advanced Pricing setup forms or the supported pricing APIs to preserve referential integrity with QP_LIST_LINES and QP_PRICING_PHASES.