How to find out currency/accounts?

[qzheng]

I want to query my database to find out the following info:


1. how many natural accounts?
2. how many currencies?


What tables store those information?


Thanks

Qingbo

[akwete]

Qingbo,

If you are an AppsDBA, you can query gl_consolidation_accounts to see natural accounts and fnd_currencies_active to see currencies. There are also other views and tables where you can see that information.
I hope this helps you.

C. K.
AppsDBA 11i