Friday, September 28, 2012

What languages and currencies are enabled in EBS

select language_code
from fnd_languages
where installed_flag='I'

For currencies, In EBS all currencies are enabled.

select CURRENCY_CODE,symbol
from apps.fnd_currencies
where enabled_flag='Y'
 
select object_name,bytes
from dba_segments
order by bytes desc;

SQL> select currency_code,count(*)
from apps.gl_interface
group by currency_code; 2 3

CURRENCY_CODE COUNT(*)
--------------- ----------
VND xxx
EUR xxx
USD xxx
SGD xxx
JPY xxx


VND = Vietnamese Dollar
SGD = Singapore Dollar
JPY = Japanese Yen
EUR = Euro
USD = US Dollar

No comments:

Post a Comment