VIEW: APPS.GL_HISTORICAL_RATES_USAGE_V

Source

View Text - Preformatted

SELECT glu.lookup_code, glu.meaning FROM gl_lookups glu, gl_sets_of_books glsob WHERE glu.lookup_type = 'GL_HIST_RATES_USAGE' AND glsob.set_of_books_id = fnd_profile.VALUE('GL_SET_OF_BKS_ID') AND glu.lookup_code <> DECODE(glsob.enable_average_balances_flag, 'N', 'Average', 'dummy')

View Text - HTML Formatted

SELECT GLU.LOOKUP_CODE
, GLU.MEANING
FROM GL_LOOKUPS GLU
, GL_SETS_OF_BOOKS GLSOB
WHERE GLU.LOOKUP_TYPE = 'GL_HIST_RATES_USAGE'
AND GLSOB.SET_OF_BOOKS_ID = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')
AND GLU.LOOKUP_CODE <> DECODE(GLSOB.ENABLE_AVERAGE_BALANCES_FLAG
, 'N'
, 'AVERAGE'
, 'DUMMY')