View: JG_ZZ_ENTERED_CURRENCIES_V

Product:	JG - Regional Localizations
Description:
Implementation/DBA Data:	APPS.JG_ZZ_ENTERED_CURRENCIES_V

View Text

SELECT 'E' CURRENCY_TYPE
, CURRENCY_CODE
FROM FND_CURRENCIES
WHERE CURRENCY_CODE <> 'STAT' UNION SELECT 'S' CURRENCY_TYPE
, CURRENCY_CODE
FROM FND_CURRENCIES
WHERE CURRENCY_CODE = 'STAT' UNION SELECT 'T' CURRENCY_TYPE
, MEANING CURRENCY_CODE
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'N/A'

Columns