Search Results qp_qualifiers




Overview
Explore in AI Chat

Overview

The QP_QUALIFIERS table is a core data structure within the Oracle E-Business Suite Advanced Pricing (QP) module. It functions as the central repository for storing detailed qualifier attribute information. In the context of the pricing engine, a qualifier defines the specific conditions under which a price, modifier, or promotion is applicable. This table holds the discrete attribute values that constitute these conditions, linking them to specific pricing entities such as price lists or individual list lines. Its role is critical for enabling complex, attribute-based pricing rules that are fundamental to the Advanced Pricing module's functionality in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to store the linkage between a pricing rule and the specific attribute values that qualify its application. The key columns, as indicated by the metadata, include the primary key QUALIFIER_ID, which uniquely identifies each qualifier record. The table maintains relationships to major pricing objects via foreign keys: LIST_HEADER_ID links to QP_LIST_HEADERS_B for header-level qualifiers, LIST_LINE_ID links to QP_LIST_LINES for line-level qualifiers, and CREATED_FROM_RULE_ID links to QP_QUALIFIER_RULES, indicating the rule template from which the qualifier was instantiated. Other typical columns (implied by its function) would store the qualifier context (e.g., Customer, Product), attribute code, operator (e.g., =, BETWEEN), and the attribute value(s).

Common Use Cases and Queries

This table is primarily accessed for troubleshooting pricing engine behavior, auditing pricing rules, and generating custom price qualification reports. A common query involves identifying all qualifiers attached to a specific price list to understand its applicability. For example:

  • SELECT qualifier_id, list_header_id, attribute, operand FROM qp_qualifiers WHERE list_header_id = <price_list_id>;

Another frequent use case is analyzing the lineage of a qualifier by joining to QP_QUALIFIER_RULES via CREATED_FROM_RULE_ID. Reporting on customer-specific or product-specific pricing conditions also requires querying this table to extract the stored attribute values that define those conditions.

Related Objects

As defined by its foreign keys, QP_QUALIFIERS has direct, integral relationships with several core pricing tables. It is a child table of QP_LIST_HEADERS_B (for price lists) and QP_LIST_LINES (for price list lines and modifiers). It is also derived from QP_QUALIFIER_RULES, which stores the reusable qualifier rule templates. The table is heavily referenced by the pricing engine's internal logic during price list and modifier validation, as well as during the price request processing to evaluate which pricing rules qualify for a given transaction.

  • Table: QP_QUALIFIERS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS,  object_name:QP_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_QUALIFIERS , 

  • Table: QP_QUALIFIERS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS,  object_name:QP_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_QUALIFIERS , 

  • Table: QP_INTERFACE_QUALIFIERS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_INTERFACE_QUALIFIERS,  object_name:QP_INTERFACE_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_INTERFACE_QUALIFIERS , 

  • Table: QP_INTERFACE_QUALIFIERS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_INTERFACE_QUALIFIERS,  object_name:QP_INTERFACE_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_INTERFACE_QUALIFIERS , 

  • Table: QP_QUALIFIER_RULES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIER_RULES,  object_name:QP_QUALIFIER_RULES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIER_RULES stores the header information for all qualifier rules ,  implementation_dba_data: QP.QP_QUALIFIER_RULES , 

  • 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 , 

  • 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 , 

  • Table: QP_QUALIFIER_RULES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIER_RULES,  object_name:QP_QUALIFIER_RULES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIER_RULES stores the header information for all qualifier rules ,  implementation_dba_data: QP.QP_QUALIFIER_RULES , 

  • Table: QP_QUALIFIERS_EBS_LOG 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS_EBS_LOG,  object_name:QP_QUALIFIERS_EBS_LOG,  status:VALID,  product: QP - Advanced Pricing ,  description: Log table for the Euro conversion of QP_QUALIFIERS table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. ,  implementation_dba_data: QP.QP_QUALIFIERS_EBS_LOG , 

  • Table: QP_QUALIFIERS_EBS_LOG 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS_EBS_LOG,  object_name:QP_QUALIFIERS_EBS_LOG,  status:VALID,  product: QP - Advanced Pricing ,  description: Log table for the Euro conversion of QP_QUALIFIERS table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. ,  implementation_dba_data: QP.QP_QUALIFIERS_EBS_LOG , 

  • 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_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: 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: QPBV_SECONDARY_PRICE_LISTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_SECONDARY_PRICE_LISTS,  object_name:QPBV_SECONDARY_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Primary Price list and its Secondary Price list. ,  implementation_dba_data: APPS.QPBV_SECONDARY_PRICE_LISTS , 

  • 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: 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: QPBV_SECONDARY_PRICE_LISTS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_SECONDARY_PRICE_LISTS,  object_name:QPBV_SECONDARY_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Primary Price list and its Secondary Price list. ,  implementation_dba_data: APPS.QPBV_SECONDARY_PRICE_LISTS , 

  • 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_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_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 , 

  • Table: QP_LIST_LINES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • Table: QP_LIST_LINES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • 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: OE_DISCOUNT_CUSTOMERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNT_CUSTOMERS_V,  object_name:OE_DISCOUNT_CUSTOMERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNT_CUSTOMERS_V , 

  • View: OE_DISCOUNT_CUSTOMERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNT_CUSTOMERS_V,  object_name:OE_DISCOUNT_CUSTOMERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNT_CUSTOMERS_V , 

  • Table: QP_LIST_HEADERS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_HEADERS_B,  object_name:QP_LIST_HEADERS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. ,  implementation_dba_data: QP.QP_LIST_HEADERS_B , 

  • View: OE_DISCOUNTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNTS_V,  object_name:OE_DISCOUNTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNTS_V , 

  • Table: QP_LIST_HEADERS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_HEADERS_B,  object_name:QP_LIST_HEADERS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. ,  implementation_dba_data: QP.QP_LIST_HEADERS_B , 

  • View: OE_DISCOUNTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNTS_V,  object_name:OE_DISCOUNTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNTS_V ,