/* GL PERIOD STATUSES 
Written by Daniel North,  ORAFINAPPS Limited, Copyright 2007 
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.
(Tested on Vision 11.5.10.2 Jul-2007 ) */
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 = 2006
--and substr(sob.short_name,1,2) in ('ES','LU','BE')
and ps.show_status not in ('Never Opened')
order by 1,5,6 desc

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 ('GB')
order by 1,5,6 desc