Tuesday 8 July 2014

To Check Period Status(open/close) of different Oracle Apps modules

/* Formatted on 7/9/2014 8:33:33 AM (QP5 v5.115.810.9015) */
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)
          "setofbookname",
       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 = '2013'
ORDER BY period_year DESC, period_num DESC

1 comment:

  1. Wow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks track phone

    ReplyDelete