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'
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
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