checking accounting detail based invoice number and its payment accounting details

select * from xla_ae_lines where ae_header_id in (select ae_header_id from
xla_ae_headers where event_id in ( select accounting_event_id from
ap_invoice_distributions_all where invoice_id in ( select invoice_id from
ap_invoices_all where invoice_num='200408-2127757' )));


select * from xla.XLA_TRIAL_BALANCES where ae_header_id = 455892602



(select ae_header_id from
xla_ae_headers where event_id in
(select accounting_event_id from ap_invoice_payments_all where invoice_id =15671141))