Payables and Cash Management - EBS (MOSC)

MOSC Banner

ap_ae_lines_all AND Source ID

edited Jan 13, 2011 8:28AM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered
In order to view Acounting Entry against an invoice Distribution, I need to make following join:

AP_INVOICE_DISTRIBUTIONS_ALL  <-> AP_ACCOUNTING_EVENTS_ALL (Based on Accounting_Event_ID)

AP_ACCOUNTING_EVENTS_ALL <-> AP_AE_HEADERS_ALL (Based on Accounting _Event_ID)

AP_AE_HEADERS_ALL <-> AP_AE_LINES_ALL (Based on AE_Header_ID)

and then Filter: where AP_AE_LINES_ALL . SOURCE_TABLE = 'AP_INVOICE_DISTRIBUTIONS'

and

AP_AE_LINES_ALL . SOURCE_ID = AP_INVOICE_DISTRIBUTIONS_ALL . INVOICE_DISTRIBUTION_ID

By doing that, few invoice distributions get eliminated becaise SOURCE_ID is not equal to INVOICE_DISTRIBUTION_ID but it stores INVOICE_ID... Why?

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