Search Results comparison_operator_code




Overview
Explore in AI Chat

Overview

QPBV_QUALIFIERS is an APPS-owned database view in the Oracle Advanced Pricing (QP) module. It exposes qualifier records used by Oracle E-Business Suite pricing and modifier logic: the eligibility conditions that determine whether a price list line, modifier, or promotion applies to a given transaction. The view is defined over the QP_QUALIFIERS table and applies a filter requiring LIST_HEADER_ID to be non-null, so it returns only qualifiers tied to a price list header or modifier list header. Records not associated with a list header are excluded.

In EBS 12.1.1 and 12.2.2, QPBV_QUALIFIERS serves reporting, integration, and diagnostic purposes. Its name follows the QP "BV" (base view) naming convention and it is commonly referenced in custom concurrent programs, BI Publisher data templates, and outbound integration extracts that must reconstruct the qualifier configuration behind a modifier or price list. Because it is a view, it provides a read-only, denormalized projection of qualifier rows without requiring callers to join or filter the base table directly.

Underlying Base Objects

The view is defined solely over the base table QP_QUALIFIERS, which is exposed in the APPS schema through a SYNONYM. Its defining query selects a fixed set of columns from QP_QUALIFIERS and restricts the result set with the predicate WHERE LIST_HEADER_ID IS NOT NULL. No joins to other QP tables are present in the documented view text, so the view is a lightweight, single-table projection rather than a multi-table join. Callers requiring descriptive flexfield context names, price list names, or modifier names must join QPBV_QUALIFIERS to QP_LIST_HEADERS or QP_LIST_LINES on LIST_HEADER_ID and LIST_LINE_ID.

Key Columns

Common Use Cases and Queries

Typical uses include auditing qualifier configuration for a modifier, verifying effective-dated qualifier changes, and feeding qualifier data into external pricing engines. A common query retrieves qualifier attribute values for a specific list line:

  • SELECT qualifier_id, qualifier_attribute, qualifier_attr_value, qualifier_attr_value_to, comparison_operator_code FROM qpbv_qualifiers WHERE list_header_id = :p_header_id AND list_line_id = :p_line_id;
  • SELECT q.qualifier_id, q.qualifier_attribute, q.qualifier_attr_value, l.name FROM qpbv_qualifiers q, qp_list_headers_vl l WHERE q.list_header_id = l.list_header_id AND l.list_type_code = 'MODIFIER' AND q.qualifier_attr_value = :val;
  • SELECT * FROM qpbv_qualifiers WHERE created_from_rule_id = :rule_id ORDER BY qualifier_precedence;

Because the view filters out rows with a null LIST_HEADER_ID, queries intended to capture standalone or unattached qualifier rows must use QP_QUALIFIERS directly. For all list-attached qualifiers, QPBV_QUALIFIERS provides a documented, reliable access path in both 12.1.1 and 12.2.2.