Cash Management tables in oracle fusion

Cash Management tables in oracle fusion

In this post , We will be discuss about Cash Management tables in oracle fusion. Cash management tables helps to store the bank related informations , bank statement informations and bank reconciliation informations in oracle fusion. I will share some of the most important cash management tables which we do use to develop the cash management related reports in oracle fusion. Here below i will share some of the most important cash management tables in oracle fusion.

Most Important Cash Management tables in oracle fusion

Here below is the most important cash Management tables in oracle fusion

1.CE_BANK_ACCOUNTS

2.CE_BANK_ACCT_USES_ALL

3.CE_STMT_BALANCES

4.CE_PAYMENT_DOCUMENTS

5.CE_STATEMENT_HEADERS

6.CE_STATEMENT_LINES

7.CE_ALL_BANK_BRANCHES_V

Detail SQL Query Using Cash Management tables in oracle fusion

Here below is the most important table uses to extract the internal bank informations in oracle fusion.

select b.BANK_NAME
from CE_BANK_ACCOUNTS A ,CE_BANKS_V B
WHERE a.bank_account_id IN (SELECT b.bank_account_id
                             FROM CE_BANK_ACCT_USES_ALL b
                             WHERE 1=1
                            --and b.org_id = mo_global.GET_CURRENT_ORG_ID
                             AND (NVL(AP_USE_ENABLE_FLAG,'N' ) = 'Y' OR NVL(AR_USE_ENABLE_FLAG,'N' ) = 'Y' ))
                             and B.BANK_PARTY_ID =A.BANK_ID
 ORDER BY a.bank_account_name;