QUERY TO CHECK PERIODS STATUS (OPEN/CLOSE) FOR ALL MODULES

SELECT ROWID,
  (SELECT application_short_name
  FROM fnd_application fa
  WHERE fa.application_id = gps.application_id
  ) application,
  (SELECT name
  FROM gl_sets_of_books gsp
  where GSP.SET_OF_BOOKS_ID = GPS.SET_OF_BOOKS_ID
  ) SETOFBOOK,
  period_name,
  closing_status,
  DECODE (gps.closing_status, 'O', 'Open', 'C', 'Closed', 'F', 'Future', 'N', 'Never' ) status,
  period_num,
  period_year,
  start_date,
  end_date
from GL_PERIOD_STATUSES GPS
WHERE PERIOD_YEAR = '2016'
ORDER BY period_year DESC,
  period_num DESC

Post a Comment