ap_ae_lines_all AND Source ID
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?