DBA Data[Home] [Help]

VIEW: APPS.OKL_CURRENCIES_UV

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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')