View: GL_TRANSLATION_RATES_PERIODS_V

View Text

SELECT TR.PERIOD_NAME PERIOD_NAME
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
, TR.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TR.TO_CURRENCY_CODE TO_CURRENCY_CODE
FROM GL_TRANSLATION_RATES TR
, GL_PERIOD_STATUSES PS
WHERE PS.PERIOD_NAME = TR.PERIOD_NAME
AND PS.SET_OF_BOOKS_ID = TR.SET_OF_BOOKS_ID
AND PS.APPLICATION_ID = 101
AND TR.ACTUAL_FLAG = 'A'
AND PS.CLOSING_STATUS IN ('O'
, 'C'
, 'P')
AND (PS.PERIOD_YEAR*1000 + PS.PERIOD_NUM) >= (SELECT NVL(MAX((NVL(GLTT.EARLIEST_EVER_PERIOD_YEAR
, 0)*1000 + NVL(GLTT.EARLIEST_EVER_PERIOD_NUM
, 0)))
, 0)
FROM GL_TRANSLATION_TRACKING GLTT
WHERE GLTT.SET_OF_BOOKS_ID(+)=TR.SET_OF_BOOKS_ID
AND GLTT.TARGET_CURRENCY(+)=TR.TO_CURRENCY_CODE
AND GLTT.ACTUAL_FLAG(+) = 'A')

Columns