View: QPBV_ADDITIONAL_BUY_PRODUCTS

Product:	QP - Advanced Pricing
Description:	This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner.
Implementation/DBA Data:	APPS.QPBV_ADDITIONAL_BUY_PRODUCTS

View Text

SELECT RLTD.FROM_RLTD_MODIFIER_ID
, RLTD.TO_RLTD_MODIFIER_ID
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE
, PA.PRODUCT_ATTR_VALUE
, PA.PRODUCT_UOM_CODE
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_FROM
, PA.PRICING_ATTR_VALUE_TO
, RLTD.RLTD_MODIFIER_GRP_NO
, PA.COMPARISON_OPERATOR_CODE
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
FROM QP_RLTD_MODIFIERS RLTD
, QP_PRICING_ATTRIBUTES PA
WHERE RLTD.RLTD_MODIFIER_GRP_TYPE = 'QUALIFIER'
AND RLTD.TO_RLTD_MODIFIER_ID = PA.LIST_LINE_ID

Columns