Getting duplicate records from AP subledger

Summary:

Getting duplicate records from AP subledger

Content (please ensure you mask any confidential information):

Hi All,

I have a requirement where i need to fetch the sub ledger accounting entries from Fusion. I have developed below query however; it is giving duplicate records.

Currently in Invoice screen there are we could see 5 accounting entries however in report it is coming duplicate

select
/* aia.INVOICE_ID,
aila.line_number,
aila.line_type_lookup_code /
xal.
from
ap_invoices_all aia,
ap_invoice_lines_all aila,
ap_invoice_distributions_all aida,
xla_transaction_entities xte,
xla_events xev,
xla_ae_headers xah,