AP Invoice Accounting Tracking

 Select *

from ap_invoices_all

where INVOICE_NUM='110120309';

Select *

from ap_invoice_lines_all

where invoice_id=10033;

Select *

from ap_invoice_distributions_all

where invoice_id=10033;--ACCOUNTING_EVENT_ID=43069,DIST_CODE_COMBINATION_ID=2044

Select *

from xla_ae_headers

where event_id=43069;--AE_HEADER_ID=10324

Select *

from xla_ae_lines

where AE_HEADER_ID=10324

and ACCOUNTING_CLASS_CODE='LIABILITY';--GL_SL_LINK_ID=10664

Select *

from ap_suppliers

where vendor_id=113;

select *

from ap_supplier_sites_all

where vendor_id=113

and vendor_site_id=116;