View: OKL_GL_TRANSLATION_RATES_UV

View Text

SELECT R.ROWID ROW_ID
, R.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, R.PERIOD_NAME PERIOD_NAME
, P.PERIOD_NUM PERIOD_NUM
, P.PERIOD_YEAR PERIOD_YEAR
, P.EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
, P.END_DATE PERIOD_END_DATE
, R.TO_CURRENCY_CODE TO_CURRENCY_CODE
, R.AVG_RATE AVG_RATE
, ROUND(R.AVG_RATE
, 10) SHOW_AVG_RATE
, R.EOP_RATE EOP_RATE
, ROUND(R.EOP_RATE
, 10) SHOW_EOP_RATE
, DECODE(R.EOP_RATE
, 0
, 0
, (1/R.EOP_RATE)) REV_RATE
, DECODE(R.EOP_RATE
, 0
, 0
, ROUND((1/R.EOP_RATE)
, 10)) SHOW_REV_RATE
, R.AVG_RATE_NUMERATOR AVG_RATE_NUMERATOR
, R.AVG_RATE_DENOMINATOR AVG_RATE_DENOMINATOR
, R.EOP_RATE_NUMERATOR EOP_RATE_NUMERATOR
, R.EOP_RATE_DENOMINATOR EOP_RATE_DENOMINATOR
, R.UPDATE_FLAG UPDATE_FLAG
, R.LAST_UPDATE_DATE LAST_UPDATE_DATE
, R.LAST_UPDATED_BY LAST_UPDATED_BY
, R.CREATION_DATE CREATION_DATE
, R.CREATED_BY CREATED_BY
, R.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, R.ATTRIBUTE1 ATTRIBUTE1
, R.ATTRIBUTE2 ATTRIBUTE2
, R.ATTRIBUTE3 ATTRIBUTE3
, R.ATTRIBUTE4 ATTRIBUTE4
, R.ATTRIBUTE5 ATTRIBUTE5
, R.CONTEXT CONTEXT
, R.ACTUAL_FLAG ACTUAL_FLAG
, S.CURRENCY_CODE FUNCTIONAL_CURRENCY
, FCT.NAME FROM_CURRENCY
, FCT1.NAME TO_CURRENCY
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('TRANSLATION_BAL_TYPE'
, R.ACTUAL_FLAG
, 101
, 101) BALANCE_TYPE
FROM GL_TRANSLATION_RATES R
, GL_SETS_OF_BOOKS S
, GL_PERIOD_STATUSES P
, FND_CURRENCIES_TL FCT
, FND_CURRENCIES_TL FCT1
WHERE R.SET_OF_BOOKS_ID = S.SET_OF_BOOKS_ID
AND S.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
AND P.APPLICATION_ID = DECODE(R.SET_OF_BOOKS_ID
, 0
, 101
, 101)
AND R.PERIOD_NAME = P.PERIOD_NAME
AND S.CURRENCY_CODE = FCT.CURRENCY_CODE
AND FCT.LANGUAGE = USERENV('LANG')
AND R.TO_CURRENCY_CODE = FCT1.CURRENCY_CODE
AND FCT1.LANGUAGE = USERENV('LANG')

Columns