Hi,

You can run the following, it includes parameters for Ledger and event date but these can be commented out if that is what you need, source_id_int1 will be your customer_trx_id, cash_receipt_id etc:

SELECT xlt.source_id_int_1 id,

xlt.security_id_int_1 org_id,

xe.*

FROM apps.xla_events xe,

xla.xla_transaction_entities xlt

WHERE xe.entity_id = xlt.entity_id

AND xe.application_id =xlt.application_id

AND xlt.source_application_id = 222

AND xlt.ledger_id = &ledger_id

AND xe.event_date between to_date('&from_gl_date','DD-MON-YYYY')

and to_date('&to_gl_date','DD-MON-YYYY')

AND xe.process_status_code <> 'P'

AND xe.event_status_code <> 'P'

order by xe.event_date;

Thanks

Hanne