eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: QPBV_PRODUCT_BENEFITS

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 Text

SELECT PA.LIST_LINE_ID
, PA.LIST_HEADER_ID
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE
, PA.PRODUCT_ATTR_VALUE
, LL2.OPERAND
, LL2.LIST_LINE_ID
, LL1.OPERAND
, LL1.BENEFIT_QTY
, LL1.ARITHMETIC_OPERATOR
, LL1.BENEFIT_UOM_CODE
, PA.PRODUCT_UOM_CODE
, PA.PRICING_ATTRIBUTE_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
FROM QP_RLTD_MODIFIERS RLTD
, QP_LIST_LINES LL1
, QP_LIST_LINES LL2
, QP_PRICING_ATTRIBUTES PA
WHERE RLTD.RLTD_MODIFIER_GRP_TYPE = 'BENEFIT'
AND RLTD.TO_RLTD_MODIFIER_ID = PA.LIST_LINE_ID
AND RLTD.TO_RLTD_MODIFIER_ID = LL1.LIST_LINE_ID
AND LL1.BENEFIT_PRICE_LIST_LINE_ID = LL2.LIST_LINE_ID
AND PA.EXCLUDER_FLAG = 'N'

Columns

Name
LIST_LINE_ID
LIST_HEADER_ID
PRODUCT_ATTRIBUTE_CONTEXT
PRODUCT_ATTRIBUTE
PRODUCT_ATTR_VALUE
LIST_PRICE
PRICE_LIST_LINE_ID
OPERAND
BENEFIT_QTY
ARITHMETIC_OPERATOR
BENEFIT_UOM_CODE
PRODUCT_UOM_CODE
PRICING_ATTRIBUTE_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY