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_date

FROM
gl_period_statuses gps

ORDER BY
period_year DESC,
period_num DESC