select a.enterprise_id, a.currency_code, a.CURRENCY_CODE || '-' || b.NAME
from FND_CURRENCIES_B a, FND_CURRENCIES_TL b
where a.enterprise_id = b.enterprise_id
and a.currency_code = b.currency_code
and a.enabled_flag = 'Y'
and a.currency_flag = 'Y'
and a.iso_flag = 'Y'
and b.language = 'US'
No comments:
Post a Comment