Friday, 14 April 2017

Oracle Payable important tables in r12

select * from ap_batches_all

select * from ap_invoices_All

select * from ap_invoice_lines_all

select * from ap_holds_all

select * from ap_invoice_distributions_all

select * from ap_payment_Schedules_all

select * from ap_payment_history_all

select * from ap_checks_All

select * from ap_invoice_payments_all

select * from ce_bank_accounts

select * from ce_payment_documents

select * from iby_external_payees_all

select * from iby_pmt_instr_uses_All




No comments:

Post a Comment

GL Code combination query in oracle fusion

 select  gcc.Code_Combination_id Account_Code_Combination_Id, CONCATENATED_SEGMENTS Account_Code_Combination,  segment1, segment2, segment3,...