Payables and Cash Management - EBS (MOSC)

MOSC Banner

Cannot find invoice on ap_invoice_distributions_all table

edited Feb 5, 2016 4:04AM in Payables and Cash Management - EBS (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center