View: QP_MODIFIER_SUMMARY_V

Product:	QP - Advanced Pricing
Description:	Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block).
Implementation/DBA Data:	APPS.QP_MODIFIER_SUMMARY_V

View Text

SELECT /*+ USE_NL(QL
, QPA) INDEX(QL QP_LIST_LINES_N5) */ QL.ROWID
, QL.LIST_LINE_ID
, QL.CREATION_DATE
, QL.CREATED_BY
, QL.LAST_UPDATE_DATE
, QL.LAST_UPDATED_BY
, QL.LAST_UPDATE_LOGIN
, QL.PROGRAM_APPLICATION_ID
, QL.PROGRAM_ID
, QL.PROGRAM_UPDATE_DATE
, QL.REQUEST_ID
, QL.LIST_HEADER_ID
, QL.LIST_LINE_TYPE_CODE
, QL.AUTOMATIC_FLAG
, QL.MODIFIER_LEVEL_CODE
, QL.LIST_PRICE
, QL.LIST_PRICE_UOM_CODE
, QL.PRIMARY_UOM_FLAG
, QL.INVENTORY_ITEM_ID
, QL.ORGANIZATION_ID
, QL.RELATED_ITEM_ID
, QL.RELATIONSHIP_TYPE_ID
, QL.SUBSTITUTION_CONTEXT
, QL.SUBSTITUTION_ATTRIBUTE
, QL.SUBSTITUTION_VALUE
, QL.REVISION
, QL.REVISION_DATE
, QL.REVISION_REASON_CODE
, QL.CONTEXT
, QL.ATTRIBUTE1
, QL.ATTRIBUTE2
, QL.COMMENTS
, QL.ATTRIBUTE3
, QL.ATTRIBUTE4
, QL.ATTRIBUTE5
, QL.ATTRIBUTE6
, QL.ATTRIBUTE7
, QL.ATTRIBUTE8
, QL.ATTRIBUTE9
, QL.ATTRIBUTE10
, QL.INCLUDE_ON_RETURNS_FLAG
, QL.ATTRIBUTE11
, QL.ATTRIBUTE12
, QL.ATTRIBUTE13
, QL.ATTRIBUTE14
, QL.ATTRIBUTE15
, QL.PRICE_BREAK_TYPE_CODE
, QL.PERCENT_PRICE
, QL.EFFECTIVE_PERIOD_UOM
, QL.NUMBER_EFFECTIVE_PERIODS
, QL.OPERAND
, QL.ARITHMETIC_OPERATOR
, QL.OVERRIDE_FLAG
, QL.PRINT_ON_INVOICE_FLAG
, QL.REBATE_TRANSACTION_TYPE_CODE
, QL.ESTIM_ACCRUAL_RATE
, QL.PRICE_BY_FORMULA_ID
, QL.GENERATE_USING_FORMULA_ID
, QL.START_DATE_ACTIVE
, QL.END_DATE_ACTIVE
, QL.REPRICE_FLAG
, QL.ACCRUAL_FLAG
, QL.PRICING_GROUP_SEQUENCE
, QL.INCOMPATIBILITY_GRP_CODE
, QL.LIST_LINE_NO
, QL.PRODUCT_PRECEDENCE
, QL.PRICING_PHASE_ID
, QL.EXPIRATION_PERIOD_START_DATE
, QL.NUMBER_EXPIRATION_PERIODS
, QL.EXPIRATION_PERIOD_UOM
, QL.EXPIRATION_DATE
, QL.ESTIM_GL_VALUE
, QL.ACCRUAL_CONVERSION_RATE
, QL.BENEFIT_PRICE_LIST_LINE_ID
, QL.PRORATION_TYPE_CODE
, QL.BENEFIT_QTY
, QL.BENEFIT_UOM_CODE
, QL.CHARGE_TYPE_CODE
, QL.CHARGE_SUBTYPE_CODE
, QL.BENEFIT_LIMIT
, QPA.PRICING_ATTRIBUTE_ID
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE
, QPA.PRODUCT_UOM_CODE
, QPA.COMPARISON_OPERATOR_CODE
, QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE
, QPA.PRICING_ATTR_VALUE_FROM
, QPA.PRICING_ATTR_VALUE_TO
, QPA.PRICING_ATTRIBUTE_DATATYPE
, QPA.PRODUCT_ATTRIBUTE_DATATYPE
, QPA.EXCLUDER_FLAG
, QPA.ATTRIBUTE_GROUPING_NO
, QL.LIST_LINE_ID
, NULL
, NULL
, NULL
, NULL
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.PRORATION_TYPE_CODE
, 'PRORATION_TYPE')
, QP_QP_FORM_PRICING_ATTR.GET_PRICING_PHASE(QL.PRICING_PHASE_ID)
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.INCOMPATIBILITY_GRP_CODE
, 'INCOMPATIBILITY_GROUPS')
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.MODIFIER_LEVEL_CODE
, 'MODIFIER_LEVEL_CODE')
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.LIST_LINE_TYPE_CODE
, 'LIST_LINE_TYPE_CODE')
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.PRICE_BREAK_TYPE_CODE
, 'PRICE_BREAK_TYPE_CODE')
, QP_QP_FORM_PRICING_ATTR.GET_CHARGE_NAME(QL.CHARGE_TYPE_CODE
, QL.CHARGE_SUBTYPE_CODE
, QL.LIST_LINE_TYPE_CODE)
, QP_QP_FORM_PRICING_ATTR.GET_FORMULA(QL.PRICE_BY_FORMULA_ID)
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.ARITHMETIC_OPERATOR
, 'ARITHMETIC_OPERATOR')
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.EXPIRATION_DATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.EXPIRATION_PERIOD_START_DATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.NUMBER_EXPIRATION_PERIODS
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.EXPIRATION_PERIOD_UOM
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'CIE'
, QL.EXPIRATION_DATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'CIE'
, QL.EXPIRATION_PERIOD_START_DATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'CIE'
, QL.NUMBER_EXPIRATION_PERIODS
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'CIE'
, QL.EXPIRATION_PERIOD_UOM
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'PBH'
, QL.EXPIRATION_DATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'PBH'
, QL.EXPIRATION_PERIOD_START_DATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'PBH'
, QL.NUMBER_EXPIRATION_PERIODS
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'PBH'
, QL.EXPIRATION_PERIOD_UOM
, NULL)
, QP_QP_FORM_PRICING_ATTR.GET_REBATE_TXN_TYPE(QL.LIST_LINE_ID
, 'DIS'
, QL.LIST_LINE_TYPE_CODE
, QL.REBATE_TRANSACTION_TYPE_CODE)
, QP_QP_FORM_PRICING_ATTR.GET_REBATE_TXN_TYPE(QL.LIST_LINE_ID
, 'PBH'
, QL.LIST_LINE_TYPE_CODE
, QL.REBATE_TRANSACTION_TYPE_CODE)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.BENEFIT_QTY
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.BENEFIT_UOM_CODE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'CIE'
, QL.BENEFIT_QTY
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'CIE'
, QL.BENEFIT_UOM_CODE
, NULL)
, QP_QP_FORM_PRICING_ATTR.GET_BENEFIT_LIST_LINE_NO(QL.LIST_LINE_ID
, QL.LIST_LINE_TYPE_CODE)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.ACCRUAL_FLAG
, 'N')
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'PBH'
, QL.ACCRUAL_FLAG
, 'N')
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.ACCRUAL_CONVERSION_RATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'CIE'
, QL.ACCRUAL_CONVERSION_RATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'CIE'
, QL.ESTIM_ACCRUAL_RATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'PBH'
, QL.ACCRUAL_CONVERSION_RATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'DIS'
, QL.ESTIM_ACCRUAL_RATE
, NULL)
, DECODE(QL.LIST_LINE_TYPE_CODE
, 'PBH'
, QL.ESTIM_ACCRUAL_RATE
, NULL)
, NULL
, NULL
, NULL
, NULL
, QP_QP_FORM_PRICING_ATTR.GET_SEGMENT_NAME('QP_ATTR_DEFNS_PRICING'
, QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_SEGMENT_NAME('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, 'ITEM'
, 'PRICING_ATTRIBUTE1'
, QL.RELATED_ITEM_ID)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_QUALIFIER'
, QL.SUBSTITUTION_CONTEXT
, QL.SUBSTITUTION_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_QUALIFIER'
, QL.SUBSTITUTION_CONTEXT
, QL.SUBSTITUTION_ATTRIBUTE
, QL.SUBSTITUTION_VALUE)
, QP_QP_FORM_PRICING_ATTR.GET_SEGMENT_NAME('QP_ATTR_DEFNS_QUALIFIER'
, QL.SUBSTITUTION_CONTEXT
, QL.SUBSTITUTION_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE)
, QL.NET_AMOUNT_FLAG
FROM QP_LIST_LINES QL
, QP_PRICING_ATTRIBUTES QPA
WHERE QL.PRICING_PHASE_ID > 1
AND QL.QUALIFICATION_IND IN (0
, 2
, 4
, 6
, 8
, 10
, 12
, 14
, 16
, 18
, 20
, 22
, 24
, 26
, 28
, 30
, 32)
AND QL.LIST_LINE_ID = QPA.LIST_LINE_ID(+)
AND (QPA.PRICING_ATTRIBUTE_CONTEXT = 'VOLUME' OR QPA.PRICING_ATTRIBUTE_CONTEXT IS NULL)

Columns