Search Results qualifier_attribute




Overview
Explore in AI Chat

Overview

QPFV_QUALIFIERS is a read-only Oracle EBS view owned by the APPS schema in the Advanced Pricing (QP) module. It presents the set of qualifiers — the conditions that must be satisfied before a modifier or price list line takes effect — in a form-oriented, display-ready layout. Rather than exposing raw internal identifiers and stored lookup codes, the view resolves descriptive attribute names, formatted attribute values, and lookup meanings, so the output is directly usable in reports, concurrent programs, and integration extracts without additional decoding.

Qualifiers drive pricing eligibility in Oracle Advanced Pricing: a qualifier specifies an attribute (for example, customer, customer class, item, or order type), a comparison operator, and one or two comparison values that determine whether the associated modifier or list line applies. QPFV_QUALIFIERS surfaces each qualifier row with its context, attribute, values, operator, grouping, and effective dates. The view is defined WITH READ ONLY and filters out records where LIST_HEADER_ID is null, so it returns only qualifiers that are genuinely attached to a price list or modifier header. It is commonly joined to pricing list-line views and modifier views to report complete pricing rule definitions.

Underlying Base Objects

The view is defined over the QP_QUALIFIERS synonym, which resolves to the base qualifier table in the QP schema, and it invokes the QP_QP_FORM_PRICING_ATTR package to translate stored attribute definitions and values. Documented referenced base objects are:

The view text selects FROM QP_QUALIFIERS and, in addition to directly projected columns, computes derived display columns for the attribute name, the low and high attribute values, the lookup meaning of the comparison operator, and an internal descriptor flag. Because the view is strictly read-only, all DML on qualifiers must target the base table through the supported pricing APIs or the pricing application forms.

Key Columns

  • LIST_HEADER_ID / LIST_LINE_ID — identify the price list or modifier header and, optionally, the specific line to which the qualifier belongs.
  • QUALIFIER_ID — the primary identifier of the qualifier record.
  • QUALIFIER_CONTEXT — the context that determines which qualifier attributes are available for the line.
  • QUALIFIER_ATTRIBUTE — the descriptive name of the qualifier attribute, derived via QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE.
  • QUALIFIER_ATTR_VALUE / QUALIFIER_ATTR_VALUE_TO — the formatted low and high comparison values produced by GET_ATTRIBUTE_VALUE, supporting between-range qualifiers.
  • COMPARISON_OPERATOR_CODE and "_LA:COMPARISON_OPERATOR_CODE" — the stored operator code and its decoded lookup meaning.
  • QUALIFIER_GROUPING_NO — the grouping that governs AND/OR logic among qualifiers in the same group.
  • QUALIFIER_PRECEDENCE — evaluation precedence when multiple qualifiers apply.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range of the qualifier.
  • CREATED_FROM_RULE_ID — the pricing rule from which the qualifier originated, where applicable.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns.
  • "_DF" — an internal descriptor flag column used by the pricing form metadata.

Common Use Cases and Queries

Typical uses include auditing pricing rules, extracting qualifier definitions for data migration, and reconciling pricing behavior in reports. For example, listing qualifiers for a given price list:

SELECT list_header_id, list_line_id, qualifier_id, qualifier_context, qualifier_attribute, qualifier_attr_value, comparison_operator_code FROM qpfv_qualifiers WHERE list_header_id = :p_list_header_id;

Filtering to active qualifiers on a reference date:

SELECT qualifier_id, qualifier_attribute, qualifier_attr_value FROM qpfv_qualifiers WHERE start_date_active <= SYSDATE AND (end_date_active IS NULL OR end_date_active >= SYSDATE);

Because the view resolves attribute names and lookup meanings automatically, it is preferable to the base QP_QUALIFIERS table for reporting. All access is read-only, and the output should be combined with the corresponding modifier and price list views to reconstruct full pricing rule logic.

  • View: QPFV_QUALIFIERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_QUALIFIERS,  object_name:QPFV_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Qualifiers attached to a Modifier or a Price List. ,  implementation_dba_data: APPS.QPFV_QUALIFIERS , 

  • View: QPFV_QUALIFIERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_QUALIFIERS,  object_name:QPFV_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Qualifiers attached to a Modifier or a Price List. ,  implementation_dba_data: APPS.QPFV_QUALIFIERS , 

  • View: QPBV_QUALIFIERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_QUALIFIERS,  object_name:QPBV_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Qualifiers attached to a Modifier or a Price List. ,  implementation_dba_data: APPS.QPBV_QUALIFIERS , 

  • View: QPBV_QUALIFIERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_QUALIFIERS,  object_name:QPBV_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Qualifiers attached to a Modifier or a Price List. ,  implementation_dba_data: APPS.QPBV_QUALIFIERS , 

  • View: QP_QUALIFIER_RULES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_QUALIFIER_RULES_V,  object_name:QP_QUALIFIER_RULES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Qualifier Rule information ,  implementation_dba_data: APPS.QP_QUALIFIER_RULES_V , 

  • View: QP_QUALIFIER_RULES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_QUALIFIER_RULES_V,  object_name:QP_QUALIFIER_RULES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Qualifier Rule information ,  implementation_dba_data: APPS.QP_QUALIFIER_RULES_V , 

  • View: QP_QUALIFIERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_QUALIFIERS_V,  object_name:QP_QUALIFIERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Qualifier information ,  implementation_dba_data: APPS.QP_QUALIFIERS_V , 

  • View: QP_QUALIFIERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_QUALIFIERS_V,  object_name:QP_QUALIFIERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Qualifier information ,  implementation_dba_data: APPS.QP_QUALIFIERS_V , 

  • View: QP_PREQ_QUAL_TMP 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PREQ_QUAL_TMP,  object_name:QP_PREQ_QUAL_TMP,  status:VALID,  product: QP - Advanced Pricing ,  description: Based on QP_PREQ_QUAL_TMP_T. This view has the information pertaining to the current pricing engine call. ,  implementation_dba_data: APPS.QP_PREQ_QUAL_TMP , 

  • View: QP_PREQ_QUAL_TMP 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PREQ_QUAL_TMP,  object_name:QP_PREQ_QUAL_TMP,  status:VALID,  product: QP - Advanced Pricing ,  description: Based on QP_PREQ_QUAL_TMP_T. This view has the information pertaining to the current pricing engine call. ,  implementation_dba_data: APPS.QP_PREQ_QUAL_TMP , 

  • View: QP_SECONDARY_PRICE_LISTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_SECONDARY_PRICE_LISTS_V,  object_name:QP_SECONDARY_PRICE_LISTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form. ,  implementation_dba_data: APPS.QP_SECONDARY_PRICE_LISTS_V , 

  • View: QP_SECONDARY_PRICE_LISTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_SECONDARY_PRICE_LISTS_V,  object_name:QP_SECONDARY_PRICE_LISTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form. ,  implementation_dba_data: APPS.QP_SECONDARY_PRICE_LISTS_V , 

  • View: QP_HDR_LVL_QUAL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_HDR_LVL_QUAL_V,  object_name:QP_HDR_LVL_QUAL_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual ,  implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V , 

  • View: QP_HDR_LVL_QUAL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_HDR_LVL_QUAL_V,  object_name:QP_HDR_LVL_QUAL_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual ,  implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V , 

  • View: QP_LINE_LVL_QUAL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LINE_LVL_QUAL_V,  object_name:QP_LINE_LVL_QUAL_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual ,  implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V , 

  • View: QP_LINE_LVL_QUAL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LINE_LVL_QUAL_V,  object_name:QP_LINE_LVL_QUAL_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual ,  implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V ,