GL PERIOD STATUSES QUERY

/* Formatted on 11/16/2016 1:48:24 PM (QP5 v5.114.809.3010) */
  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