Following joins will helps to understand exact relation between iExpenses and AP invoices. 1 2 3 4 5 6 SELECT aerh.vouchno, aerh.report_header_id FROM ap_expense_report_headers_all aerh, ap_invoices_all ap WHERE aerh.expense_status_code = 'INVOICED' AND ap.invoice_id= aerh.vouchno; then […]