GL PERIOD STATUS CODE QUERY IN ORACLE APPS

 SELECT sob.name "Set of Books" ,ps.application_id,

fnd.product_code "Product Code" ,

ps.PERIOD_NAME "Period Name" ,

ps.START_DATE "Period Start Date" ,

ps.END_DATE "Period End Date" ,

DECODE(ps.closing_status, 'O','O - Open' ,

                          'N','N - Never Opened' ,

                          'F','F - Future Enterable' ,

                          'C','C - Closed' ,'Unknown') "Period Status"

FROM apps.gl_period_statuses ps ,

apps.GL_SETS_OF_BOOKS sob ,

apps.fnd_application fnd

WHERE 1=1--ps.application_id   =101 -- GL 

AND sob.SET_OF_BOOKS_ID       = ps.SET_OF_BOOKS_ID

AND fnd.application_id        = ps.application_id

AND ps.adjustment_period_flag = 'N'

AND (TRUNC(SYSDATE) -- Comment line if a a date other than SYSDATE is being tested.

  BETWEEN TRUNC(ps.start_date) AND TRUNC (ps.end_date))

ORDER BY ps.SET_OF_BOOKS_ID,

  fnd.product_code,

  ps.start_date;