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
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