CJM_XLA_SUPP_CLAIM_LINES

Details

Schema: FUSION
Object owner: CJM
Object type: VIEW

Columns

Name
EVENT_ID LINE_NUMBER DISTRIBUTION_TYPE_CLAIM DISTRIBUTION_ID_CLAIM CLAIM_LINE_ID UTILIZATION_ID CLAIM_LINE_AMOUNT CLAIM_LINE_LEDGER_AMOUNT CLAIM_LINE_UTIL_AMOUNT CLAIM_LINE_UTIL_LEDGER_AMOUNT UTILIZATION_LEDGER_AMOUNT GAIN_LOSS_LEDGER_AMOUNT GAIN_LOSS_AMOUNT ACTIVITY_TYPE_CODE ACTIVITY_ID ITEM_LEVEL_CODE ITEM_ID ITEM_NUMBER UTIL_PROGRAM_TEMPLATE_ID UTIL_PROGRAM_TYPE_ID UTIL_PROGRAM_CODE UTIL_PROGRAM_LINE_ID UTIL_UTILIZATION_TYPE UTIL_ADJUSTMENT_TYPE UTIL_ADJUSTMENT_TYPE_ID UTIL_OBJECT_TYPE UTIL_OBJECT_ID UTIL_OBJECT_LINE_ID UTIL_SHIPMENT_DATE UTIL_SHIPMENT_NUMBER UTIL_INVOICE_DATE UTIL_INVOICE_NUMBER UTIL_INVOICE_ID UTIL_INVOICE_SOURCE_CODE UTIL_AUTHORIZATION_NUMBER UTIL_WAYBILL_NUMBER UTIL_ITEM_ID UTIL_ITEM_LEVEL_CODE UTIL_EXCHANGE_RATE_DATE UTIL_EXCHANGE_RATE_TYPE UTIL_EXCHANGE_RATE UTIL_CUSTOMER_TRX_LINE_ID UTIL_PAYABLES_INVOICE_DATE UTIL_PAYABLES_INVOICE_NUMBER UTIL_PAYABLES_INVOICE_ID UTIL_PAYABLES_INVOICE_SOURCE UTIL_PAYABLES_INV_LINE_NUMBER SEEDED_PROGRAM_TYPE_CODE UTIL_RECEIPT_ID UTIL_RECEIPT_NUMBER UTIL_PO_HEADER_ID UTIL_PO_NUMBER UTIL_PGM_HEADER_ATTRIB_CATGORY UTIL_PGM_HEADER_ATTRIB_1 UTIL_PGM_HEADER_ATTRIB_2 UTIL_PGM_HEADER_ATTRIB_3 UTIL_PGM_HEADER_ATTRIB_4 UTIL_PGM_HEADER_ATTRIB_5 UTIL_PGM_HEADER_ATTRIB_6 UTIL_PGM_HEADER_ATTRIB_7 UTIL_PGM_HEADER_ATTRIB_8 UTIL_PGM_HEADER_ATTRIB_9 UTIL_PGM_HEADER_ATTRIB_10 UTIL_PGM_HEADER_ATTRIB_11 UTIL_PGM_HEADER_ATTRIB_12 UTIL_PGM_HEADER_ATTRIB_13 UTIL_PGM_HEADER_ATTRIB_14 UTIL_PGM_HEADER_ATTRIB_15 UTIL_PGM_HEADER_ATTRIB_16 UTIL_PGM_HEADER_ATTRIB_17 UTIL_PGM_HEADER_ATTRIB_18 UTIL_PGM_HEADER_ATTRIB_19 UTIL_PGM_HEADER_ATTRIB_20 UTIL_PGM_HEADER_ATTRIB_NUM_1 UTIL_PGM_HEADER_ATTRIB_NUM_2 UTIL_PGM_HEADER_ATTRIB_NUM_3 UTIL_PGM_HEADER_ATTRIB_NUM_4 UTIL_PGM_HEADER_ATTRIB_NUM_5 UTIL_PGM_HEADER_ATTRIB_NUM_6 UTIL_PGM_HEADER_ATTRIB_NUM_7 UTIL_PGM_HEADER_ATTRIB_NUM_8 UTIL_PGM_HEADER_ATTRIB_NUM_9 UTIL_PGM_HEADER_ATTRIB_NUM_10 UTIL_PGM_HEADER_ATTRIB_DATE_1 UTIL_PGM_HEADER_ATTRIB_DATE_2 UTIL_PGM_HEADER_ATTRIB_DATE_3 UTIL_PGM_HEADER_ATTRIB_DATE_4 UTIL_PGM_HEADER_ATTRIB_DATE_5

Name

EVENT_ID

LINE_NUMBER

DISTRIBUTION_TYPE_CLAIM

DISTRIBUTION_ID_CLAIM

CLAIM_LINE_ID

UTILIZATION_ID

CLAIM_LINE_AMOUNT

CLAIM_LINE_LEDGER_AMOUNT

CLAIM_LINE_UTIL_AMOUNT

CLAIM_LINE_UTIL_LEDGER_AMOUNT

UTILIZATION_LEDGER_AMOUNT

GAIN_LOSS_LEDGER_AMOUNT

GAIN_LOSS_AMOUNT

ACTIVITY_TYPE_CODE

ACTIVITY_ID

ITEM_LEVEL_CODE

ITEM_ID

ITEM_NUMBER

UTIL_PROGRAM_TEMPLATE_ID

UTIL_PROGRAM_TYPE_ID

UTIL_PROGRAM_CODE

UTIL_PROGRAM_LINE_ID

UTIL_UTILIZATION_TYPE

UTIL_ADJUSTMENT_TYPE

UTIL_ADJUSTMENT_TYPE_ID

UTIL_OBJECT_TYPE

UTIL_OBJECT_ID

UTIL_OBJECT_LINE_ID

UTIL_SHIPMENT_DATE

UTIL_SHIPMENT_NUMBER

UTIL_INVOICE_DATE

UTIL_INVOICE_NUMBER

UTIL_INVOICE_ID

UTIL_INVOICE_SOURCE_CODE

UTIL_AUTHORIZATION_NUMBER

UTIL_WAYBILL_NUMBER

UTIL_ITEM_ID

UTIL_ITEM_LEVEL_CODE

UTIL_EXCHANGE_RATE_DATE

UTIL_EXCHANGE_RATE_TYPE

UTIL_EXCHANGE_RATE

UTIL_CUSTOMER_TRX_LINE_ID

UTIL_PAYABLES_INVOICE_DATE

UTIL_PAYABLES_INVOICE_NUMBER

UTIL_PAYABLES_INVOICE_ID

UTIL_PAYABLES_INVOICE_SOURCE

UTIL_PAYABLES_INV_LINE_NUMBER

SEEDED_PROGRAM_TYPE_CODE

UTIL_RECEIPT_ID

UTIL_RECEIPT_NUMBER

UTIL_PO_HEADER_ID

UTIL_PO_NUMBER

UTIL_PGM_HEADER_ATTRIB_CATGORY

UTIL_PGM_HEADER_ATTRIB_1

UTIL_PGM_HEADER_ATTRIB_2

UTIL_PGM_HEADER_ATTRIB_3

UTIL_PGM_HEADER_ATTRIB_4

UTIL_PGM_HEADER_ATTRIB_5

UTIL_PGM_HEADER_ATTRIB_6

UTIL_PGM_HEADER_ATTRIB_7

UTIL_PGM_HEADER_ATTRIB_8

UTIL_PGM_HEADER_ATTRIB_9

UTIL_PGM_HEADER_ATTRIB_10

UTIL_PGM_HEADER_ATTRIB_11

UTIL_PGM_HEADER_ATTRIB_12

UTIL_PGM_HEADER_ATTRIB_13

UTIL_PGM_HEADER_ATTRIB_14

UTIL_PGM_HEADER_ATTRIB_15

UTIL_PGM_HEADER_ATTRIB_16

UTIL_PGM_HEADER_ATTRIB_17

UTIL_PGM_HEADER_ATTRIB_18

UTIL_PGM_HEADER_ATTRIB_19

UTIL_PGM_HEADER_ATTRIB_20

UTIL_PGM_HEADER_ATTRIB_NUM_1

UTIL_PGM_HEADER_ATTRIB_NUM_2

UTIL_PGM_HEADER_ATTRIB_NUM_3

UTIL_PGM_HEADER_ATTRIB_NUM_4

UTIL_PGM_HEADER_ATTRIB_NUM_5

UTIL_PGM_HEADER_ATTRIB_NUM_6

UTIL_PGM_HEADER_ATTRIB_NUM_7

UTIL_PGM_HEADER_ATTRIB_NUM_8

UTIL_PGM_HEADER_ATTRIB_NUM_9

UTIL_PGM_HEADER_ATTRIB_NUM_10

UTIL_PGM_HEADER_ATTRIB_DATE_1

UTIL_PGM_HEADER_ATTRIB_DATE_2

UTIL_PGM_HEADER_ATTRIB_DATE_3

UTIL_PGM_HEADER_ATTRIB_DATE_4

UTIL_PGM_HEADER_ATTRIB_DATE_5

Query

SQL_Statement
SELECT /+ leading(XEG) use_nl(XEG OXH)/ xeg.event_id event_id, oxl.line_number line_number, 'SUPPLIER_CLAIM_SETTLEMENT' distribution_type_claim, clu.claim_line_util_id distribution_id_claim, clu.claim_line_id claim_line_id, util.utilization_id utilization_id, cln.amount claim_line_amount, cln.acctd_amount claim_line_ledger_amount, clu.amount claim_line_util_amount, clu.acctd_amount claim_line_util_ledger_amount, clu.utilized_acctd_amount utilization_ledger_amount, clu.fxgl_acctd_amount gain_loss_ledger_amount, 0 gain_loss_amount, cln.activity_type_code activity_type_code, cln.activity_id activity_id, cln.item_level_code item_level_code, cln.item_id item_id, CJM_UTILITY_PKG.get_item_name(cln.item_level_code,cln.item_id,cln.bu_id) item_number, template_b.program_type_id util_program_template_id, ptype_b.program_type_id util_program_type_id, pgm_b.program_code util_program_code, util.program_line_id util_program_line_id, util.utilization_type util_utilization_type, util.adjustment_type util_adjustment_type, util.adjustment_type_id util_adjustment_type_id, util.object_type util_object_type, util.object_id util_object_id, util.object_line_id util_object_line_id, util.shipment_date util_shipment_date, util.shipment_number util_shipment_number, DECODE(util.invoice_source_application,'AR',util.invoice_date, NULL) util_invoice_date, DECODE(util.invoice_source_application,'AR',util.invoice_number, NULL) util_invoice_number, DECODE(util.invoice_source_application,'AR',util.invoice_id, NULL) util_invoice_id, DECODE(util.invoice_source_application,'AR',util.invoice_source_code, NULL) util_invoice_source_code, pgm_b.authorization_number util_authorization_number, util.waybill_number util_waybill_number, util.item_id util_item_id, util.item_level_code util_item_level_code, util.exchange_rate_date util_exchange_rate_date, util.exchange_rate_type util_exchange_rate_type, util.exchange_rate util_exchange_rate, DECODE(util.invoice_source_application,'AR',util.customer_trx_line_id, NULL) util_customer_trx_line_id, DECODE(util.invoice_source_application,'AP',util.invoice_date, NULL) util_payables_invoice_date, DECODE(util.invoice_source_application,'AP',util.invoice_number, NULL) util_payables_invoice_number, DECODE(util.invoice_source_application,'AP',util.invoice_id, NULL) util_payables_invoice_id, DECODE(util.invoice_source_application,'AP',util.invoice_source_code, NULL) util_payables_invoice_source, DECODE(util.invoice_source_application,'AP',util.customer_trx_line_id, NULL) util_payables_inv_line_number, util.seeded_program_type_code seeded_program_type_code, DECODE(util.seeded_program_type_code,'SUPPLIER_REBATE',util.receipt_id,NULL) util_receipt_id, DECODE(util.seeded_program_type_code,'SUPPLIER_REBATE',util.receipt_number,NULL) util_receipt_number, DECODE(util.seeded_program_type_code,'SUPPLIER_REBATE',util.po_header_id,NULL) util_po_header_id, DECODE(util.seeded_program_type_code,'SUPPLIER_REBATE',util.po_number,NULL) util_po_number, pgm_b.ATTRIBUTE_CATEGORY UTIL_PGM_HEADER_ATTRIB_CATGORY , pgm_b.ATTRIBUTE_CHAR1 UTIL_PGM_HEADER_ATTRIB_1 , pgm_b.ATTRIBUTE_CHAR2 UTIL_PGM_HEADER_ATTRIB_2 , pgm_b.ATTRIBUTE_CHAR3 UTIL_PGM_HEADER_ATTRIB_3 , pgm_b.ATTRIBUTE_CHAR4 UTIL_PGM_HEADER_ATTRIB_4 , pgm_b.ATTRIBUTE_CHAR5 UTIL_PGM_HEADER_ATTRIB_5 , pgm_b.ATTRIBUTE_CHAR6 UTIL_PGM_HEADER_ATTRIB_6 , pgm_b.ATTRIBUTE_CHAR7 UTIL_PGM_HEADER_ATTRIB_7 , pgm_b.ATTRIBUTE_CHAR8 UTIL_PGM_HEADER_ATTRIB_8 , pgm_b.ATTRIBUTE_CHAR9 UTIL_PGM_HEADER_ATTRIB_9 , pgm_b.ATTRIBUTE_CHAR10 UTIL_PGM_HEADER_ATTRIB_10 , pgm_b.ATTRIBUTE_CHAR11 UTIL_PGM_HEADER_ATTRIB_11 , pgm_b.ATTRIBUTE_CHAR12 UTIL_PGM_HEADER_ATTRIB_12 , pgm_b.ATTRIBUTE_CHAR13 UTIL_PGM_HEADER_ATTRIB_13 , pgm_b.ATTRIBUTE_CHAR14 UTIL_PGM_HEADER_ATTRIB_14 , pgm_b.ATTRIBUTE_CHAR15 UTIL_PGM_HEADER_ATTRIB_15 , pgm_b.ATTRIBUTE_CHAR16 UTIL_PGM_HEADER_ATTRIB_16 , pgm_b.ATTRIBUTE_CHAR17 UTIL_PGM_HEADER_ATTRIB_17 , pgm_b.ATTRIBUTE_CHAR18 UTIL_PGM_HEADER_ATTRIB_18 , pgm_b.ATTRIBUTE_CHAR19 UTIL_PGM_HEADER_ATTRIB_19 , pgm_b.ATTRIBUTE_CHAR20 UTIL_PGM_HEADER_ATTRIB_20 , pgm_b.ATTRIBUTE_NUMBER1 UTIL_PGM_HEADER_ATTRIB_NUM_1 , pgm_b.ATTRIBUTE_NUMBER2 UTIL_PGM_HEADER_ATTRIB_NUM_2 , pgm_b.ATTRIBUTE_NUMBER3 UTIL_PGM_HEADER_ATTRIB_NUM_3 , pgm_b.ATTRIBUTE_NUMBER4 UTIL_PGM_HEADER_ATTRIB_NUM_4 , pgm_b.ATTRIBUTE_NUMBER5 UTIL_PGM_HEADER_ATTRIB_NUM_5 , pgm_b.ATTRIBUTE_NUMBER6 UTIL_PGM_HEADER_ATTRIB_NUM_6 , pgm_b.ATTRIBUTE_NUMBER7 UTIL_PGM_HEADER_ATTRIB_NUM_7 , pgm_b.ATTRIBUTE_NUMBER8 UTIL_PGM_HEADER_ATTRIB_NUM_8 , pgm_b.ATTRIBUTE_NUMBER9 UTIL_PGM_HEADER_ATTRIB_NUM_9 , pgm_b.ATTRIBUTE_NUMBER10 UTIL_PGM_HEADER_ATTRIB_NUM_10 , pgm_b.ATTRIBUTE_DATE1 UTIL_PGM_HEADER_ATTRIB_DATE_1 , pgm_b.ATTRIBUTE_DATE2 UTIL_PGM_HEADER_ATTRIB_DATE_2 , pgm_b.ATTRIBUTE_DATE3 UTIL_PGM_HEADER_ATTRIB_DATE_3 , pgm_b.ATTRIBUTE_DATE4 UTIL_PGM_HEADER_ATTRIB_DATE_4 , pgm_b.ATTRIBUTE_DATE5 UTIL_PGM_HEADER_ATTRIB_DATE_5 FROM cjm_claims_all cla, cjm_claim_lines_all cln, cjm_claim_lines_util_all clu, cjm_programs_utilized_all_b util, cjm_xla_claim_lines oxl, cjm_xla_claim_headers oxh, cjm_programs_all_b pgm_b, cjm_program_types_b template_b, cjm_program_types_b ptype_b, xla_events_gt xeg WHERE xeg.entity_code = 'SUPPLIER_CLAIM_SETTLEMENT' AND cla.claim_for_code = 'SUPPLIER' AND xeg.application_id = 10566 AND xeg.source_id_int_1 = oxh.claim_id AND oxh.event_type_code = xeg.event_type_code AND xeg.event_id = oxh.event_id AND oxh.claim_id = cla.claim_id AND cla.claim_id = cln.claim_id AND cln.claim_line_id = clu.claim_line_id AND clu.utilization_id = util.utilization_id AND oxh.xla_claim_header_id = oxl.xla_claim_header_id AND oxl.claim_line_util_id = clu.claim_line_util_id AND util.program_header_id = pgm_b.program_header_id AND pgm_b.program_type_id = ptype_b.program_type_id AND ptype_b.parent_program_type_id = template_b.program_type_id

SQL_Statement

SELECT /*+ leading(XEG) use_nl(XEG OXH)*/

xeg.event_id event_id,

oxl.line_number line_number,

'SUPPLIER_CLAIM_SETTLEMENT' distribution_type_claim,

clu.claim_line_util_id distribution_id_claim,

clu.claim_line_id claim_line_id,

util.utilization_id utilization_id,

cln.amount claim_line_amount,

cln.acctd_amount claim_line_ledger_amount,

clu.amount claim_line_util_amount,

clu.acctd_amount claim_line_util_ledger_amount,

clu.utilized_acctd_amount utilization_ledger_amount,

clu.fxgl_acctd_amount gain_loss_ledger_amount,

0 gain_loss_amount,

cln.activity_type_code activity_type_code,

cln.activity_id activity_id,

cln.item_level_code item_level_code,

cln.item_id item_id,

CJM_UTILITY_PKG.get_item_name(cln.item_level_code,cln.item_id,cln.bu_id) item_number,

template_b.program_type_id util_program_template_id,

ptype_b.program_type_id util_program_type_id,

pgm_b.program_code util_program_code,

util.program_line_id util_program_line_id,

util.utilization_type util_utilization_type,

util.adjustment_type util_adjustment_type,

util.adjustment_type_id util_adjustment_type_id,

util.object_type util_object_type,

util.object_id util_object_id,

util.object_line_id util_object_line_id,

util.shipment_date util_shipment_date,

util.shipment_number util_shipment_number, DECODE(util.invoice_source_application,'AR',util.invoice_date, NULL) util_invoice_date,

DECODE(util.invoice_source_application,'AR',util.invoice_number, NULL) util_invoice_number,

DECODE(util.invoice_source_application,'AR',util.invoice_id, NULL) util_invoice_id,

DECODE(util.invoice_source_application,'AR',util.invoice_source_code, NULL) util_invoice_source_code,

pgm_b.authorization_number util_authorization_number,

util.waybill_number util_waybill_number,

util.item_id util_item_id,

util.item_level_code util_item_level_code,

util.exchange_rate_date util_exchange_rate_date,

util.exchange_rate_type util_exchange_rate_type,

util.exchange_rate util_exchange_rate,

DECODE(util.invoice_source_application,'AR',util.customer_trx_line_id, NULL) util_customer_trx_line_id,

DECODE(util.invoice_source_application,'AP',util.invoice_date, NULL) util_payables_invoice_date,

DECODE(util.invoice_source_application,'AP',util.invoice_number, NULL) util_payables_invoice_number,

DECODE(util.invoice_source_application,'AP',util.invoice_id, NULL) util_payables_invoice_id,

DECODE(util.invoice_source_application,'AP',util.invoice_source_code, NULL) util_payables_invoice_source,

DECODE(util.invoice_source_application,'AP',util.customer_trx_line_id, NULL) util_payables_inv_line_number,

util.seeded_program_type_code seeded_program_type_code,

DECODE(util.seeded_program_type_code,'SUPPLIER_REBATE',util.receipt_id,NULL) util_receipt_id,

DECODE(util.seeded_program_type_code,'SUPPLIER_REBATE',util.receipt_number,NULL) util_receipt_number,

DECODE(util.seeded_program_type_code,'SUPPLIER_REBATE',util.po_header_id,NULL) util_po_header_id,

DECODE(util.seeded_program_type_code,'SUPPLIER_REBATE',util.po_number,NULL) util_po_number,

pgm_b.ATTRIBUTE_CATEGORY UTIL_PGM_HEADER_ATTRIB_CATGORY ,

pgm_b.ATTRIBUTE_CHAR1 UTIL_PGM_HEADER_ATTRIB_1 ,

pgm_b.ATTRIBUTE_CHAR2 UTIL_PGM_HEADER_ATTRIB_2 ,

pgm_b.ATTRIBUTE_CHAR3 UTIL_PGM_HEADER_ATTRIB_3 ,

pgm_b.ATTRIBUTE_CHAR4 UTIL_PGM_HEADER_ATTRIB_4 ,

pgm_b.ATTRIBUTE_CHAR5 UTIL_PGM_HEADER_ATTRIB_5 ,

pgm_b.ATTRIBUTE_CHAR6 UTIL_PGM_HEADER_ATTRIB_6 ,

pgm_b.ATTRIBUTE_CHAR7 UTIL_PGM_HEADER_ATTRIB_7 ,

pgm_b.ATTRIBUTE_CHAR8 UTIL_PGM_HEADER_ATTRIB_8 ,

pgm_b.ATTRIBUTE_CHAR9 UTIL_PGM_HEADER_ATTRIB_9 ,

pgm_b.ATTRIBUTE_CHAR10 UTIL_PGM_HEADER_ATTRIB_10 ,

pgm_b.ATTRIBUTE_CHAR11 UTIL_PGM_HEADER_ATTRIB_11 ,

pgm_b.ATTRIBUTE_CHAR12 UTIL_PGM_HEADER_ATTRIB_12 ,

pgm_b.ATTRIBUTE_CHAR13 UTIL_PGM_HEADER_ATTRIB_13 ,

pgm_b.ATTRIBUTE_CHAR14 UTIL_PGM_HEADER_ATTRIB_14 ,

pgm_b.ATTRIBUTE_CHAR15 UTIL_PGM_HEADER_ATTRIB_15 ,

pgm_b.ATTRIBUTE_CHAR16 UTIL_PGM_HEADER_ATTRIB_16 ,

pgm_b.ATTRIBUTE_CHAR17 UTIL_PGM_HEADER_ATTRIB_17 ,

pgm_b.ATTRIBUTE_CHAR18 UTIL_PGM_HEADER_ATTRIB_18 ,

pgm_b.ATTRIBUTE_CHAR19 UTIL_PGM_HEADER_ATTRIB_19 ,

pgm_b.ATTRIBUTE_CHAR20 UTIL_PGM_HEADER_ATTRIB_20 ,

pgm_b.ATTRIBUTE_NUMBER1 UTIL_PGM_HEADER_ATTRIB_NUM_1 ,

pgm_b.ATTRIBUTE_NUMBER2 UTIL_PGM_HEADER_ATTRIB_NUM_2 ,

pgm_b.ATTRIBUTE_NUMBER3 UTIL_PGM_HEADER_ATTRIB_NUM_3 ,

pgm_b.ATTRIBUTE_NUMBER4 UTIL_PGM_HEADER_ATTRIB_NUM_4 ,

pgm_b.ATTRIBUTE_NUMBER5 UTIL_PGM_HEADER_ATTRIB_NUM_5 ,

pgm_b.ATTRIBUTE_NUMBER6 UTIL_PGM_HEADER_ATTRIB_NUM_6 ,

pgm_b.ATTRIBUTE_NUMBER7 UTIL_PGM_HEADER_ATTRIB_NUM_7 ,

pgm_b.ATTRIBUTE_NUMBER8 UTIL_PGM_HEADER_ATTRIB_NUM_8 ,

pgm_b.ATTRIBUTE_NUMBER9 UTIL_PGM_HEADER_ATTRIB_NUM_9 ,

pgm_b.ATTRIBUTE_NUMBER10 UTIL_PGM_HEADER_ATTRIB_NUM_10 ,

pgm_b.ATTRIBUTE_DATE1 UTIL_PGM_HEADER_ATTRIB_DATE_1 ,

pgm_b.ATTRIBUTE_DATE2 UTIL_PGM_HEADER_ATTRIB_DATE_2 ,

pgm_b.ATTRIBUTE_DATE3 UTIL_PGM_HEADER_ATTRIB_DATE_3 ,

pgm_b.ATTRIBUTE_DATE4 UTIL_PGM_HEADER_ATTRIB_DATE_4 ,

pgm_b.ATTRIBUTE_DATE5 UTIL_PGM_HEADER_ATTRIB_DATE_5

FROM

cjm_claims_all cla,

cjm_claim_lines_all cln,

cjm_claim_lines_util_all clu,

cjm_programs_utilized_all_b util,

cjm_xla_claim_lines oxl,

cjm_xla_claim_headers oxh,

cjm_programs_all_b pgm_b,

cjm_program_types_b template_b,

cjm_program_types_b ptype_b,

xla_events_gt xeg

WHERE xeg.entity_code = 'SUPPLIER_CLAIM_SETTLEMENT'

AND cla.claim_for_code = 'SUPPLIER'

AND xeg.application_id = 10566

AND xeg.source_id_int_1 = oxh.claim_id

AND oxh.event_type_code = xeg.event_type_code

AND xeg.event_id = oxh.event_id

AND oxh.claim_id = cla.claim_id

AND cla.claim_id = cln.claim_id

AND cln.claim_line_id = clu.claim_line_id

AND clu.utilization_id = util.utilization_id

AND oxh.xla_claim_header_id = oxl.xla_claim_header_id

AND oxl.claim_line_util_id = clu.claim_line_util_id

AND util.program_header_id = pgm_b.program_header_id

AND pgm_b.program_type_id = ptype_b.program_type_id

AND ptype_b.parent_program_type_id = template_b.program_type_id