Search Results benefit_uom_name

Overview

APPS.QPFV_PRODUCT_BENEFITS is a reporting and integration view within the Oracle E-Business Suite Advanced Pricing module (QP). It exposes the relationship between product pricing attributes and the benefit modifiers attached to price list lines, resolving both the qualifying attribute context and the associated unit of measure descriptions. The view is defined WITH READ ONLY, which prevents DML and signals that it is intended strictly for query, reporting, and downstream integration consumption rather than transactional maintenance.

The view is particularly relevant when users need to determine the benefit unit of measure (the BENEFIT_UOM_CODE) associated with a benefit modifier, together with its arithmetic operator and quantity. This makes it a common source for pricing analysis, promotional benefit reporting, and interface extraction where benefit relationships must be expressed alongside their product attribute context.

Underlying Base Objects

The view is owned by APPS and is constructed from the following documented base objects:

QP_RLTD_MODIFIERS (synonym) — drives the benefit relationship; the view filters on RLTD_MODIFIER_GRP_TYPE = 'BENEFIT'.
QP_LIST_LINES (synonym) — joined twice as LL1 (benefit line) and LL2 (the price list line referenced by BENEFIT_PRICE_LIST_LINE_ID).
QP_PRICING_ATTRIBUTES (synonym) — supplies the product attribute context, attribute value, and product UOM.
MTL_UNITS_OF_MEASURE (synonym) — joined as MTL1 and MTL2 for benefit and product UOM descriptions, both outer-joined.
QP_QP_FORM_PRICING_ATTR (package) — Get_Attribute resolves the pricing attribute definition.
QP_PRICE_LIST_LINE_UTIL (package) — get_product_value resolves the product value for the attribute context.

The join path anchors on RLTD_MODIFIERS.TO_RLTD_MODIFIER_ID equaling the LIST_LINE_ID of both the pricing attribute row and LL1, and only rows where EXCLUDER_FLAG = 'N' are returned.

Key Columns

LIST_LINE_ID, LIST_HEADER_ID — identify the pricing attribute line and its parent list.
PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTR_VALUE — the pricing attribute context and value qualifying the benefit.
BENEFIT_UOM_CODE — the unit of measure on the benefit line; central to the user's search.
UNIT_OF_MEASURE (from MTL1, MTL2) — descriptive UOM names for benefit and product respectively.
BENEFIT_QTY, ARITHMETIC_OPERATOR, and its lookup meaning — define how the benefit is calculated.
PRODUCT_UOM_CODE, PRICING_ATTRIBUTE_ID — product UOM and attribute identifier.
Audit and reference columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF.

Common Use Cases and Queries

Typical uses include reporting benefit modifiers by product attribute, validating benefit UOM setup, and extracting data for integration. A sample query:

SELECT list_line_id, product_attribute_context, product_attr_value, benefit_uom_code, unit_of_measure, benefit_qty, arithmetic_operator FROM apps.qpfv_product_benefits WHERE benefit_uom_code = 'EA';

Analysts may also filter by list_header_id to isolate benefits for a specific price list, or join to QP_LIST_HEADERS_TL for list names.

VIEW: APPS.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,
VIEW: APPS.QPFV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID,
VIEW: APPS.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,
VIEW: APPS.QPFV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID,
View: QPFV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPFV_MODIFIER_LINES ,
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: QPFV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPFV_MODIFIER_LINES ,
eTRM - QP Tables and Views 12.2.2
description: This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade. ,
eTRM - QP Tables and Views 12.1.1
description: This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade. ,