Wednesday, December 29, 2010
How Payable Invoices related Reconciliation and Currencies Data is stored in Oracle Apps R12? (Cash Management and General Ledger)
In this post, we will find the tables involved in storing the Reconciliation and Currency Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in R12.1.1 Instance.
Reconciliation - Tables Involved
SELECT DISTINCT cel.*
FROM CE_STATEMENT_LINES cel,
WHERE cel.statement_header_id = ceh.statement_header_id
AND ac.check_id = aip.check_id
AND aip.invoice_id = '166014'
AND aip.check_id = ac.check_id
AND ac.bank_account_id = ceh.bank_account_id
AND TO_CHAR(ac.check_number) = cel.bank_trx_number
AND csr.statement_line_id = cel.statement_line_id;
Currencies - Tables Involved
WHERE currency_code IN
FROM AP_INVOICES_ALL a
WHERE a.invoice_id = '166014'
FROM AP_INVOICES_ALL b
WHERE b.invoice_id = '166014'
FROM AP_SYSTEM_PARAMETERS_ALL c
WHERE NVL(c.org_id, -99) = '911'
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.