Search Results qp_attr_defns_qualifier




Overview
Explore in AI Chat

Overview

APPS.QPFV_QUALIFIERS is a reporting and integration view in the Oracle E-Business Suite Advanced Pricing module (Oracle Pricing / QP). It exposes qualifier definitions stored in the QP_QUALIFIERS table in a form suitable for presentation and downstream consumption. A qualifier is a condition that restricts when a price list line, modifier, or promotion applies — for example an ordered item, a customer segment, or a date range. The view is defined as a read-only projection (WITH READ ONLY) over QP_QUALIFIERS, filtered to those rows that belong to a price list header (WHERE LIST_HEADER_ID IS NOT NULL), and it decorates the raw stored values with framed, user-facing descriptions.

Unlike the physical table, which stores qualifier attributes in a denormalized, context-driven fashion, the view resolves each qualifier attribute to its descriptive name and value by invoking the helper package QP_QP_FORM_PRICING_ATTR. This makes QPFV_QUALIFIERS well suited to ad hoc reporting, BI Publisher data sets, and integration extracts where a human-readable representation of qualifier logic is required. The view exists in both EBS 12.1.1 and 12.2.2; the documented metadata reflects the 12.2.2 ETRM repository.

Underlying Base Objects

The view is defined over a single base object, accessed through the synonym QP_QUALIFIERS, which in turn points to the Advanced Pricing qualifier table. Two auxiliary objects participate in the projection:

Because the view is filtered on LIST_HEADER_ID IS NOT NULL, it returns only qualifiers associated with price list headers, excluding orphaned or intermediate records that may exist in the base table during rule processing. The read-only clause prevents DML through the view; changes must be made to the underlying qualifier tables.

Key Columns

The columns exposed by QPFV_QUALIFIERS fall into identity, descriptive, and audit categories:

Common Use Cases and Queries

Typical scenarios include auditing qualifier logic on a price list, verifying effective dates, and extracting qualifier rules for integration or migration. The following query lists active qualifiers for a given price list:

SELECT list_header_id, list_line_id, qualifier_context, comparison_operator_code, start_date_active, end_date_active FROM apps.qpfv_qualifiers WHERE list_header_id = :p_list_header_id AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);

Because several projected columns are function results, callers cannot filter or order directly on the resolved attribute names without wrapping the view. A common pattern is to define an inline view and then restrict on the aliased expression.

Note that Oracle ETRM documentation identifies the search term "qp_attr_defns_qualifier" as the attribute definition used by the Get_Attribute calls; it is referenced by the view but is not itself the base object.