[Home] [Help]
View: OKL_CURRENCIES_UV
View Text
SELECT B.ROWID ROW_ID
, B.CURRENCY_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO_NEVER'
, NVL(B.ENABLED_FLAG
, 'N')
, 0
, 0) ENABLED_FLAG
, B.PRECISION
, B.EXTENDED_PRECISION
, B.SYMBOL
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, T.NAME
, T.DESCRIPTION
FROM FND_CURRENCIES_TL T
, FND_CURRENCIES B
WHERE B.CURRENCY_CODE = T.CURRENCY_CODE
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
CURRENCY_CODE |
ENABLED_FLAG |
PRECISION |
EXTENDED_PRECISION |
SYMBOL |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
NAME |
DESCRIPTION |