Results for “qpfv_pricing_attributes”

16 results




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

Overview

QPFV_PRICING_ATTRIBUTES is a read-only view owned by the APPS schema in Oracle E-Business Suite Advanced Pricing (QP). It exposes the pricing attributes that are attached to either a modifier (a price adjustment) or a price list line, providing a flattened, user-readable presentation of the underlying qualification and pricing rules. Because Advanced Pricing stores attributes in a normalized form using context, attribute, and value triplets, the raw base table is not directly interpretable. This view resolves those coded values into descriptive names by invoking Advanced Pricing PL/SQL APIs, making it suitable for reporting, data extraction, and integration scenarios.

In EBS 12.1.1 and 12.2.2 the view is delivered with the Advanced Pricing product and carries a status of VALID. The definition includes the WITH READ ONLY clause, so it cannot be used for DML. Its runtime cost is higher than a plain table query because several columns are populated through function calls executed per row, which has implications for high-volume extracts.

Underlying Base Objects

The view is defined over four documented base objects in the APPS schema:

The filter conditions restrict output to rows where PRICING_ATTRIBUTE_CONTEXT IS NOT NULL and EXCLUDER_FLAG = 'N', so only inclusion-type attribute rows are returned. The literal 'QP_ATTR_DEFNS_PRICING' passed to the API calls identifies the pricing attribute definition set, which is why a search for qp_attr_defns_pricing leads to this view.

Key Columns

The view exposes approximately twenty columns. The principal ones include:

Common Use Cases and Queries

Typical uses include validating price list setup before cutover, auditing modifier qualification rules, and feeding downstream pricing extracts or BI reports. A basic inquiry by price list is shown below; note that all identifiers are numeric and the view is read-only.

  • Attributes for a price list:
    SELECT list_line_id, product_attribute_context, product_attribute,
           product_attr_value, pricing_attribute_context,
           pricing_attribute, pricing_attr_value_from, pricing_attr_value_to
    FROM   apps.qpfv_pricing_attributes
    WHERE  list_header_id = :p_list_header_id;
  • Attributes for a specific pricing attribute:
    SELECT list_line_id, pricing_phase_id,
           pricing_attr_value_from, pricing_attr_value_to
    FROM   apps.qpfv_pricing_attributes
    WHERE  pricing_attribute = :p_attr
    AND    qualification_ind = 'Y';

Because API calls execute per row, large extracts should be filtered to the narrowest possible set of price lists or phases to control response time.