VIEW: APPS.GL_ENTERED_CURRENCIES_V

Source

View Text - Preformatted

SELECT 'E' CURRENCY_TYPE, CURRENCY_CODE FROM FND_CURRENCIES WHERE CURRENCY_CODE <> 'STAT' AND ENABLED_FLAG='Y' UNION SELECT 'S' CURRENCY_TYPE, CURRENCY_CODE FROM FND_CURRENCIES WHERE CURRENCY_CODE = 'STAT' UNION SELECT 'T' CURRENCY_TYPE, LOOKUP_CODE 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'
AND ENABLED_FLAG='Y' UNION SELECT 'S' CURRENCY_TYPE
, CURRENCY_CODE
FROM FND_CURRENCIES
WHERE CURRENCY_CODE = 'STAT' UNION SELECT 'T' CURRENCY_TYPE
, LOOKUP_CODE CURRENCY_CODE
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'N/A'