QP Pricing Formulas

Description

Categories: BI Publisher
Columns: Price Formula Line Type Code, Price Formula Id1, Price List Line Id, Price Modifier List Id, Pricing Attribute Context, Pricing Attribute, Step Number, Numeric Constant, Cf Formula Type, Cf Pricing Context ...

Application: Advanced Pricing
Source: Pricing Formulas (XML)
Short Name: QPXPRFOR_XML
DB package: QP_QPXPRFOR_XMLP_PKG

Copy

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