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_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.QPBV_PRICE_BREAK_LINES

View Text

SELECT RLTD.FROM_RLTD_MODIFIER_ID
, RLTD.TO_RLTD_MODIFIER_ID
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_FROM
, PA.PRICING_ATTR_VALUE_TO
, PA.COMPARISON_OPERATOR_CODE
, LL2.ARITHMETIC_OPERATOR
, LL2.OPERAND
, LL2.LIST_LINE_TYPE_CODE
, LL2.CREATION_DATE
, LL2.CREATED_BY
, LL2.LAST_UPDATE_DATE
, LL2.LAST_UPDATED_BY
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

Name
PRICE_BREAK_HEADER_ID
PRICE_BREAK_LINE_ID
PRICING_ATTRIBUTE_CONTEXT
PRICING_ATTRIBUTE
PRICING_ATTR_VALUE_FROM
PRICING_ATTR_VALUE_TO
COMPARISON_OPERATOR_CODE
ARITHMETIC_OPERATOR
OPERAND
LIST_LINE_TYPE_CODE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY