Cannot find invoice on ap_invoice_distributions_all table
Other than the AP_INVOICE_DISTRIBUTIONS_ALL table is there some place else I should be looking if I'm trying to create a query that gives me invoice header, lines and distribution details on invoices in a specific batch? If I join the AP_INVOICES_ALL and the AP_INVOICE_LINES_ALL table I can see all my invoices and all the lines on those invoices but when I add a join to the AP_INVOICE_DISTRIBUTIONS_ALL table some of the invoices disappear. I am using the INVOICE_ID to join all these tables together. What I don't understand is that if I navigate to the application and drill into the