Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Friday, April 26, 2013

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;
-------------------------------------

No comments:

Post a Comment