SELECT fnb.currency_code, fnt.name FROM fnd_currencies fnb, fnd_currencies_tl fnt WHERE fnb.enabled_flag = 'Y' AND fnb.currency_flag = 'Y' AND trunc(nvl(fnb.start_date_active,sysdate)) <= trunc(sysdate) AND trunc(nvl(fnb.end_date_active,sysdate)) >= trunc(sysdate) AND fnb.currency_code = fnt.currency_code AND fnt.language = USERENV('LANG')
SELECT FNB.CURRENCY_CODE
, FNT.NAME
FROM FND_CURRENCIES FNB
, FND_CURRENCIES_TL FNT
WHERE FNB.ENABLED_FLAG = 'Y'
AND FNB.CURRENCY_FLAG = 'Y'
AND TRUNC(NVL(FNB.START_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(FNB.END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)
AND FNB.CURRENCY_CODE = FNT.CURRENCY_CODE
AND FNT.LANGUAGE = USERENV('LANG')
|
|
|