QP Pricing Formulas

➜ Back to Library

Description
Categories: BI Publisher, Sales Application: Advanced Pricing Source: Pricing Formulas (XML) Short Name: QPXPRFOR_XML DB package: QP_QPXPRFOR_XMLP_PKG more less

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

Parameter Name

SQL text

Validation

End Date Active

Date

Start Date Active

Date

Formula To

LOV Oracle

Formula From

LOV Oracle

Download

Related Blitz Reports
QP Price Lists QP Price Lists (1) QP Modifier Details JG Regional Invoice Format Program - draft ONT Order Headers and Lines ONT Comprehensive Order Detail ONT Order Discount Detail AR Customers and Sites ONT Agreement Activity

Blitz Report In Action