VIEW: APPS.QP_ARCH_MOD_SUMMARY_V

Source

View Text - Preformatted

SELECT qal.rowid ROW_ID, qal.LIST_LINE_ID LIST_LINE_ID, qal.CREATION_DATE CREATION_DATE, qal.CREATED_BY CREATED_BY, qal.LAST_UPDATE_DATE LATE_UPDATE_DATE, qal.LAST_UPDATED_BY LAST_UPDATED_BY, qal.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, qal.PROGRAM_APPLICATION_ID , qal.PROGRAM_ID , qal.PROGRAM_UPDATE_DATE , qal.REQUEST_ID , qal.LIST_HEADER_ID , qal.LIST_LINE_TYPE_CODE , qal.AUTOMATIC_FLAG , qal.MODIFIER_LEVEL_CODE , qal.LIST_PRICE , qal.LIST_PRICE_UOM_CODE , qal.PRIMARY_UOM_FLAG , qal.INVENTORY_ITEM_ID , qal.ORGANIZATION_ID , qal.RELATED_ITEM_ID , qal.RELATIONSHIP_TYPE_ID , qal.SUBSTITUTION_CONTEXT , qal.SUBSTITUTION_ATTRIBUTE , qal.SUBSTITUTION_VALUE , qal.REVISION , qal.REVISION_DATE , qal.REVISION_REASON_CODE , qal.CONTEXT , qal.ATTRIBUTE1 , qal.ATTRIBUTE2 , qal.COMMENTS , qal.ATTRIBUTE3 , qal.ATTRIBUTE4 , qal.ATTRIBUTE5 , qal.ATTRIBUTE6 , qal.ATTRIBUTE7 , qal.ATTRIBUTE8 , qal.ATTRIBUTE9 , qal.ATTRIBUTE10 , qal.INCLUDE_ON_RETURNS_FLAG , qal.ATTRIBUTE11 , qal.ATTRIBUTE12 , qal.ATTRIBUTE13 , qal.ATTRIBUTE14 , qal.ATTRIBUTE15 , qal.PRICE_BREAK_TYPE_CODE , qal.PERCENT_PRICE , qal.EFFECTIVE_PERIOD_UOM , qal.NUMBER_EFFECTIVE_PERIODS , qal.OPERAND , qal.ARITHMETIC_OPERATOR , qal.OVERRIDE_FLAG , qal.PRINT_ON_INVOICE_FLAG , qal.REBATE_TRANSACTION_TYPE_CODE , qal.ESTIM_ACCRUAL_RATE , qal.PRICE_BY_FORMULA_ID , qal.GENERATE_USING_FORMULA_ID , qal.START_DATE_ACTIVE , qal.END_DATE_ACTIVE , qal.REPRICE_FLAG , qal.ACCRUAL_FLAG , qal.PRICING_GROUP_SEQUENCE , qal.INCOMPATIBILITY_GRP_CODE , qal.LIST_LINE_NO , qal.PRODUCT_PRECEDENCE , qal.PRICING_PHASE_ID , qal.EXPIRATION_PERIOD_START_DATE , qal.NUMBER_EXPIRATION_PERIODS , qal.EXPIRATION_PERIOD_UOM , qal.EXPIRATION_DATE , qal.ESTIM_GL_VALUE , qal.ACCRUAL_CONVERSION_RATE , qal.BENEFIT_PRICE_LIST_LINE_ID, qal.PRORATION_TYPE_CODE , qal.BENEFIT_QTY , qal.BENEFIT_UOM_CODE , qal.CHARGE_TYPE_CODE , qal.CHARGE_SUBTYPE_CODE , qal.BENEFIT_LIMIT , qapa.PRICING_ATTRIBUTE_ID , qapa.PRODUCT_ATTRIBUTE_CONTEXT , qapa.PRODUCT_ATTRIBUTE , qapa.PRODUCT_ATTR_VALUE, qapa.PRODUCT_UOM_CODE , qapa.COMPARISON_OPERATOR_CODE , qapa.PRICING_ATTRIBUTE_CONTEXT , qapa.PRICING_ATTRIBUTE , qapa.PRICING_ATTR_VALUE_FROM , qapa.PRICING_ATTR_VALUE_TO , qapa.PRICING_ATTRIBUTE_DATATYPE , qapa.PRODUCT_ATTRIBUTE_DATATYPE , qapa.EXCLUDER_FLAG , qapa.ATTRIBUTE_GROUPING_NO , qal.list_line_id PARENT_LIST_LINE_ID, NULL TO_RLTD_MODIFIER_ID, NULL RLTD_MODIFIER_GRP_NO, NULL RLTD_MODIFIER_GRP_TYPE, NULL RLTD_MODIFIER_ID, QP_QP_Form_Pricing_Attr.Get_Meaning(qal.proration_type_code, 'PRORATION_TYPE') PRORATION_TYPE, QP_QP_Form_Pricing_Attr.Get_Pricing_Phase(qal.pricing_phase_id) PRICING_PHASE, QP_QP_Form_Pricing_Attr.Get_Meaning(qal.incompatibility_grp_code, 'INCOMPATIBILITY_GROUPS') INCOMPATIBILITY_GRP, QP_QP_Form_Pricing_Attr.Get_Meaning(qal.modifier_level_code, 'MODIFIER_LEVEL_CODE') MODIFIER_LEVEL, QP_QP_Form_Pricing_Attr.Get_Meaning(qal.list_line_type_code, 'LIST_LINE_TYPE_CODE') LIST_LINE_TYPE, QP_QP_Form_Pricing_Attr.Get_Meaning(qal.price_break_type_code, 'PRICE_BREAK_TYPE_CODE') PRICE_BREAK_TYPE, QP_QP_Form_Pricing_Attr.Get_Charge_Name(qal.list_header_id, qal.charge_type_code, qal.charge_subtype_code, qal.list_line_type_code) CHARGE_NAME, QP_QP_Form_Pricing_Attr.Get_Formula(qal.price_by_formula_id) FORMULA, QP_QP_Form_Pricing_Attr.Get_Meaning(qal.arithmetic_operator, 'ARITHMETIC_OPERATOR') ARITHMETIC_OPERATOR_TYPE, decode(qal.list_line_type_code, 'DIS', qal.expiration_date, NULL) EXPIRATION_DATE, decode(qal.list_line_type_code, 'DIS', qal.expiration_period_start_date, NULL) EXP_PERIOD_START_DATE, decode(qal.list_line_type_code, 'DIS', qal.number_expiration_periods, NULL) NO_EXP_PERIODS, decode(qal.list_line_type_code, 'DIS', qal.expiration_period_uom, NULL) EXP_PERIOD_UOM, decode(qal.list_line_type_code, 'CIE', qal.expiration_date, NULL) COUP_EXP_DATE, decode(qal.list_line_type_code, 'CIE', qal.expiration_period_start_date, NULL) COUP_EXP_PRD_START_DATE, decode(qal.list_line_type_code, 'CIE', qal.number_expiration_periods, NULL) COUP_NO_EXP_PRDS, decode(qal.list_line_type_code, 'CIE', qal.expiration_period_uom, NULL) COUP_EXPIRATION_PERIOD_UOM, decode(qal.list_line_type_code, 'PBH', qal.expiration_date, NULL) BRK_EXPIRATION_DATE, decode(qal.list_line_type_code, 'PBH', qal.expiration_period_start_date, NULL) BRK_EXP_PRD_START_DATE, decode(qal.list_line_type_code, 'PBH', qal.number_expiration_periods, NULL) BRK_NO_EXPIRATION_PRDS, decode(qal.list_line_type_code, 'PBH', qal.expiration_period_uom, NULL) BRK_EXP_PERIOD_UOM, QP_QP_Form_Pricing_Attr.Get_Rebate_Txn_Type(qal.list_line_id, 'DIS', qal.list_line_type_code, qal.rebate_transaction_type_code) REBATE_TRANSACTION_TYPE, QP_QP_Form_Pricing_Attr.Get_Rebate_Txn_Type(qal.list_line_id, 'PBH', qal.list_line_type_code, qal.rebate_transaction_type_code) BRK_REB_TRANSACTION_TYPE, decode(qal.list_line_type_code, 'DIS', qal.benefit_qty, NULL) BENEFIT_QTY, decode(qal.list_line_type_code, 'DIS', qal.benefit_uom_code, NULL) BENEFIT_UOM_CODE, decode(qal.list_line_type_code, 'CIE', qal.benefit_qty, NULL) COUP_BENEFIT_QTY, decode(qal.list_line_type_code, 'CIE', qal.benefit_uom_code, NULL) COUP_BENEFIT_UOM_CODE, QP_QP_Form_Pricing_Attr.Get_Benefit_List_Line_No(qal.list_line_id, qal.list_line_type_code) COUP_LIST_LINE_NO, decode(qal.list_line_type_code, 'DIS', qal.accrual_flag, 'N') ACCRUAL_FLAG, decode(qal.list_line_type_code, 'PBH', qal.accrual_flag, 'N') BRK_ACCRUAL_FLAG, decode(qal.list_line_type_code, 'DIS', qal.accrual_conversion_rate, NULL) ACCRUAL_CONVERSION_RATE, decode(qal.list_line_type_code, 'CIE', qal.accrual_conversion_rate, NULL) COUP_ACCRUAL_CONV_RATE, decode(qal.list_line_type_code, 'CIE', qal.estim_accrual_rate, NULL) COUP_ESTIM_ACCRUAL_RATE, decode(qal.list_line_type_code, 'PBH', qal.accrual_conversion_rate, NULL) BRK_ACCRUAL_CONV_RATE, decode(qal.list_line_type_code, 'DIS', qal.estim_accrual_rate, NULL) ESTIM_ACCRUAL_RATE, decode(qal.list_line_type_code, 'PBH', qal.estim_accrual_rate, NULL) BRK_ESTIM_ACCRUAL_RATE, NULL BREAK_LINE_TYPE_CODE, NULL BREAK_LINE_TYPE, NULL PRODUCT_ID, NULL DESCRIPTION, QP_QP_Form_Pricing_Attr.Get_Segment_Name('QP_ATTR_DEFNS_PRICING', qapa.pricing_attribute_context, qapa.pricing_attribute) PRICING_ATTR_SEG_NAME, QP_QP_Form_Pricing_Attr.Get_Segment_Name('QP_ATTR_DEFNS_PRICING', qapa.product_attribute_context, product_attribute) PROD_ATTR_SEGMENT_NAME, QP_Price_List_Line_Util.Get_Product_Value('QP_ATTR_DEFNS_PRICING', 'ITEM', 'PRICING_ATTRIBUTE1', qal.related_item_id) RELATED_ITEM, QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_QUALIFIER', qal.substitution_context, qal.substitution_attribute) SUBSTITUTION_ATTRIBUTE, QP_QP_Form_Pricing_Attr.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER', qal.substitution_context, qal.substitution_attribute, qal.substitution_value) SUBSTITUTION_VALUE, QP_QP_Form_Pricing_Attr.Get_Segment_Name('QP_ATTR_DEFNS_QUALIFIER', qal.substitution_context, qal.substitution_attribute) SUB_SEGMENT_NAME, QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING', qapa.product_attribute_context, qapa.product_attribute) PRODUCT_ATTRIBUTE_TYPE, QP_Price_List_Line_Util.Get_Product_Value('QP_ATTR_DEFNS_PRICING', qapa.product_attribute_context,qapa.product_attribute, qapa.product_attr_value) PRODUCT_ATTR_VALUE, QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING', qapa.pricing_attribute_context, qapa.pricing_attribute) PRICING_ATTRIBUTE, qal.net_amount_flag NET_AMOUNT_FLAG, QAL.ACCUM_ATTRIBUTE ACCUM_ATTRIBUTE, QAL.ARCH_PURG_REQUEST_ID ARCH_PURG_REQUEST_ID, QAL.CONTINUOUS_PRICE_BREAK_FLAG FROM QP_ARCH_LIST_LINES QAL, QP_ARCH_PRICING_ATTRIBUTES QAPA WHERE qal.pricing_phase_id > 1 and qal.qualification_ind in (0, 2,4, 6, 8, 10, 12, 14, 16, 18, 20, 22, 24, 26, 28, 30, 32) and qal.list_line_id = qapa.list_line_id(+) and QAL.ARCH_PURG_REQUEST_ID = QAPA.ARCH_PURG_REQUEST_ID and (qapa.pricing_attribute_context = 'VOLUME' or qapa.pricing_attribute_context is null)

View Text - HTML Formatted

SELECT QAL.ROWID ROW_ID
, QAL.LIST_LINE_ID LIST_LINE_ID
, QAL.CREATION_DATE CREATION_DATE
, QAL.CREATED_BY CREATED_BY
, QAL.LAST_UPDATE_DATE LATE_UPDATE_DATE
, QAL.LAST_UPDATED_BY LAST_UPDATED_BY
, QAL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QAL.PROGRAM_APPLICATION_ID
, QAL.PROGRAM_ID
, QAL.PROGRAM_UPDATE_DATE
, QAL.REQUEST_ID
, QAL.LIST_HEADER_ID
, QAL.LIST_LINE_TYPE_CODE
, QAL.AUTOMATIC_FLAG
, QAL.MODIFIER_LEVEL_CODE
, QAL.LIST_PRICE
, QAL.LIST_PRICE_UOM_CODE
, QAL.PRIMARY_UOM_FLAG
, QAL.INVENTORY_ITEM_ID
, QAL.ORGANIZATION_ID
, QAL.RELATED_ITEM_ID
, QAL.RELATIONSHIP_TYPE_ID
, QAL.SUBSTITUTION_CONTEXT
, QAL.SUBSTITUTION_ATTRIBUTE
, QAL.SUBSTITUTION_VALUE
, QAL.REVISION
, QAL.REVISION_DATE
, QAL.REVISION_REASON_CODE
, QAL.CONTEXT
, QAL.ATTRIBUTE1
, QAL.ATTRIBUTE2
, QAL.COMMENTS
, QAL.ATTRIBUTE3
, QAL.ATTRIBUTE4
, QAL.ATTRIBUTE5
, QAL.ATTRIBUTE6
, QAL.ATTRIBUTE7
, QAL.ATTRIBUTE8
, QAL.ATTRIBUTE9
, QAL.ATTRIBUTE10
, QAL.INCLUDE_ON_RETURNS_FLAG
, QAL.ATTRIBUTE11
, QAL.ATTRIBUTE12
, QAL.ATTRIBUTE13
, QAL.ATTRIBUTE14
, QAL.ATTRIBUTE15
, QAL.PRICE_BREAK_TYPE_CODE
, QAL.PERCENT_PRICE
, QAL.EFFECTIVE_PERIOD_UOM
, QAL.NUMBER_EFFECTIVE_PERIODS
, QAL.OPERAND
, QAL.ARITHMETIC_OPERATOR
, QAL.OVERRIDE_FLAG
, QAL.PRINT_ON_INVOICE_FLAG
, QAL.REBATE_TRANSACTION_TYPE_CODE
, QAL.ESTIM_ACCRUAL_RATE
, QAL.PRICE_BY_FORMULA_ID
, QAL.GENERATE_USING_FORMULA_ID
, QAL.START_DATE_ACTIVE
, QAL.END_DATE_ACTIVE
, QAL.REPRICE_FLAG
, QAL.ACCRUAL_FLAG
, QAL.PRICING_GROUP_SEQUENCE
, QAL.INCOMPATIBILITY_GRP_CODE
, QAL.LIST_LINE_NO
, QAL.PRODUCT_PRECEDENCE
, QAL.PRICING_PHASE_ID
, QAL.EXPIRATION_PERIOD_START_DATE
, QAL.NUMBER_EXPIRATION_PERIODS
, QAL.EXPIRATION_PERIOD_UOM
, QAL.EXPIRATION_DATE
, QAL.ESTIM_GL_VALUE
, QAL.ACCRUAL_CONVERSION_RATE
, QAL.BENEFIT_PRICE_LIST_LINE_ID
, QAL.PRORATION_TYPE_CODE
, QAL.BENEFIT_QTY
, QAL.BENEFIT_UOM_CODE
, QAL.CHARGE_TYPE_CODE
, QAL.CHARGE_SUBTYPE_CODE
, QAL.BENEFIT_LIMIT
, QAPA.PRICING_ATTRIBUTE_ID
, QAPA.PRODUCT_ATTRIBUTE_CONTEXT
, QAPA.PRODUCT_ATTRIBUTE
, QAPA.PRODUCT_ATTR_VALUE
, QAPA.PRODUCT_UOM_CODE
, QAPA.COMPARISON_OPERATOR_CODE
, QAPA.PRICING_ATTRIBUTE_CONTEXT
, QAPA.PRICING_ATTRIBUTE
, QAPA.PRICING_ATTR_VALUE_FROM
, QAPA.PRICING_ATTR_VALUE_TO
, QAPA.PRICING_ATTRIBUTE_DATATYPE
, QAPA.PRODUCT_ATTRIBUTE_DATATYPE
, QAPA.EXCLUDER_FLAG
, QAPA.ATTRIBUTE_GROUPING_NO
, QAL.LIST_LINE_ID PARENT_LIST_LINE_ID
, NULL TO_RLTD_MODIFIER_ID
, NULL RLTD_MODIFIER_GRP_NO
, NULL RLTD_MODIFIER_GRP_TYPE
, NULL RLTD_MODIFIER_ID
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QAL.PRORATION_TYPE_CODE
, 'PRORATION_TYPE') PRORATION_TYPE
, QP_QP_FORM_PRICING_ATTR.GET_PRICING_PHASE(QAL.PRICING_PHASE_ID) PRICING_PHASE
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QAL.INCOMPATIBILITY_GRP_CODE
, 'INCOMPATIBILITY_GROUPS') INCOMPATIBILITY_GRP
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QAL.MODIFIER_LEVEL_CODE
, 'MODIFIER_LEVEL_CODE') MODIFIER_LEVEL
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QAL.LIST_LINE_TYPE_CODE
, 'LIST_LINE_TYPE_CODE') LIST_LINE_TYPE
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QAL.PRICE_BREAK_TYPE_CODE
, 'PRICE_BREAK_TYPE_CODE') PRICE_BREAK_TYPE
, QP_QP_FORM_PRICING_ATTR.GET_CHARGE_NAME(QAL.LIST_HEADER_ID
, QAL.CHARGE_TYPE_CODE
, QAL.CHARGE_SUBTYPE_CODE
, QAL.LIST_LINE_TYPE_CODE) CHARGE_NAME
, QP_QP_FORM_PRICING_ATTR.GET_FORMULA(QAL.PRICE_BY_FORMULA_ID) FORMULA
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QAL.ARITHMETIC_OPERATOR
, 'ARITHMETIC_OPERATOR') ARITHMETIC_OPERATOR_TYPE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.EXPIRATION_DATE
, NULL) EXPIRATION_DATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.EXPIRATION_PERIOD_START_DATE
, NULL) EXP_PERIOD_START_DATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.NUMBER_EXPIRATION_PERIODS
, NULL) NO_EXP_PERIODS
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.EXPIRATION_PERIOD_UOM
, NULL) EXP_PERIOD_UOM
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'CIE'
, QAL.EXPIRATION_DATE
, NULL) COUP_EXP_DATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'CIE'
, QAL.EXPIRATION_PERIOD_START_DATE
, NULL) COUP_EXP_PRD_START_DATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'CIE'
, QAL.NUMBER_EXPIRATION_PERIODS
, NULL) COUP_NO_EXP_PRDS
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'CIE'
, QAL.EXPIRATION_PERIOD_UOM
, NULL) COUP_EXPIRATION_PERIOD_UOM
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'PBH'
, QAL.EXPIRATION_DATE
, NULL) BRK_EXPIRATION_DATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'PBH'
, QAL.EXPIRATION_PERIOD_START_DATE
, NULL) BRK_EXP_PRD_START_DATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'PBH'
, QAL.NUMBER_EXPIRATION_PERIODS
, NULL) BRK_NO_EXPIRATION_PRDS
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'PBH'
, QAL.EXPIRATION_PERIOD_UOM
, NULL) BRK_EXP_PERIOD_UOM
, QP_QP_FORM_PRICING_ATTR.GET_REBATE_TXN_TYPE(QAL.LIST_LINE_ID
, 'DIS'
, QAL.LIST_LINE_TYPE_CODE
, QAL.REBATE_TRANSACTION_TYPE_CODE) REBATE_TRANSACTION_TYPE
, QP_QP_FORM_PRICING_ATTR.GET_REBATE_TXN_TYPE(QAL.LIST_LINE_ID
, 'PBH'
, QAL.LIST_LINE_TYPE_CODE
, QAL.REBATE_TRANSACTION_TYPE_CODE) BRK_REB_TRANSACTION_TYPE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.BENEFIT_QTY
, NULL) BENEFIT_QTY
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.BENEFIT_UOM_CODE
, NULL) BENEFIT_UOM_CODE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'CIE'
, QAL.BENEFIT_QTY
, NULL) COUP_BENEFIT_QTY
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'CIE'
, QAL.BENEFIT_UOM_CODE
, NULL) COUP_BENEFIT_UOM_CODE
, QP_QP_FORM_PRICING_ATTR.GET_BENEFIT_LIST_LINE_NO(QAL.LIST_LINE_ID
, QAL.LIST_LINE_TYPE_CODE) COUP_LIST_LINE_NO
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.ACCRUAL_FLAG
, 'N') ACCRUAL_FLAG
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'PBH'
, QAL.ACCRUAL_FLAG
, 'N') BRK_ACCRUAL_FLAG
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.ACCRUAL_CONVERSION_RATE
, NULL) ACCRUAL_CONVERSION_RATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'CIE'
, QAL.ACCRUAL_CONVERSION_RATE
, NULL) COUP_ACCRUAL_CONV_RATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'CIE'
, QAL.ESTIM_ACCRUAL_RATE
, NULL) COUP_ESTIM_ACCRUAL_RATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'PBH'
, QAL.ACCRUAL_CONVERSION_RATE
, NULL) BRK_ACCRUAL_CONV_RATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'DIS'
, QAL.ESTIM_ACCRUAL_RATE
, NULL) ESTIM_ACCRUAL_RATE
, DECODE(QAL.LIST_LINE_TYPE_CODE
, 'PBH'
, QAL.ESTIM_ACCRUAL_RATE
, NULL) BRK_ESTIM_ACCRUAL_RATE
, NULL BREAK_LINE_TYPE_CODE
, NULL BREAK_LINE_TYPE
, NULL PRODUCT_ID
, NULL DESCRIPTION
, QP_QP_FORM_PRICING_ATTR.GET_SEGMENT_NAME('QP_ATTR_DEFNS_PRICING'
, QAPA.PRICING_ATTRIBUTE_CONTEXT
, QAPA.PRICING_ATTRIBUTE) PRICING_ATTR_SEG_NAME
, QP_QP_FORM_PRICING_ATTR.GET_SEGMENT_NAME('QP_ATTR_DEFNS_PRICING'
, QAPA.PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE) PROD_ATTR_SEGMENT_NAME
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, 'ITEM'
, 'PRICING_ATTRIBUTE1'
, QAL.RELATED_ITEM_ID) RELATED_ITEM
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_QUALIFIER'
, QAL.SUBSTITUTION_CONTEXT
, QAL.SUBSTITUTION_ATTRIBUTE) SUBSTITUTION_ATTRIBUTE
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_QUALIFIER'
, QAL.SUBSTITUTION_CONTEXT
, QAL.SUBSTITUTION_ATTRIBUTE
, QAL.SUBSTITUTION_VALUE) SUBSTITUTION_VALUE
, QP_QP_FORM_PRICING_ATTR.GET_SEGMENT_NAME('QP_ATTR_DEFNS_QUALIFIER'
, QAL.SUBSTITUTION_CONTEXT
, QAL.SUBSTITUTION_ATTRIBUTE) SUB_SEGMENT_NAME
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QAPA.PRODUCT_ATTRIBUTE_CONTEXT
, QAPA.PRODUCT_ATTRIBUTE) PRODUCT_ATTRIBUTE_TYPE
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, QAPA.PRODUCT_ATTRIBUTE_CONTEXT
, QAPA.PRODUCT_ATTRIBUTE
, QAPA.PRODUCT_ATTR_VALUE) PRODUCT_ATTR_VALUE
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QAPA.PRICING_ATTRIBUTE_CONTEXT
, QAPA.PRICING_ATTRIBUTE) PRICING_ATTRIBUTE
, QAL.NET_AMOUNT_FLAG NET_AMOUNT_FLAG
, QAL.ACCUM_ATTRIBUTE ACCUM_ATTRIBUTE
, QAL.ARCH_PURG_REQUEST_ID ARCH_PURG_REQUEST_ID
, QAL.CONTINUOUS_PRICE_BREAK_FLAG
FROM QP_ARCH_LIST_LINES QAL
, QP_ARCH_PRICING_ATTRIBUTES QAPA
WHERE QAL.PRICING_PHASE_ID > 1
AND QAL.QUALIFICATION_IND IN (0
, 2
, 4
, 6
, 8
, 10
, 12
, 14
, 16
, 18
, 20
, 22
, 24
, 26
, 28
, 30
, 32)
AND QAL.LIST_LINE_ID = QAPA.LIST_LINE_ID(+)
AND QAL.ARCH_PURG_REQUEST_ID = QAPA.ARCH_PURG_REQUEST_ID
AND (QAPA.PRICING_ATTRIBUTE_CONTEXT = 'VOLUME' OR QAPA.PRICING_ATTRIBUTE_CONTEXT IS NULL)