Results for “benefit_uom_code”

35 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QPBV_PRODUCT_BENEFITS is a view owned by the APPS schema within the Oracle Advanced Pricing (QP) module. Its documented status is VALID, and it is available in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The view exposes the "Benefit" products associated with Other Item Discounts and Promotional Goods. In Oracle Advanced Pricing, benefit products represent the goods or items granted to a customer when a qualifying modifier—such as an Other Item Discount or a Promotional Goods offer—is applied to a transaction line.

The view is primarily intended for reporting, inquiry, and integration purposes. Because it joins the related-modifier, list-line, and pricing-attribute tables into a single denormalized result set, it allows developers and analysts to retrieve the complete definition of a benefit product—including its quantity, unit of measure, arithmetic operator, and pricing attribute context—without navigating the underlying transactional model directly. This makes QPBV_PRODUCT_BENEFITS a convenient access point for data extraction, custom reports, and interfaces that need to identify precisely which benefit items are attached to a given discount or promotion.

Underlying Base Objects

The view is defined over three documented base objects, all referenced through synonyms in the APPS schema: QP_LIST_LINES, QP_PRICING_ATTRIBUTES, and QP_RLTD_MODIFIERS.

QP_RLTD_MODIFIERS is the driver of the query. The view filters this table on RLTD_MODIFIER_GRP_TYPE = 'BENEFIT', restricting the result set to benefit-type relationships. The TO_RLTD_MODIFIER_ID column joins to both QP_PRICING_ATTRIBUTES (PA.LIST_LINE_ID) and the first QP_LIST_LINES alias (LL1.LIST_LINE_ID). LL1 supplies the benefit quantity, benefit UOM, and arithmetic operator, and is linked to a second QP_LIST_LINES alias (LL2) through LL1.BENEFIT_PRICE_LIST_LINE_ID = LL2.LIST_LINE_ID. LL2 contributes the price-list-side operand and list line identifier. QP_PRICING_ATTRIBUTES supplies the product attribute context, product attribute, attribute value, product UOM code, and pricing attribute identifier, and is additionally constrained by PA.EXCLUDER_FLAG = 'N', which excludes records flagged as excluders. The three-table join therefore links a benefit modifier group to its defining list lines and its associated pricing attributes.

Key Columns

Note that the documented column list also includes LIST_PRICE and PRICE_LIST_LINE_ID, which appear in the metadata even though the published view text excerpt references LL2.OPERAND and LL2.LIST_LINE_ID.

Common Use Cases and Queries

A typical use case is retrieving the benefit quantity and UOM for all promotional goods attached to a specific modifier list line. The following query returns the benefit product definition for a given list line:

  • SELECT list_line_id, list_header_id, product_attr_value, benefit_qty, benefit_uom_code, arithmetic_operator FROM qpbv_product_benefits WHERE list_line_id = :p_list_line_id;
  • SELECT list_header_id, product_attr_value, benefit_qty, benefit_uom_code FROM qpbv_product_benefits WHERE benefit_qty > 1 ORDER BY list_header_id;
  • SELECT product_attribute_context, product_attribute, product_attr_value, benefit_qty, benefit_uom_code FROM qpbv_product_benefits WHERE product_attr_value = :p_item;

These queries support promotional analysis, validation of benefit setup during implementation, and extraction of benefit product data into custom reporting or integration layers. Because the view already resolves the benefit modifier grouping and the excluder filter, callers do not need to replicate the QP_RLTD_MODIFIERS join logic themselves.