ap_invoices_all a, ap_invoice_lines_all b, ap_invoice_distributions_all c, ap_invoice_payments_all d ,ap_checks_all e Joining's - Oracle EBS R12

https://aporaclepayables.blogspot.com/2018/09/apinvoicesall-apinvoicelinesall-b.html

select count(*) from ap_invoices_all a, ap_invoice_lines_all b, ap_invoice_distributions_all c,
ap_invoice_payments_all d ,ap_checks_all e
where a.INVOICE_ID=b.INVOICE_ID
and b.INVOICE_ID=c.INVOICE_ID
and a.INVOICE_ID=c.INVOICE_ID
and b.LINE_NUMBER=c.INVOICE_LINE_NUMBER
and d.INVOICE_ID=c.INVOICE_ID
and d.CHECK_ID=e.CHECK_id
and d.ORG_ID=c.ORG_ID
and a.ORG_ID=b.ORG_ID
and b.ORG_ID=c.ORG_ID
and a.ORG_ID=c.ORG_ID
and d.ORG_ID=e.ORG_ID
and c.ORG_ID=82
and a.ORG_ID=82
and b.ORG_ID=82
and d.ORG_ID=82
and e.ORG_ID=82
and d.REVERSAL_FLAG='N'