Results for “qualifier_attribute30”

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

Overview

QP_HDR_QUALIF_ATTRIBS_V is a public APPS view in the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It is defined over the attribute definition repository QP_ATTRIBUTE_DEFNS and exists to support the definition of sourcing rules for header-level qualifier attributes for a given source system. In the Pricing and Trade Management architecture, qualifiers are the attribute values that determine whether a modifier, price list, or sourcing rule applies to a transaction line. This view flattens the descriptor metadata for those qualifiers into a single, wide row containing a fixed source-system token plus an ordered sequence of sixty or more qualifier attribute columns, so that sourcing-rule setup screens and concurrent processes can reference header qualifiers without repeatedly joining the underlying definition table.

Underlying Base Objects

The view is documented as being based on QP_ATTRIBUTE_DEFNS, accessed within the APPS schema through a synonym. QP_ATTRIBUTE_DEFNS is the dictionary table that stores attribute definitions used throughout Advanced Pricing, including the attribute name, its application context, and the source system under which the attribute is meaningful. Rather than repeating definition rows per use, QP_HDR_QUALIF_ATTRIBS_V projects those definitions into a horizontal layout, emitting a literal SRC_SYSTEM_CODE value of 'SRC_SYSTEM_CODE' together with the qualifier context and the numbered qualifier attribute columns. Because the view is read-only by design, no DML should be performed against it; changes to qualifiers must be made through the supported Pricing setup user interfaces or against the base definition table by authorized processes.

Key Columns

• SRC_SYSTEM_CODE — A constant literal, 'SRC_SYSTEM_CODE', identifying the classification of the row as header-level qualifier metadata for source-system selection.
• QUALIFIER_CONTEXT — The attribute context (for example, the pricing or ordering entity) under which the qualifier attributes are grouped.
• QUALIFIER_ATTRIBUTE1 through QUALIFIER_ATTRIBUTEn — An ordered set of qualifier attribute slots. The user search term qualifier_attribute2 corresponds to one of these numbered slots; the second qualifier attribute in the sequence. Each slot holds a qualifier value that a sourcing rule compares against transaction data.

Common Use Cases and Queries

The view is typically consulted when building or troubleshooting sourcing-rule definitions, when validating which qualifier attributes are exposed for a source system, or when extracting qualifier metadata for integration. A representative query returns the context and the second qualifier slot for all header-level definitions:

SELECT qualifier_context, qualifier_attribute2
FROM apps.qp_hdr_qualif_attribs_v
WHERE src_system_code = 'SRC_SYSTEM_CODE';

Administrators also use the view to confirm that a given attribute has been registered in QP_ATTRIBUTE_DEFNS before it can appear as a selectable qualifier in a sourcing rule. Because the output is denormalised and wide, it is best consumed through filtered queries rather than full-table reporting.