View: FND_CURRENCIES_ACTIVE_V

Product:	FND - Application Object Library
Description:	Enabled and active currencies
Implementation/DBA Data:	APPS.FND_CURRENCIES_ACTIVE_V

View Text

SELECT C.CURRENCY_CODE
, T.NAME
FROM FND_CURRENCIES_TL T
, FND_CURRENCIES C
WHERE C.ENABLED_FLAG = 'Y'
AND TRUNC(NVL(C.START_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(C.END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)
AND C.CURRENCY_CODE = T.CURRENCY_CODE
AND T.LANGUAGE = USERENV('LANG')

Columns