To Check Period Status(open/close) of different Oracle Apps modules

SELECT ROWID, (SELECT application_short_name FROM fnd_application fa WHERE fa.application_id = gps.application_id) application, (SELECT NAME FROM gl_sets_of_books gsp WHERE gsp.set_of_books_id = gps.set_of_books_id) "setofbookname", period_name, closing_status, period_num, period_year, start_date, end_dateFROM gl_period_statuses gpsORDER BY period_year DESC, period_num DESC