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