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.

VIEW: APPS.QP_BLKTPRT_PRC_BREAKS_V

Source

View Text - Preformatted


SELECT qpl.list_header_id, qpl.list_line_id, qrm.from_rltd_modifier_id, qrm.to_rltd_modifier_id, qpl.list_line_type_code, DECODE(qpa.pricing_attribute,'PRICING_ATTRIBUTE10','QTY','PRICING_ATTRIBUTE12','AMT',qpa.pricing_attribute) volume_type_code, QP_BLANKET_AGR_UTIL.get_attribute_code('QP_ATTR_DEFNS_PRICING', qpa.PRICING_ATTRIBUTE_CONTEXT, qpa.PRICING_ATTRIBUTE) pricing_attribute, DECODE(qpa.pricing_attribute,'PRICING_ATTRIBUTE12',to_char(qpa.pricing_attr_value_from, FND_CURRENCY.GET_FORMAT_MASK(qlh.currency_code,20)),qpa.pricing_attr_value_from) value_from, DECODE(qpa.pricing_attribute,'PRICING_ATTRIBUTE12',to_char(qpa.pricing_attr_value_to, FND_CURRENCY.GET_FORMAT_MASK(qlh.currency_code,20)),qpa.pricing_attr_value_to) value_to, qpl.arithmetic_operator, to_char(qpl.operand,FND_CURRENCY.GET_FORMAT_MASK(qlh.currency_code,20)) value FROM qp_list_lines qpl, qp_rltd_modifiers qrm, qp_pricing_attributes qpa, qp_list_headers_b qlh WHERE qlh.list_header_id = qpl.list_header_id AND qpl.list_header_id = qpa.list_header_id AND qpa.list_line_id = qpl.list_line_id AND qrm.to_rltd_modifier_id = qpl.list_line_id AND qrm.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'

View Text - HTML Formatted

SELECT QPL.LIST_HEADER_ID
, QPL.LIST_LINE_ID
, QRM.FROM_RLTD_MODIFIER_ID
, QRM.TO_RLTD_MODIFIER_ID
, QPL.LIST_LINE_TYPE_CODE
, DECODE(QPA.PRICING_ATTRIBUTE
, 'PRICING_ATTRIBUTE10'
, 'QTY'
, 'PRICING_ATTRIBUTE12'
, 'AMT'
, QPA.PRICING_ATTRIBUTE) VOLUME_TYPE_CODE
, QP_BLANKET_AGR_UTIL.GET_ATTRIBUTE_CODE('QP_ATTR_DEFNS_PRICING'
, QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE) PRICING_ATTRIBUTE
, DECODE(QPA.PRICING_ATTRIBUTE
, 'PRICING_ATTRIBUTE12'
, TO_CHAR(QPA.PRICING_ATTR_VALUE_FROM
, FND_CURRENCY.GET_FORMAT_MASK(QLH.CURRENCY_CODE
, 20))
, QPA.PRICING_ATTR_VALUE_FROM) VALUE_FROM
, DECODE(QPA.PRICING_ATTRIBUTE
, 'PRICING_ATTRIBUTE12'
, TO_CHAR(QPA.PRICING_ATTR_VALUE_TO
, FND_CURRENCY.GET_FORMAT_MASK(QLH.CURRENCY_CODE
, 20))
, QPA.PRICING_ATTR_VALUE_TO) VALUE_TO
, QPL.ARITHMETIC_OPERATOR
, TO_CHAR(QPL.OPERAND
, FND_CURRENCY.GET_FORMAT_MASK(QLH.CURRENCY_CODE
, 20)) VALUE
FROM QP_LIST_LINES QPL
, QP_RLTD_MODIFIERS QRM
, QP_PRICING_ATTRIBUTES QPA
, QP_LIST_HEADERS_B QLH
WHERE QLH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND QPL.LIST_HEADER_ID = QPA.LIST_HEADER_ID
AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
AND QRM.TO_RLTD_MODIFIER_ID = QPL.LIST_LINE_ID
AND QRM.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'