How can I get transaction_id from xla_accounting_errors

Hi everyone,

We have an instance with multiple operating units, different ledgers id. All our operations have transactions in  xla_accounting_errors. I created the next query to get those transactions

SELECT --xte.source_id_int_1,

xte.*

FROM xla_events xe,

  xla_accounting_errors xae,

  xla_transaction_entities_upg xte

WHERE xe.application_id = 707

AND xae.application_id  = 707

  --AND ENTITY_CODE  =

AND xe.event_id            = xae.event_id

AND xte.entity_id = xe.entity_id

AND xe.upg_batch_id       IS NULL

AND xae.message_number     = 95325

AND xae.ledger_id         IN ('2528')

AND xe.transaction_date   >= '01-JAN-2015'