Important bank tables in R12
hi,
Please list down all the bank tables in R12.
I am not looking for HZ tables but the core bank tables.
I wish to take an extract of all banks, bank currencies, bank branches, bank accounts, the legal entity assigned to the bank, the operating units assigned to the bank etc.
If you have an SQL that would be great.
I am looking for all the set up information of the banks in the system in the SQL form.
So that i can check whether all the banks are set up properly or not.
Thank you,
Lily