BANK Details

Dear All,

im trying to build a query to get :

Operating Unit Bank Name      

Branch Name Bank

Account Number Currency

GL Cash Account    

GL Clearing Account      

Active Date       

Inactive Date

but im dont know where these data are stored:

GL Cash Account    

GL Clearing Account      

Active Date       

Inactive Date

and below are my queries:

-----------------------------------------

select

o.name OU,

ABB.bank_name ,

Abb.BANK_BRANCH_NAME,

BAA.BANK_ACCOUNT_NUM,

BAA.currency_code,

BAA.account_type,

BAA.BANK_ACCOUNT_NAME_ALT

from

AP_BANK_BRANCHES ABB,

AP_BANK_ACCOUNTS_ALL BAA,

HR_ALL_ORGANIZATION_UNITS o,

ce_bank_acct_uses_all bau