eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QP_MODIFIER_SUMMARY_V

Source

View Text - Preformatted


SELECT /*+ use_nl(ql, qpa) */ 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.list_header_id,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, QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING', ql.accum_context, ql.accum_attribute), ql.CONTINUOUS_PRICE_BREAK_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)

View Text - HTML Formatted

SELECT /*+ USE_NL(QL
, QPA) */ 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.LIST_HEADER_ID
, 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
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QL.ACCUM_CONTEXT
, QL.ACCUM_ATTRIBUTE)
, QL.CONTINUOUS_PRICE_BREAK_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)