QP Pricing Formulas

Description
Categories: BI Publisher, Sales
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
End Date Active
 
Date
Start Date Active
 
Date
Formula To
 
LOV Oracle
Formula From
 
LOV Oracle