VIEW: APPS.OE_PRICE_BREAK_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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