QP Pricing Formulas

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Pricing
Source: Pricing Formulas (XML)
Short Name: QPXPRFOR_XML
DB package: QP_QPXPRFOR_XMLP_PKG
Run QP Pricing Formulas and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT a.price_formula_line_type_code,
		 a.price_formula_id price_formula_id1,
		 a.price_list_line_id,
              a.price_modifier_list_id,a.pricing_attribute_context,a.pricing_attribute,
              a.step_number,a.numeric_constant, 
	QP_QPXPRFOR_XMLP_PKG.cf_formula_typeformula(a.price_formula_line_type_code) CF_formula_type, 
	QP_QPXPRFOR_XMLP_PKG.cf_pricing_contextformula(a.pricing_attribute_context, a.pricing_attribute) CF_pricing_context, 
	QP_QPXPRFOR_XMLP_PKG.cf_componentformula(a.price_list_line_id, a.price_modifier_list_id, a.price_formula_line_type_code, a.numeric_constant) CF_component
FROM    qp_price_formula_lines a 
 WHERE a.price_formula_id = :price_formula_id2
Parameter Name SQL text Validation
Formula From 
 
 LOV Oracle
Formula To 
 
 LOV Oracle
Start Date Active 
 
 Date
End Date Active 
 
 Date
Download
Related Blitz Reports
QP Price Lists ECC Advanced Pricing, Pricing Lines QP Customer Pricing Engine Request QP Modifier Details ONT Orders and Lines ONT Order Discount Detail ONT DIFOT AR Customers and Sites ONT Orders
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™