View: FII_CURRENCIES_V

Product:	FII - Financial Intelligence
Description:	Internal view used to support currency dimension in DBI.
Implementation/DBA Data:	APPS.FII_CURRENCIES_V

View Text

SELECT CURRENCY_CODE
, CURRENCY_CODE
FROM FND_CURRENCIES UNION ALL SELECT 'FII_GLOBAL1'
, FII_CURRENCY_API.GET_PRIM_CURR_NAME
FROM DUAL UNION ALL SELECT 'FII_GLOBAL2'
, FII_CURRENCY_API.GET_SEC_CURR_NAME
FROM DUAL
WHERE FII_CURRENCY_API.GET_SEC_CURR_NAME IS NOT NULL UNION ALL SELECT 'FII_GLOBAL3'
, FII_CURRENCY_API.GET_ANNUALIZED_CURR_NAME
FROM DUAL
WHERE FII_CURRENCY_API.GET_ANNUALIZED_CURR_NAME IS NOT NULL

Columns