Search Results product_uom_code




Overview
Explore in AI Chat

Overview

QPBV_PRODUCTS is a read-only view owned by the APPS schema in Oracle E-Business Suite, defined within the Oracle Advanced Pricing (QP) module. Its purpose is to expose information about a "Buy" product associated with either a modifier or a price list line. In practice, the view presents the pricing attribute rows that identify the product, its attribute context, its value, and its associated unit of measure, filtered so that only non-excluded pricing attributes are returned.

Because QP pricing structures store product information as attribute/value pairs rather than as direct foreign keys to inventory items, QPBV_PRODUCTS provides a flattened, query-friendly projection over those pairs. This makes it useful for reporting, data extraction, and integration scenarios where a developer or analyst needs to resolve which product a given price list line or modifier applies to, together with the product's unit of measure. The view is documented as VALID and is referenced in ETRM metadata for both 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a single documented base object, the synonym QP_PRICING_ATTRIBUTES, which resolves to the underlying Advanced Pricing attribute table in the APPS schema. The view text selects ten columns from this source and applies two restrictive predicates:

  • EXCLUDER_FLAG = 'N' — only rows that are not flagged as excluders are returned, ensuring the view reflects active, includable pricing attributes rather than exclusion rules.
  • PRICING_ATTRIBUTE_CONTEXT IS NULL OR PRICING_ATTRIBUTE_CONTEXT = 'VOLUME' — restricts results to rows with no pricing attribute context or to those in the VOLUME context, aligning with the "Buy" product orientation of the view.

No joins, aggregations, or outer queries are present in the view definition. Consequently, QPBV_PRODUCTS inherits the row-level granularity of QP_PRICING_ATTRIBUTES and does not itself consolidate multiple attribute rows into a single product record. The PRODUCT_ATTRIBUTE_CONTEXT column is exposed from the base table but is not the same column referenced in the WHERE clause's PRICING_ATTRIBUTE_CONTEXT predicate.

Key Columns

  • PRODUCT_ATTRIBUTE_CONTEXT — the context under which the product attribute is defined; distinguishes the type or category of attribute being described.
  • PRODUCT_ATTRIBUTE — the name of the product attribute, i.e., the dimension used to identify the product (for example, an inventory item identifier or a product classification attribute).
  • PRODUCT_ATTR_VALUE — the value assigned to that attribute, representing the actual product reference on the pricing line.
  • PRODUCT_UOM_CODE — the unit of measure code associated with the product. This is the column commonly retrieved when users search for "product_uom_code" in the context of Advanced Pricing product data.
  • LIST_LINE_ID — identifier of the price list line (or modifier line) to which the product attribute belongs.
  • LIST_HEADER_ID — identifier of the parent price list header, enabling grouping of lines by list.
  • CREATION_DATE, CREATED_BY — standard audit columns recording when and by whom the row was created.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns recording the most recent change.

Common Use Cases and Queries

Typical scenarios include resolving the product and UOM behind a price list line for reporting, verifying that a modifier's buy product is correctly configured, and extracting product/UOM combinations for downstream integration. A basic query to retrieve products and their units of measure for a given price list is:

  • SELECT list_header_id, list_line_id, product_attribute, product_attr_value, product_uom_code FROM qpbv_products WHERE list_header_id = :p_list_header_id;
  • SELECT product_attr_value, product_uom_code FROM qpbv_products WHERE list_line_id = :p_list_line_id;
  • SELECT DISTINCT product_uom_code FROM qpbv_products ORDER BY product_uom_code;

Because the view applies the EXCLUDER_FLAG and context filters internally, queries against it automatically omit exclusion rows and non-qualifying attribute contexts, simplifying the SQL required by report authors and integration developers.

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