View: OKL_LA_CURRENCIES_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for currencies.Displays valid currencies as of sysdate
Implementation/DBA Data:	APPS.OKL_LA_CURRENCIES_UV

View Text

SELECT T.CURRENCY_CODE
, T.NAME
, T.DESCRIPTION
FROM FND_CURRENCIES_TL T
, FND_CURRENCIES B
WHERE B.CURRENCY_CODE = T.CURRENCY_CODE
AND T.LANGUAGE = USERENV('LANG')
AND SYSDATE BETWEEN NVL(B.START_DATE_ACTIVE
, SYSDATE)
AND NVL(B.END_DATE_ACTIVE
, SYSDATE)
AND NVL(B.CURRENCY_FLAG
, 'N') = 'Y'
AND NVL(B.ENABLED_FLAG
, 'N') = 'Y'

Columns