Search Results product_attr_value




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: 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: 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_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.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_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.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: 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: 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: QPFV_PRODUCTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRODUCTS,  object_name:QPFV_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.QPFV_PRODUCTS , 

  • View: QPFV_PRODUCTS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRODUCTS,  object_name:QPFV_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.QPFV_PRODUCTS , 

  • View: QPBV_ADDITIONAL_BUY_PRODUCTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_ADDITIONAL_BUY_PRODUCTS,  object_name:QPBV_ADDITIONAL_BUY_PRODUCTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner. ,  implementation_dba_data: APPS.QPBV_ADDITIONAL_BUY_PRODUCTS , 

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

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_ADDITIONAL_BUY_PRODUCTS,  object_name:QPBV_ADDITIONAL_BUY_PRODUCTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner. ,  implementation_dba_data: APPS.QPBV_ADDITIONAL_BUY_PRODUCTS , 

  • View: QPBV_PRODUCT_BENEFITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRODUCT_BENEFITS,  object_name:QPBV_PRODUCT_BENEFITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods. ,  implementation_dba_data: APPS.QPBV_PRODUCT_BENEFITS , 

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

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRODUCT_BENEFITS,  object_name:QPBV_PRODUCT_BENEFITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods. ,  implementation_dba_data: APPS.QPBV_PRODUCT_BENEFITS , 

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

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_ADDITIONAL_BUY_PRODUCTS,  object_name:QPFV_ADDITIONAL_BUY_PRODUCTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner. ,  implementation_dba_data: APPS.QPFV_ADDITIONAL_BUY_PRODUCTS , 

  • View: QPFV_ADDITIONAL_BUY_PRODUCTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_ADDITIONAL_BUY_PRODUCTS,  object_name:QPFV_ADDITIONAL_BUY_PRODUCTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner. ,  implementation_dba_data: APPS.QPFV_ADDITIONAL_BUY_PRODUCTS , 

  • View: QPFV_PRODUCT_BENEFITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRODUCT_BENEFITS,  object_name:QPFV_PRODUCT_BENEFITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods. ,  implementation_dba_data: APPS.QPFV_PRODUCT_BENEFITS , 

  • View: QPFV_PRODUCT_BENEFITS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRODUCT_BENEFITS,  object_name:QPFV_PRODUCT_BENEFITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods. ,  implementation_dba_data: APPS.QPFV_PRODUCT_BENEFITS , 

  • View: QP_PRICE_FACTORS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_V , 

  • View: QP_PRICE_FACTORS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_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_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_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_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_LIST_LINES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_LINES_V,  object_name:QP_LIST_LINES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Price List Lines information - used for List Lines block in Price Lists form. ,  implementation_dba_data: APPS.QP_LIST_LINES_V , 

  • View: QP_LIST_LINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_LINES_V,  object_name:QP_LIST_LINES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Price List Lines information - used for List Lines block in Price Lists form. ,  implementation_dba_data: APPS.QP_LIST_LINES_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 ,