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
Printable View
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
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