View: QPFV_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.QPFV_PRODUCT_BENEFITS

View Text

SELECT PA.LIST_LINE_ID
, PA.LIST_HEADER_ID
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, 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
, '_LA:LL1.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING'
, LL1.BENEFIT_UOM_CODE
, MTL1.UNIT_OF_MEASURE
, PA.PRODUCT_UOM_CODE
, MTL2.UNIT_OF_MEASURE
, PA.PRICING_ATTRIBUTE_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, '_DF:QP:QP_PRICING_ATTRIBUTES:PA'
FROM QP_RLTD_MODIFIERS RLTD
, QP_LIST_LINES LL1
, QP_LIST_LINES LL2
, QP_PRICING_ATTRIBUTES PA
, MTL_UNITS_OF_MEASURE MTL1
, MTL_UNITS_OF_MEASURE MTL2
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'
AND LL1.BENEFIT_UOM_CODE = MTL1.UOM_CODE (+)
AND PA.PRODUCT_UOM_CODE = MTL2.UOM_CODE (+) WITH READ ONLY

Columns