VIEW: APPS.JG_ZZ_ENTERED_CURRENCIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'