View: QPFV_PRICE_BREAK_LINES

Product:	QP - Advanced Pricing
Description:	This view gives information about the price break lines attached to a Price Break header of a Modifier or a Price List.
Implementation/DBA Data:	APPS.QPFV_PRICE_BREAK_LINES

View Text

SELECT RLTD.FROM_RLTD_MODIFIER_ID
, RLTD.TO_RLTD_MODIFIER_ID
, PA.PRICING_ATTRIBUTE_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_PRICING'
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_FROM)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_PRICING'
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_TO)
, LL2.OPERAND
, PA.COMPARISON_OPERATOR_CODE
, '_LA:PA.COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING'
, LL2.ARITHMETIC_OPERATOR
, '_LA:LL2.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING'
, LL2.LIST_LINE_TYPE_CODE
, '_LA:LL2.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, LL2.CREATION_DATE
, LL2.CREATED_BY
, LL2.LAST_UPDATE_DATE
, LL2.LAST_UPDATED_BY
, '_DF:QP:QP_PRICING_ATTRIBUTES:PA'
FROM QP_LIST_LINES LL2
, QP_RLTD_MODIFIERS RLTD
, QP_PRICING_ATTRIBUTES PA
WHERE RLTD.TO_RLTD_MODIFIER_ID = LL2.LIST_LINE_ID
AND RLTD.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'
AND LL2.LIST_LINE_ID = PA.LIST_LINE_ID WITH READ ONLY

Columns