View: GL_HISTORICAL_RATES_CURRENCY_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_HISTORICAL_RATES_CURRENCY_V

View Text

SELECT FC.CURRENCY_CODE CURRENCY_CODE
, NVL(FCTL.DESCRIPTION
, FCTL.NAME) DESCRIPTION
FROM FND_CURRENCIES_TL FCTL
, FND_CURRENCIES FC
WHERE FCTL.CURRENCY_CODE = FC.CURRENCY_CODE
AND SYSDATE BETWEEN NVL(FC.START_DATE_ACTIVE
, SYSDATE)
AND NVL(FC.END_DATE_ACTIVE
, SYSDATE)
AND ( FC.DERIVE_TYPE <> 'EMU' OR FC.DERIVE_TYPE IS NULL)
AND FC.ENABLED_FLAG = 'Y'
AND FCTL.LANGUAGE = USERENV('LANG')
AND FC.CURRENCY_CODE <> (SELECT CURRENCY_CODE
FROM GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID'))

Columns