Period Status script

GL : Period Status script:-
-----------------------------

GL PERIOD STATUSES

Two small scripts for reviewing open periods across multipel books. ( Month end close checking or automated alerts )
and period status for a given year and book.

I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.

select sob.short_name
, ps.period_name
, ps.show_status
, ps.start_date||' to '||ps.end_date
, ps.period_year
, ps.period_num
from GL_PERIOD_STATUSES_V ps, GL_SETS_OF_BOOKS sob
where ps.set_of_Books_id = sob.SET_OF_BOOKS_ID
and application_id = 101
--and period_year = 2008
--and substr(sob.short_name,1,2) in ('hb')
and ps.show_status not in ('Never Opened')
order by 1,5,6 desc

Second Script

select sob.short_name
, ps.period_name
, ps.start_date
, ps.end_date
, ps.period_year
, ps.period_num
, ps.show_status
from GL_PERIOD_STATUSES_V ps, GL_SETS_OF_BOOKS sob
where ps.set_of_Books_id = sob.SET_OF_BOOKS_ID
and application_id = 101
and period_year = 2006
--and substr(sob.short_name,1,2) in ('hb')
order by 1,5,6 desc