Search Results benefit_uom_code

Overview

QPFV_PRODUCT_BENEFITS is an APPS-owned read-only view in the Oracle Advanced Pricing (QP) module. It exposes the "Benefit" product detail associated with Other Item Discount and Promotional Goods modifier setups. In Oracle EBS pricing, a modifier line can grant a benefit item — for example, a free or discounted promotional good — in addition to the primary priced item. This view flattens that relationship so that the benefit product, its quantity, its unit of measure, and the arithmetic operator driving the benefit are visible in a single queryable structure.

The view is defined WITH READ ONLY, meaning it is intended strictly for reporting and integration rather than transactional DML. Because it joins pricing list lines, pricing attributes, related modifier linkage, and units of measure, it supports reporting on promotional benefit configuration, reconciliation of benefit UOMs, and downstream data extraction into external pricing or order-capture systems. The user term benefit_uom_code maps directly to the exposed column of the same name, making this view the canonical source for resolving the benefit unit of measure on a modifier line.

Underlying Base Objects

The view is defined over the following documented base objects:

QP_RLTD_MODIFIERS (synonym) — provides the relationship between a modifier and its related benefit modifier group; filtered to RLTD_MODIFIER_GRP_TYPE = 'BENEFIT'.
QP_LIST_LINES (synonym) — supplies the benefit line (LL1) and the price list line it references (LL2), including BENEFIT_QTY, ARITHMETIC_OPERATOR, and BENEFIT_UOM_CODE.
QP_PRICING_ATTRIBUTES (synonym) — provides the product attribute context, attribute value, product UOM code, and pricing attribute identifier.
MTL_UNITS_OF_MEASURE (synonym) — joined twice via outer joins to translate BENEFIT_UOM_CODE and PRODUCT_UOM_CODE into descriptive UOM names.
QP_PRICE_LIST_LINE_UTIL (package) — used through GET_PRODUCT_VALUE to resolve the product attribute value.
QP_QP_FORM_PRICING_ATTR (package) — used through GET_ATTRIBUTE to resolve the human-readable product attribute.

The core join path links RLTD.TO_RLTD_MODIFIER_ID to both PA.LIST_LINE_ID and LL1.LIST_LINE_ID, and then LL1.BENEFIT_PRICE_LIST_LINE_ID to LL2.LIST_LINE_ID. Only records with PA.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_ATTRIBUTE / PRODUCT_ATTR_VALUE — the descriptive product attribute context and resolved value.
LIST_PRICE / PRICE_LIST_LINE_ID / OPERAND — the referenced list line and operand information.
BENEFIT_QTY — quantity of the benefit item granted.
ARITHMETIC_OPERATOR and "_LA:ARITHMETIC_OPERATOR" — the operator (with lookup meaning) that determines how the benefit is applied.
BENEFIT_UOM_CODE / BENEFIT_UOM_NAME — the unit of measure of the benefit item, keyed to the user's search term.
PRODUCT_UOM_CODE / PRODUCT_UOM_NAME — the unit of measure of the primary product.
PRICING_ATTRIBUTE_ID and audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) — technical keys and auditing.

Common Use Cases and Queries

Typical scenarios include reporting promotional benefit items per modifier, validating that benefit UOMs are consistent, and extracting benefit configuration for integration.

SELECT list_line_id,
       list_header_id,
       benefit_qty,
       benefit_uom_code,
       benefit_uom_name,
       product_uom_code,
       arithmetic_operator
FROM   apps.qpfv_product_benefits
WHERE  benefit_uom_code = :p_uom;

To inspect the arithmetic operator meaning for a given list:

SELECT list_header_id,
       list_line_id,
       "_LA:ARITHMETIC_OPERATOR",
       benefit_uom_name,
       product_uom_name
FROM   apps.qpfv_product_benefits
WHERE  list_header_id = :p_header_id;

Because the view is read-only, it should be used only for query and extraction purposes; any maintenance of benefit products must be performed through the native Advanced Pricing setup forms against QP_LIST_LINES and related tables.

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: 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: 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: 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.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: QPBV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_MODIFIER_LINES, object_name:QPBV_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.QPBV_MODIFIER_LINES ,
View: QPBV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_MODIFIER_LINES, object_name:QPBV_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.QPBV_MODIFIER_LINES ,
View: QP_DEBUG_REQ_LDETS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LDETS_V, object_name:QP_DEBUG_REQ_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi , implementation_dba_data: APPS.QP_DEBUG_REQ_LDETS_V ,
View: QP_LDETS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LDETS_V, object_name:QP_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: This view is for OM to get the post-pricing adjustment/modifier details. , implementation_dba_data: APPS.QP_LDETS_V ,
View: QP_LDETS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LDETS_V, object_name:QP_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: This view is for OM to get the post-pricing adjustment/modifier details. , implementation_dba_data: APPS.QP_LDETS_V ,
View: QP_PREQ_LDETS_TMP 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LDETS_TMP, object_name:QP_PREQ_LDETS_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LDETS_TMP ,
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 ,
View: QP_DEBUG_REQ_LDETS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LDETS_V, object_name:QP_DEBUG_REQ_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi , implementation_dba_data: APPS.QP_DEBUG_REQ_LDETS_V ,
View: QP_PREQ_LDETS_TMP 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LDETS_TMP, object_name:QP_PREQ_LDETS_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LDETS_TMP ,
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: 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_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_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 ,