Search Results src_system_code




Overview
Explore in AI Chat

Overview

APPS.QP_HDR_QUALIF_ATTRIBS_V is an Oracle E-Business Suite Advanced Pricing (QP) view that exposes the header-level qualifier attribute definitions used in price list and modifier setup. The view originates from the Oracle Trading Community / ETRM (Enterprise Territory and Resource Management) documentation set and is cataloged for Oracle EBS releases 12.1.1 and 12.2.2 under the APPS schema. Its principal function is to present, in a single denormalized projection, the set of generic qualifier attribute columns (qualifier_attribute1 through qualifier_attribute100) that may be referenced during pricing qualification, along with the qualifier context that governs their meaning.

The view is most frequently encountered when a user searches for the column token "qualifier_attribute100". Because Oracle pricing qualification supports an extensible, DFF-style attribute model, each qualifier context can expose up to 100 numbered attribute columns, and QP_HDR_QUALIF_ATTRIBS_V is the object that surfaces the full range (including the high-numbered attributes such as qualifier_attribute100) for header-level qualification.

In EBS reporting and integration, the view serves as a stable read-only interface for retrieving pricing qualifier metadata without querying the underlying QP_ATTRIBUTE_DEFNS definition structure directly.

Underlying Base Objects

The ETRM metadata for APPS.QP_HDR_QUALIF_ATTRIBS_V documents a single referenced base object:

  • QP_ATTRIBUTE_DEFNS (referenced through a SYNONYM) — the attribute definition repository in Advanced Pricing that stores the definitions of qualifier and pricing attributes across the various qualifier contexts.

The view is therefore a projection over the attribute-definition layer rather than over transactional pricing data. It does not store qualification results; instead it exposes the shape and available slots of the qualifier attribute namespace. The view text is a preformatted SELECT unioning or projecting a literal such as src_system_code together with qualifier_context and the enumerated qualifier_attribute1 … qualifier_attribute100 columns. This confirms that each row represents a qualifier context with its associated attribute slots.

Key Columns

  • src_system_code — a literal or source-system identifier projected by the view text, used to tag the origin of the qualifier attribute set (for example, for cross-system or migration identification).
  • qualifier_context — the pricing qualifier context that scopes the attribute columns, determining which attributes are valid and how they map to business meaning.
  • qualifier_attribute1 … qualifier_attribute100 — the numbered generic qualifier attribute columns. Any given context typically populates only a subset; the remaining slots are null. qualifier_attribute100 represents the highest-numbered slot exposed and is the column of interest for users searching that token.

Common Use Cases and Queries

Typical scenarios include auditing which qualifier contexts expose a specific high-numbered attribute, building integration extracts that map qualifier attributes to external systems, and diagnosing why a pricing qualifier is or is not available in a given context.

Sample query to find contexts exposing qualifier_attribute100:

  • SELECT qualifier_context, qualifier_attribute100 FROM apps.qp_hdr_qualif_attribs_v WHERE qualifier_attribute100 IS NOT NULL;

Sample query to retrieve all populated qualifier attributes for a context:

  • SELECT src_system_code, qualifier_context, qualifier_attribute1, qualifier_attribute2, qualifier_attribute3 FROM apps.qp_hdr_qualif_attribs_v WHERE qualifier_context = :ctx;

Because the view is defined over QP_ATTRIBUTE_DEFNS, results reflect attribute definitions rather than live pricing data, making it suitable for metadata validation, migration verification, and reporting on the qualifier attribute model across Oracle EBS 12.1.1 and 12.2.2.