GL Journal Batch and Invoice Information
Hi All, Is there an Oracle General Ledger Seeded Report that basically shows the GL Journal batch and the invoices (from AP) inside of it. I've been trying to make a report by means of a script by joining GL_JE_BATCHES, AP_INVOICE_DISTRIBUTIONS_ALL, AND AP_INVOICES_ALL but its been running in almost 3 hours and i still haven't gotten a result. any ideas? thank you!