VIEW: APPS.GL_PERIOD_STATUSES_FIRST_60_V

Source

View Text - Preformatted

SELECT period_name, period_year, period_num, ledger_id FROM gl_period_statuses WHERE application_id = 101 AND period_num between 1 and 60

View Text - HTML Formatted

SELECT PERIOD_NAME
, PERIOD_YEAR
, PERIOD_NUM
, LEDGER_ID
FROM GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101
AND PERIOD_NUM BETWEEN 1
AND 60