VIEW: APPS.FII_CURRENCIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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