DBA Data[Home] [Help]

VIEW: APPS.GL_HISTORICAL_RATES_PERIOD_V

Source

View Text - Preformatted

SELECT period_name FROM gl_period_statuses WHERE application_id = 101 AND set_of_books_id = fnd_profile.VALUE('GL_SET_OF_BKS_ID') ORDER BY effective_period_num DESC
View Text - HTML Formatted

SELECT PERIOD_NAME
FROM GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101
AND SET_OF_BOOKS_ID = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID') ORDER BY EFFECTIVE_PERIOD_NUM DESC