VIEW: APPS.QP_BLKTPRT_PRL_LINES_V

Source

View Text - Preformatted

SELECT qpl.list_header_id, qpl.list_line_id, qpl.list_line_type_code, qpl.modifier_level_code, qpl.price_break_type_code, 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, qpa.product_uom_code UOM, qpl.arithmetic_operator, to_char(qpl.operand) value, qpl.start_date_active start_date, qpl.end_date_active end_date 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 UNION ALL SELECT qpl.list_header_id, qpl.list_line_id, qpl.list_line_type_code, qpl.modifier_level_code, qpl.price_break_type_code, 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, qpa.product_uom_code UOM, qpl.arithmetic_operator, to_char(qpl.operand, FND_CURRENCY.GET_FORMAT_MASK(qlh.currency_code,20)) value, qpl.start_date_active start_date, qpl.end_date_active end_date 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_header_id = qpa.list_header_id AND qpl.list_line_id = qpa.list_line_id AND qpl.list_line_type_code = 'PLL' AND qpa.pricing_attribute_context is null AND qpl.qualification_ind in (0,2,4,6,8,10,12,14,16,18,20,22,24,26,28,30)

View Text - HTML Formatted

SELECT QPL.LIST_HEADER_ID
, QPL.LIST_LINE_ID
, QPL.LIST_LINE_TYPE_CODE
, QPL.MODIFIER_LEVEL_CODE
, QPL.PRICE_BREAK_TYPE_CODE
, 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
, QPA.PRODUCT_UOM_CODE UOM
, QPL.ARITHMETIC_OPERATOR
, TO_CHAR(QPL.OPERAND) VALUE
, QPL.START_DATE_ACTIVE START_DATE
, QPL.END_DATE_ACTIVE END_DATE
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 UNION ALL SELECT QPL.LIST_HEADER_ID
, QPL.LIST_LINE_ID
, QPL.LIST_LINE_TYPE_CODE
, QPL.MODIFIER_LEVEL_CODE
, QPL.PRICE_BREAK_TYPE_CODE
, 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
, QPA.PRODUCT_UOM_CODE UOM
, QPL.ARITHMETIC_OPERATOR
, TO_CHAR(QPL.OPERAND
, FND_CURRENCY.GET_FORMAT_MASK(QLH.CURRENCY_CODE
, 20)) VALUE
, QPL.START_DATE_ACTIVE START_DATE
, QPL.END_DATE_ACTIVE END_DATE
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_HEADER_ID = QPA.LIST_HEADER_ID
AND QPL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPL.LIST_LINE_TYPE_CODE = 'PLL'
AND QPA.PRICING_ATTRIBUTE_CONTEXT IS NULL
AND QPL.QUALIFICATION_IND IN (0
, 2
, 4
, 6
, 8
, 10
, 12
, 14
, 16
, 18
, 20
, 22
, 24
, 26
, 28
, 30)