QP Pricing Formulas

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Advanced Pricing
Source
Pricing Formulas (XML)
Short Name
QPXPRFOR_XML
DB package
QP_QPXPRFOR_XMLP_PKG

SQL 11 lines

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

Parameters 4

ParameterTypeList of values SQL
Formula FromLOV Oracle
Formula ToLOV Oracle
Start Date ActiveDate
End Date ActiveDate