VIEW: APPS.QP_BLKTPRT_MOD_LINES_V

Source

View Text - Preformatted

SELECT qpl.list_header_id, qpl.list_line_id, qpl.list_line_type_code, qpl.start_date_active start_date, qpl.end_date_active end_date, QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING', qpa.product_attribute_context, qpa.product_attribute) PRODUCT_ATTRIBUTE, QP_Price_List_Line_Util.Get_Product_Value('QP_ATTR_DEFNS_PRICING', qpa.product_attribute_context,qpa.product_attribute, qpa.product_attr_value) Product_attribute_value, QP_MASS_MAINTAIN_UTIL.get_product_desc(qpa.product_attribute_context, qpa.product_attribute, qpa.product_attr_value) Product_description, QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING', qpa.pricing_attribute_context, qpa.pricing_attribute) VOLUME_TYPE, DECODE(qpa.pricing_attribute,'PRICING_ATTRIBUTE10','QTY', 'PRICING_ATTRIBUTE12','AMT',qpa.pricing_attribute) volume_type_code, qpa.comparison_operator_code comparison_Operator, qpa.product_uom_code UOM, qpa.pricing_attr_value_from Value_from, qpa.pricing_attr_value_to Value_to, to_char(null) arithmetic_operator, to_char(null) operand, qpl.price_break_type_code FROM qp_list_lines qpl, qp_pricing_attributes qpa WHERE qpl.list_header_id = qpa.list_header_id AND qpl.list_line_id = qpa.list_line_id AND qpl.list_line_type_code = 'PBH' AND (qpa.pricing_attribute_context is null OR qpa.pricing_attribute_context = 'VOLUME' ) UNION ALL SELECT qpl.list_header_id, qpl.list_line_id, qpl.list_line_type_code, qpl.start_date_active start_date, qpl.end_date_active end_date, QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING', qpa.product_attribute_context, qpa.product_attribute) PRODUCT_ATTRIBUTE, QP_Price_List_Line_Util.Get_Product_Value('QP_ATTR_DEFNS_PRICING', qpa.product_attribute_context,qpa.product_attribute, qpa.product_attr_value) Product_attribute_value, QP_MASS_MAINTAIN_UTIL.get_product_desc(qpa.product_attribute_context, qpa.product_attribute, qpa.product_attr_value) Product_description, QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING', qpa.pricing_attribute_context, qpa.pricing_attribute) VOLUME_TYPE, DECODE(qpa.pricing_attribute,'PRICING_ATTRIBUTE10','QTY', 'PRICING_ATTRIBUTE12','AMT',qpa.pricing_attribute) volume_type_code, qpa.comparison_operator_code comparison_Operator, qpa.product_uom_code UOM, qpa.pricing_attr_value_from Value_from, qpa.pricing_attr_value_to Value_to, qpl.arithmetic_operator, to_char(qpl.operand, FND_CURRENCY.GET_FORMAT_MASK(qlh.currency_code,20)) Operand, qpl.price_break_type_code FROM qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qlh WHERE qlh.list_header_id = qpl.list_header_id AND qpl.list_line_id = qpa.list_line_id AND (qpa.pricing_attribute_context is null OR qpa.pricing_attribute_context = 'VOLUME') AND qpl.list_line_type_code in ('DIS','SUR','FREIGHT_CHARGE') AND qpl.qualification_ind in (0,2,4,6,8,10,12,14,16,18,20,22,24,26,28,30) AND nvl(qpl.end_date_active, TRUNC(sysdate + 1)) >= TRUNC(sysdate + 1) ORDER BY list_line_type_code,list_line_id

View Text - HTML Formatted

SELECT QPL.LIST_HEADER_ID
, QPL.LIST_LINE_ID
, QPL.LIST_LINE_TYPE_CODE
, QPL.START_DATE_ACTIVE START_DATE
, QPL.END_DATE_ACTIVE END_DATE
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE) PRODUCT_ATTRIBUTE
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE) PRODUCT_ATTRIBUTE_VALUE
, QP_MASS_MAINTAIN_UTIL.GET_PRODUCT_DESC(QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE) PRODUCT_DESCRIPTION
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE) VOLUME_TYPE
, DECODE(QPA.PRICING_ATTRIBUTE
, 'PRICING_ATTRIBUTE10'
, 'QTY'
, 'PRICING_ATTRIBUTE12'
, 'AMT'
, QPA.PRICING_ATTRIBUTE) VOLUME_TYPE_CODE
, QPA.COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR
, QPA.PRODUCT_UOM_CODE UOM
, QPA.PRICING_ATTR_VALUE_FROM VALUE_FROM
, QPA.PRICING_ATTR_VALUE_TO VALUE_TO
, TO_CHAR(NULL) ARITHMETIC_OPERATOR
, TO_CHAR(NULL) OPERAND
, QPL.PRICE_BREAK_TYPE_CODE
FROM QP_LIST_LINES QPL
, QP_PRICING_ATTRIBUTES QPA
WHERE QPL.LIST_HEADER_ID = QPA.LIST_HEADER_ID
AND QPL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPL.LIST_LINE_TYPE_CODE = 'PBH'
AND (QPA.PRICING_ATTRIBUTE_CONTEXT IS NULL OR QPA.PRICING_ATTRIBUTE_CONTEXT = 'VOLUME' ) UNION ALL SELECT QPL.LIST_HEADER_ID
, QPL.LIST_LINE_ID
, QPL.LIST_LINE_TYPE_CODE
, QPL.START_DATE_ACTIVE START_DATE
, QPL.END_DATE_ACTIVE END_DATE
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE) PRODUCT_ATTRIBUTE
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE) PRODUCT_ATTRIBUTE_VALUE
, QP_MASS_MAINTAIN_UTIL.GET_PRODUCT_DESC(QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE) PRODUCT_DESCRIPTION
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE) VOLUME_TYPE
, DECODE(QPA.PRICING_ATTRIBUTE
, 'PRICING_ATTRIBUTE10'
, 'QTY'
, 'PRICING_ATTRIBUTE12'
, 'AMT'
, QPA.PRICING_ATTRIBUTE) VOLUME_TYPE_CODE
, QPA.COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR
, QPA.PRODUCT_UOM_CODE UOM
, QPA.PRICING_ATTR_VALUE_FROM VALUE_FROM
, QPA.PRICING_ATTR_VALUE_TO VALUE_TO
, QPL.ARITHMETIC_OPERATOR
, TO_CHAR(QPL.OPERAND
, FND_CURRENCY.GET_FORMAT_MASK(QLH.CURRENCY_CODE
, 20)) OPERAND
, QPL.PRICE_BREAK_TYPE_CODE
FROM QP_LIST_LINES QPL
, QP_PRICING_ATTRIBUTES QPA
, QP_LIST_HEADERS_B QLH
WHERE QLH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND QPL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND (QPA.PRICING_ATTRIBUTE_CONTEXT IS NULL OR QPA.PRICING_ATTRIBUTE_CONTEXT = 'VOLUME')
AND QPL.LIST_LINE_TYPE_CODE IN ('DIS'
, 'SUR'
, 'FREIGHT_CHARGE')
AND QPL.QUALIFICATION_IND IN (0
, 2
, 4
, 6
, 8
, 10
, 12
, 14
, 16
, 18
, 20
, 22
, 24
, 26
, 28
, 30)
AND NVL(QPL.END_DATE_ACTIVE
, TRUNC(SYSDATE + 1)) >= TRUNC(SYSDATE + 1) ORDER BY LIST_LINE_TYPE_CODE
, LIST_LINE_ID