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
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 NameSQL textValidation
Formula From
 
LOV Oracle
Formula To
 
LOV Oracle
Start Date Active
 
Date
End Date Active
 
Date
Download
Related Blitz Reports
QP Price List Upload QP Price Lists QP Modifier Details (1) ECC Advanced Pricing, Pricing Lines QP Customer Pricing Engine Request QP Modifier Details QP Modifier Upload AR Customer Upload QP Pricing Agreements
Blitz Report™