GL Period Name Query:

How to find out Open / Close GL Period in ORacle Apps::


SELECT
  gps.period_num,
  gps.period_name,
  gps.set_of_books_id,
  gsob.period_set_name,
  DECODE (gps.closing_status,
    'O', 'Open',
    'C', 'Closed',
    'F', 'Future',
    'N', 'Never') status
FROM
  gl_period_statuses gps,
  gl_sets_of_books gsob
where
  gps.application_id = 101
  and gps.closing_status='O' and
  gsob.set_of_books_id = gps.set_of_books_id
  and gps.set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID')
  and gps.PERIOD_YEAR=2013
  order by
  gps.period_num