SQL Query to know the Fiscal Month End close status for Financials (AP,AR and GL)

This query will help to find the Fiscal month end close status for the Oracle Financials modules (AP,AR and GL)

SELECT   glps.period_name,
           fa.application_name "Application Name",
           gsob.name,
           DECODE (closing_status, 'N', 'N/a', fu.user_name) "Updated By",
           DECODE (closing_status,
                   'N', 'Never Opened',
                   'C', 'Closed',
                   'O', 'Open',
                   closing_status)
              "Closing Status"
    FROM   apps.gl_period_statuses glps,
           apps.fnd_application_tl fa,
           apps.fnd_user fu,
           apps.gl_sets_of_books gsob
   WHERE       fa.application_id = glps.application_id
           AND glps.last_updated_by = fu.user_id
           AND glps.set_of_books_id = gsob.set_of_books_id
           AND glps.period_name LIKE 'Mar-11'    ----- Provide the month name as of your choice
           AND glps.closing_status NOT IN ('N', 'F')
           AND fa.application_id IN (101, 140, 200, 201, 222) ---- Provide the Application ID as of your oracle setup
ORDER BY   5 DESC, 2, 3;

Thanks

Regards
Prasad