[Home] [Help]
View: GLFV_GL_DAILY_EXCHANGE_RATES
View Text
SELECT GLDR.FROM_CURRENCY
, GLDR.TO_CURRENCY
, GLDR.CONVERSION_DATE
, GLDR.CONVERSION_TYPE
, GL_CONVERSION_TYPE.USER_CONVERSION_TYPE
, GLDR.CONVERSION_RATE
, '_DF:SQLGL:GL_DAILY_RATES:GLDR'
FROM GL_DAILY_RATES GLDR
, GL_DAILY_CONVERSION_TYPES GL_CONVERSION_TYPE
WHERE GLDR.CONVERSION_TYPE = GL_CONVERSION_TYPE.CONVERSION_TYPE WITH READ ONLY
Columns
Name |
FROM_CURRENCY |
TO_CURRENCY |
CURRENCY_CONVERSION_DATE |
CURRENCY_CONVERSION_TYPE_CODE |
CURRENCY_CONVERSION_TYPE |
CURRENCY_CONVERSION_RATE |
_DF |