VIEW: APPS.GL_SRS_RECON_CURRENCIES_V

Source

View Text - Preformatted

SELECT currency_code, description FROM fnd_currencies_vl WHERE enabled_flag = 'Y' UNION SELECT meaning currency_code, description FROM gl_lookups WHERE lookup_type = 'LITERAL' AND lookup_code = 'ALL123456789012345' ORDER BY currency_code

View Text - HTML Formatted

SELECT CURRENCY_CODE
, DESCRIPTION
FROM FND_CURRENCIES_VL
WHERE ENABLED_FLAG = 'Y' UNION SELECT MEANING CURRENCY_CODE
, DESCRIPTION
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'ALL123456789012345' ORDER BY CURRENCY_CODE