Search Results excluder_flag




Overview
Explore in AI Chat

Overview

QPBV_PRODUCT_EXCLUSIONS is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Advanced Pricing (QP) module. Its purpose is narrow and clearly defined: it exposes the set of product-level exclusion records associated with pricing modifiers. In Oracle Advanced Pricing, a modifier (such as a discount, surcharge, or promotion) can be restricted so that it does not apply to particular products. Those restrictions are stored as pricing attribute lines flagged as exclusions, and QPBV_PRODUCT_EXCLUSIONS presents exactly that subset. Rather than requiring report authors and integrators to know the internal flag semantics of the underlying attribute table, the view encapsulates the filter and returns only qualifying rows. In ETRM 12.2.2 the view is documented as VALID, and its structure is identical in the 12.1.1 code line, making it safe to reference from custom concurrent programs, OBIEE/BI Publisher reports, and inbound/outbound interface logic across both releases.

Underlying Base Objects

The view is defined over a single base object, QP_PRICING_ATTRIBUTES, referenced through a synonym. The view text is a straightforward projection with a mandatory predicate:

QP_PRICING_ATTRIBUTES holds the attribute qualifiers that drive pricing engine evaluation for a modifier line. Each row can represent either an inclusion (a positive qualifier that must be matched) or an exclusion (a qualifier that disqualifies the modifier). The EXCLUDER_FLAG column is the discriminator: a value of 'Y' marks the row as an exclusion. Because the view enforces this predicate, consumers cannot accidentally retrieve inclusion rows through it. No joins, unions, or aggregation are applied, so performance is essentially equivalent to a filtered scan of the base table.

Key Columns

  • LIST_LINE_ID – Identifier of the modifier line to which the exclusion belongs; the primary join key back to the modifier/line setup.
  • EXCLUDER_FLAG – Always 'Y' in this view; indicates the row is an exclusion rather than an inclusion qualifier.
  • PRODUCT_ATTRIBUTE_CONTEXT – The context (attribute group) that frames the product attribute, e.g. the item or product hierarchy context.
  • PRODUCT_ATTRIBUTE – The specific product attribute being qualified (for example, item, item category, or a user-defined attribute).
  • PRODUCT_ATTR_VALUE – The value the attribute must equal for the exclusion to fire.
  • LIST_HEADER_ID – Identifier of the pricing list/modifier header that owns the line.
  • PRICING_ATTRIBUTE_ID – Surrogate primary key of the underlying attribute row.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY – Standard EBS audit columns, useful for change tracking and data lineage reporting.

Common Use Cases and Queries

The view is most often used to audit or report which products a modifier excludes, and to diagnose unexpected pricing outcomes where a discount fails to apply. A representative query lists exclusions for a given modifier line:

  • SELECT ex.list_line_id, ex.product_attribute_context, ex.product_attribute, ex.product_attr_value FROM qpbv_product_exclusions ex WHERE ex.list_line_id = :p_list_line_id;
  • SELECT ex.list_header_id, COUNT(*) exclusions FROM qpbv_product_exclusions ex GROUP BY ex.list_header_id ORDER BY exclusions DESC;
  • SELECT ex.list_line_id, ex.product_attr_value, ex.last_update_date, ex.last_updated_by FROM qpbv_product_exclusions ex WHERE ex.last_update_date >= :p_since_date;

Because the EXCLUDER_FLAG predicate is embedded, callers searching on the term "excluder_flag" should note that the column is exposed for completeness but is invariant at 'Y' throughout the view. Where mixed inclusion and exclusion analysis is required, query QP_PRICING_ATTRIBUTES directly and filter on EXCLUDER_FLAG in ('Y','N'). For exclusion-only reporting, integration extracts, and reconciliation checks, QPBV_PRODUCT_EXCLUSIONS remains the correct, supported access path.

  • View: QPBV_PRODUCT_EXCLUSIONS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRODUCT_EXCLUSIONS,  object_name:QPBV_PRODUCT_EXCLUSIONS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about products excluded from a Modifier. ,  implementation_dba_data: APPS.QPBV_PRODUCT_EXCLUSIONS , 

  • View: QPBV_PRODUCT_EXCLUSIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRODUCT_EXCLUSIONS,  object_name:QPBV_PRODUCT_EXCLUSIONS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about products excluded from a Modifier. ,  implementation_dba_data: APPS.QPBV_PRODUCT_EXCLUSIONS , 

  • View: QPFV_PRODUCT_EXCLUSIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRODUCT_EXCLUSIONS,  object_name:QPFV_PRODUCT_EXCLUSIONS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about products excluded from a Modifier. ,  implementation_dba_data: APPS.QPFV_PRODUCT_EXCLUSIONS , 

  • View: QPFV_PRODUCT_EXCLUSIONS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRODUCT_EXCLUSIONS,  object_name:QPFV_PRODUCT_EXCLUSIONS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about products excluded from a Modifier. ,  implementation_dba_data: APPS.QPFV_PRODUCT_EXCLUSIONS , 

  • View: QP_DEBUG_REQ_PROD_LINE_ATTRS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_DEBUG_REQ_PROD_LINE_ATTRS_V,  object_name:QP_DEBUG_REQ_PROD_LINE_ATTRS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View based on QP_DEBUG_REQ_LINE_ATTRS. It contains information on the Productr attributes that the attribute mapping functionality passed to the pricing engine. The pricing engine uses these attributes to qualify a line or an order for ben ,  implementation_dba_data: APPS.QP_DEBUG_REQ_PROD_LINE_ATTRS_V , 

  • View: QP_DEBUG_REQ_PROD_LINE_ATTRS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_DEBUG_REQ_PROD_LINE_ATTRS_V,  object_name:QP_DEBUG_REQ_PROD_LINE_ATTRS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View based on QP_DEBUG_REQ_LINE_ATTRS. It contains information on the Productr attributes that the attribute mapping functionality passed to the pricing engine. The pricing engine uses these attributes to qualify a line or an order for ben ,  implementation_dba_data: APPS.QP_DEBUG_REQ_PROD_LINE_ATTRS_V , 

  • View: QP_PRICING_ATTR_GET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICING_ATTR_GET_V,  object_name:QP_PRICING_ATTR_GET_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Benefit or Get Products for a Modifier. Used by Modifiers Form. ,  implementation_dba_data: APPS.QP_PRICING_ATTR_GET_V , 

  • View: QP_PRICING_ATTR_GET_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICING_ATTR_GET_V,  object_name:QP_PRICING_ATTR_GET_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Benefit or Get Products for a Modifier. Used by Modifiers Form. ,  implementation_dba_data: APPS.QP_PRICING_ATTR_GET_V , 

  • View: QP_PRICING_ATTR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICING_ATTR_V,  object_name:QP_PRICING_ATTR_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of additonal qualification items for modifiers. Used by Modifiers Form (for Additional buy products block). ,  implementation_dba_data: APPS.QP_PRICING_ATTR_V , 

  • View: QP_PRICING_ATTR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICING_ATTR_V,  object_name:QP_PRICING_ATTR_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of additonal qualification items for modifiers. Used by Modifiers Form (for Additional buy products block). ,  implementation_dba_data: APPS.QP_PRICING_ATTR_V , 

  • View: QPBV_PRODUCTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRODUCTS,  object_name:QPBV_PRODUCTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about a 'Buy' Product of a Modifier or Product of a Price list. ,  implementation_dba_data: APPS.QPBV_PRODUCTS , 

  • View: QPBV_PRODUCTS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRODUCTS,  object_name:QPBV_PRODUCTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about a 'Buy' Product of a Modifier or Product of a Price list. ,  implementation_dba_data: APPS.QPBV_PRODUCTS , 

  • View: QPBV_PRICING_ATTRIBUTES 12.1.1

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

  • View: QPBV_PRICING_ATTRIBUTES 12.2.2

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

  • View: QPFV_PRICING_ATTRIBUTES 12.2.2

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

  • View: QP_PREQ_LINE_ATTRS_TMP 12.2.2

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

  • View: QP_PREQ_LINE_ATTRS_TMP 12.1.1

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

  • View: QPFV_PRICING_ATTRIBUTES 12.1.1

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

  • 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_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_PRICE_BREAKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_BREAKS_V,  object_name:QP_PRICE_BREAKS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Price or Modifier Break lines information. Used by Price List and Modifiers form. ,  implementation_dba_data: APPS.QP_PRICE_BREAKS_V , 

  • View: QP_PRICE_BREAKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_BREAKS_V,  object_name:QP_PRICE_BREAKS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Price or Modifier Break lines information. Used by Price List and Modifiers form. ,  implementation_dba_data: APPS.QP_PRICE_BREAKS_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 , 

  • View: QP_LIST_ATTRIBUTES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_ATTRIBUTES_V,  object_name:QP_LIST_ATTRIBUTES_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_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns ,  implementation_dba_data: APPS.QP_LIST_ATTRIBUTES_V , 

  • View: QP_LIST_ATTRIBUTES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_ATTRIBUTES_V,  object_name:QP_LIST_ATTRIBUTES_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_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns ,  implementation_dba_data: APPS.QP_LIST_ATTRIBUTES_V , 

  • View: QP_LINES_SUMMARY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LINES_SUMMARY_V,  object_name:QP_LINES_SUMMARY_V,  status:VALID,  product: QP - Advanced Pricing ,  description: This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer. ,  implementation_dba_data: APPS.QP_LINES_SUMMARY_V , 

  • View: QP_LINES_SUMMARY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LINES_SUMMARY_V,  object_name:QP_LINES_SUMMARY_V,  status:VALID,  product: QP - Advanced Pricing ,  description: This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer. ,  implementation_dba_data: APPS.QP_LINES_SUMMARY_V , 

  • View: QP_MODIFIER_SUMMARY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_MODIFIER_SUMMARY_V,  object_name:QP_MODIFIER_SUMMARY_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block). ,  implementation_dba_data: APPS.QP_MODIFIER_SUMMARY_V , 

  • View: QP_MODIFIER_SUMMARY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_MODIFIER_SUMMARY_V,  object_name:QP_MODIFIER_SUMMARY_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block). ,  implementation_dba_data: APPS.QP_MODIFIER_SUMMARY_V ,