DBA Data[Home] [Help]

VIEW: APPS.RG_PERIOD_YEARS_V

Source

View Text - Preformatted

SELECT PERIOD_YEAR , APPLICATION_ID , LEDGER_ID FROM GL_PERIOD_STATUSES GROUP BY APPLICATION_ID, LEDGER_ID, PERIOD_YEAR HAVING APPLICATION_ID = 101
View Text - HTML Formatted

SELECT PERIOD_YEAR
, APPLICATION_ID
, LEDGER_ID
FROM GL_PERIOD_STATUSES GROUP BY APPLICATION_ID
, LEDGER_ID
, PERIOD_YEAR HAVING APPLICATION_ID = 101