R12 AP Tables

------------------------------------Vision Instance----------------------------------------------------------
--Supplier Interface tables
select * from ap_suppliers_int;

select * from ap_supplier_sites_int;

select * from ap_sup_site_contact_int;

select * from ap_supplier_int_rejections;
----------------------------------------
select * from AP_SUPPLIERS WHERE VENDOR_NAME = 'United Parcel Service';

SELECT *
  FROM AP_SUPPLIER_SITES_ALL
 where 1 = 1
   and vendor_id = 4
   and org_id = 204;

select * from ap_supplier_contacts where vendor_site_id = 2255;
-------------------------------------
select * from AP_INVOICES_INTERFACE;

select * from AP_INVOICE_LINES_INTERFACE where invoice_id = 298448;

select * from ap_interface_rejections;
-------------------------------------
select *
  from ap_invoices_all
 where vendor_id = 4
   and org_id = 204;

select * from ap_invoice_lines_all where invoice_id = 36111;

select *
  from ap_invoice_distributions_all
 where invoice_id = 36111
   and invoice_line_number = 1;

select * from xla_events where event_id = 37952;

select * from xla_transaction_entities where entity_id = 382849;

select * from xla_ae_headers where event_id = 37952;

select *
  from xla_ae_lines
 where ae_header_id = 1549493
   and ae_line_num = 1;

select *
  from gl_import_references
 where gl_sl_link_id = 142246
   and gl_sl_link_table = 'APECL';

select * from org_organization_definitions where organization_id = 204;

select * from gl_ledgers where ledger_id=1;

select * from gl_led;

select * from IBY_EXTERNAL_PAYEES_ALL where supplier_site_id = 4;

select * from zx_lines where trx_id = 36111;
----------------------------------------
select * from ap_invoice_payments_all where invoice_id = 36111;

select * from ap_payment_schedules_all where invoice_id = 36111;

select * from ap_checks_all where check_id = 19286;

select * from ce_bank_accounts where bank_account_id = 10001;
-------------------------------------