Monday, 7 March 2016

AP Tables

select * from ap_invoices_all

select * from ap_invoice_lines_all

select * from ap_invoice_distributions_all

select * from ap_ae_headers_all

select * from ap_ae_lines_all

select * from ap_payment_schedules_all

select * from ap_invoice_payments_all

select * from ap_checks_all

select * from ap_check_formats

select * from ap_holds_all

select * from ap_terms

select * from ap_lookup_codes

select * from AP_INV_APRVL_HIST_ALL

select * from ap_selected_invoices_all

select * from AP_DOCUMENTS_PAYABLE

select * from ORG_ACCT_PERIODS

1 comment:

  1. You can run these queries using https://pi-cu.be/

    ReplyDelete

Useful fusion query for User access

  Table FUN_USER_ROLE_DATA_ASGNMNTS is used for “Manage data access for users”. it will store use and role assignment to data security. Tabl...