QP Price Lists (1)

Description
Categories: BI Publisher, Sales
Application: Advanced Pricing
Source: Price Lists (XML)
Short Name: QPXPRCST_XML
DB package: QP_QPXPRCST_XMLP_PKG
SELECT qpll.product_attribute_context product_attribute_context1,
            qpll.product_attribute product_attribute1,
            qpll.product_attr_value, qpll.product_attr_val_disp, 
			to_char(qpll.start_date_active, 'DD-MON-YYYY') start_date_active,
            to_char(qpll.end_date_active, 'DD-MON-YYYY') end_date_active, qpll.list_line_type_code list_line_type_code1,
            qpll.modifier_level_code modifier_level_code1,
            qpll.product_precedence product_precedence1,
            qpll.product_uom_code product_uom_code1,
            qpll.operand,qpl.meaning meaning1,
			qpll.break_uom_code, qpll.break_uom_attribute, qpll.break_uom_context,
			qpll.percent_price percent_price1, qpll.list_header_id,
			qpll.list_line_id list_line_id2,
			qpll.price_by_formula_id price_by_formula_id1, qppf.name formula_name,
			qpl1.meaning meaning2,
			QP_QPXPRCST_XMLP_PKG.cf_product_attributeformula(qpll.product_attribute_context, qpll.product_attribute) CF_product_attribute,
			QP_QPXPRCST_XMLP_PKG.cf_product_attr_val_dispformul(qpll.product_attribute_context, qpll.product_attribute, qpll.product_attr_value, qpll.product_attr_val_disp) CF_product_attr_val_disp
            FROM   qp_list_lines_v qpll, qp_price_formulas_vl qppf,qp_lookups qpl,qp_lookups qpl1
            where qpll.price_by_formula_id = qppf.price_formula_id(+)
             AND  qpl.lookup_type = 'ARITHMETIC_OPERATOR'
             AND qpl.lookup_code = qpll.arithmetic_operator
             AND  (qpl1.lookup_type = 'PRICE_BREAK_TYPE_CODE'  OR  qpl1.lookup_type is null )
             AND  qpll.price_break_type_code= qpl1.lookup_code(+)
             and exists(
             				select '1'
							from mtl_system_items mtl
							where qpll.product_attr_value = mtl.inventory_item_id
							and mtl.organization_id = :P_ITEM_ORGANIZATION
							and qpll.product_attribute = 'PRICING_ATTRIBUTE1'
							UNION
							select '1'
							from dual
							where qpll.product_attribute != 'PRICING_ATTRIBUTE1'
						)
             and qpll.list_header_id=:list_header_id4
            ORDER BY 1
Parameter Name SQL text Validation
Responsibility Id
 
Number
User Name
 
Item Validation Organization
 
Number
To Currency Code
 
LOV Oracle
Qualifier Attibute Value To
 
LOV Oracle
Active Price List Lines Only
 
LOV Oracle
Active Flag
 
LOV Oracle
End Date Active
 
Date
Start Date Active
 
Date
Price List To
 
LOV Oracle
Price List From
 
LOV Oracle