FND_CURRENCIES_ACTIVE_V

Details

• Schema: REFDATA

• Object owner: FND

• Object type: VIEW

Columns

Name
CURRENCY_CODE NAME

Query

SQL_Statement
SELECT C.CURRENCY_CODE , T.NAME FROM FND_CURRENCIES_TL T, FND_CURRENCIES_B 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')