View: QP_PRICE_FACTORS_V

Product:	QP - Advanced Pricing
Description:	View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached.
Implementation/DBA Data:	APPS.QP_PRICE_FACTORS_V

View Text

SELECT UNIQUE QLHB.START_DATE_ACTIVE DISC_MODLIST_START_DATE_ACTIVE
, QLHB.END_DATE_ACTIVE DISC_MODLIST_END_DATE_ACTIVE
, QLHB.LIST_HEADER_ID DISC_MODIFIER_LIST_ID
, QLHTL.NAME DISC_MODIFIER_LIST_NAME
, QLHTL.DESCRIPTION DISC_MODIFIER_LIST_DESCRIPTION
, QPA.PRODUCT_ATTR_VALUE DISC_MODIFIER_LINE_ITEM
, QLL.PRICE_BY_FORMULA_ID
, QPFTL.NAME FORMULA_NAME
, QPFB.PRICE_FORMULA_ID
, QPFB.FORMULA
, QPFB.START_DATE_ACTIVE FORMULA_START_DATE_ACTIVE
, QPFB.END_DATE_ACTIVE FORMULA_END_DATE_ACTIVE
, QPFL.STEP_NUMBER
, QPFL.PRICE_FORMULA_LINE_ID
, QPFL.START_DATE_ACTIVE FORMULA_LINE_START_DATE_ACTIVE
, QPFL.END_DATE_ACTIVE FORMULA_LINE_END_DATE_ACTIVE
, QPFL.PRICE_FORMULA_LINE_TYPE_CODE
, QPFL.PRICE_MODIFIER_LIST_ID
, QLHTL2.NAME PRICE_MODIFIER_LIST_NAME
, QLHB2.START_DATE_ACTIVE PRICE_MOD_START_DATE_ACTIVE
, QLHB2.END_DATE_ACTIVE PRICE_MOD_END_DATE_ACTIVE
, QLHB2.LIST_HEADER_ID PRICE_MODIFIER_LIST_HEADER_ID
, QLL2.LIST_LINE_ID PRICE_MODIFIER_LINE_ID
, QPA2.PRODUCT_ATTR_VALUE PRICE_MODIFIER_LINE_ITEM
, QLL2.OPERAND ADJUSTMENT_FACTOR
, QPA2.PRICING_ATTRIBUTE_ID FACTOR_PRICING_ATTRIBUTE_ID
, QPA2.PRICING_ATTRIBUTE_CONTEXT FACTOR_PRICING_ATTR_CONTEXT
, QPA2.PRICING_ATTRIBUTE FACTOR_PRICING_ATTRIBUTE
, QPA2.COMPARISON_OPERATOR_CODE FACTOR_PRICING_ATTR_OPERATOR
, QPA2.PRICING_ATTR_VALUE_FROM FACTOR_PRICING_ATTR_VALUE_FROM
, QPA2.PRICING_ATTR_VALUE_TO FACTOR_PRICING_ATTR_VALUE_TO
FROM QP_LIST_HEADERS_B QLHB
, QP_LIST_HEADERS_TL QLHTL
, QP_LIST_LINES QLL
, QP_PRICING_ATTRIBUTES QPA
, QP_PRICE_FORMULAS_B QPFB
, QP_PRICE_FORMULAS_TL QPFTL
, QP_PRICE_FORMULA_LINES QPFL
, QP_LIST_HEADERS_B QLHB2
, QP_LIST_HEADERS_TL QLHTL2
, QP_LIST_LINES QLL2
, QP_PRICING_ATTRIBUTES QPA2
WHERE QLHB.LIST_TYPE_CODE IN ('DLT'
, 'SLT'
, 'PRO')
AND QLHB.LIST_HEADER_ID = QLHTL.LIST_HEADER_ID
AND QLHTL.LANGUAGE = USERENV('LANG') AND QLL.LIST_HEADER_ID = QLHB.LIST_HEADER_ID
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QLL.PRICE_BY_FORMULA_ID = QPFB.PRICE_FORMULA_ID
AND QPFB.PRICE_FORMULA_ID = QPFTL.PRICE_FORMULA_ID
AND QPFTL.LANGUAGE = USERENV('LANG')
AND QPFB.PRICE_FORMULA_ID = QPFL.PRICE_FORMULA_ID
AND QPFL.PRICE_FORMULA_LINE_TYPE_CODE = 'ML'
AND QPFL.PRICE_MODIFIER_LIST_ID = QLHB2.LIST_HEADER_ID AND QLHB2.LIST_HEADER_ID = QLHTL2.LIST_HEADER_ID
AND QLHTL2.LANGUAGE = USERENV('LANG')
AND QLHB2.LIST_TYPE_CODE = 'PML' AND QLHB2.LIST_HEADER_ID = QLL2.LIST_HEADER_ID
AND QLL2.LIST_LINE_ID = QPA2.LIST_LINE_ID

Columns