View: OE_PRICE_BREAK_LINES_V

Product:	QP - Advanced Pricing
Description:	Obsolete
Implementation/DBA Data:	APPS.OE_PRICE_BREAK_LINES_V

View Text

SELECT QPA.PRICING_ATTR_VALUE_FROM PRICE_BREAK_LINES_LOW_RANGE
, QPA.PRICING_ATTR_VALUE_TO PRICE_BREAK_LINES_HIGH_RANGE
, QRM.TO_RLTD_MODIFIER_ID DISCOUNT_LINE_ID
, QRM.FROM_RLTD_MODIFIER_ID PARENT_DISCOUNT_LINE_ID
, QP_VIEW_UTIL.GET_ATTRIBUTE_CODE(QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE) METHOD_TYPE_CODE
, QPA.CREATION_DATE CREATION_DATE
, QPA.CREATED_BY CREATED_BY
, QPA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QPA.LAST_UPDATED_BY LAST_UPDATED_BY
, QPA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QPA.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, QPA.PROGRAM_ID PROGRAM_ID
, QPA.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QPA.REQUEST_ID REQUEST_ID
, DECODE(QL.ARITHMETIC_OPERATOR
, '%'
, OPERAND
, NULL) PERCENT
, DECODE(QL.ARITHMETIC_OPERATOR
, 'AMT'
, OPERAND
, NULL) AMOUNT
, DECODE(QL.ARITHMETIC_OPERATOR
, 'NEWPRICE'
, OPERAND
, NULL) PRICE
, QPA.PRODUCT_UOM_CODE UNIT_CODE
, QL.START_DATE_ACTIVE START_DATE_ACTIVE
, QL.END_DATE_ACTIVE END_DATE_ACTIVE
, QPA.CONTEXT
, QPA.ATTRIBUTE1
, QPA.ATTRIBUTE2
, QPA.ATTRIBUTE3
, QPA.ATTRIBUTE4
, QPA.ATTRIBUTE5
, QPA.ATTRIBUTE6
, QPA.ATTRIBUTE7
, QPA.ATTRIBUTE8
, QPA.ATTRIBUTE9
, QPA.ATTRIBUTE10
, QPA.ATTRIBUTE11
, QPA.ATTRIBUTE12
, QPA.ATTRIBUTE13
, QPA.ATTRIBUTE14
, QPA.ATTRIBUTE15
FROM QP_LIST_LINES QL
, QP_PRICING_ATTRIBUTES QPA
, QP_RLTD_MODIFIERS QRM
WHERE QL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QL.LIST_LINE_TYPE_CODE = 'DIS'
AND QL.LIST_LINE_ID = QRM.TO_RLTD_MODIFIER_ID

Columns