GL Period Status

TWO SMALL SCRIPTS FOR REVIEWING OPEN PERIODS ACROSS MULTIPEL BOOKS. 

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 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 ('GPB')

ORDER BY 1,5,6 DESC