SELECT STATUS,

            PERIOD_NAME,

            PERIOD_NUMBER,

            PERIOD_YEAR,

            START_DATE,

            END_DATE,

            CLOSE_DATE,

            REC_TYPE,

            ORGANIZATION_ID

FROM ORG_ACCT_PERIODS_V

WHERE ((rec_type = 'ORG_PERIOD' ))

order by END_DATE desc