View: CLN_PROCAT_VOLPRICEBREAK_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View for the price breaks of a particular price list item
Implementation/DBA Data:	APPS.CLN_PROCAT_VOLPRICEBREAK_V

View Text

SELECT QRM.FROM_RLTD_MODIFIER_ID PRODUCT_LIST_LINE_ID
, QPA.PRICING_ATTR_VALUE_FROM PRICEBREAKVOL
, QLL.OPERAND PRICE_BREAK
FROM QP_LIST_LINES QLL
, QP_RLTD_MODIFIERS QRM
, QP_PRICING_ATTRIBUTES QPA
WHERE QRM.TO_RLTD_MODIFIER_ID = QLL.LIST_LINE_ID
AND QRM.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID

Columns