Search Results benefit_uom_code




Overview
Explore in AI Chat

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:

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

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.