[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 |