VIEW: APPS.QP_PRICE_FACTORS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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