How to find latest Open GL Period in R12?

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

How to find latest Open GL Period in R12?

Post by admin »

SELECT period_name,
DECODE (closing_status,
'O', 'Open',
'C', 'Closed',
'F', 'Future',
'N', 'Never',
closing_status)
gl_status
FROM gl_period_statuses
WHERE closing_status = 'O'
AND start_date = (SELECT MAX (start_date) gl_status
FROM gl_period_statuses
WHERE closing_status = 'O')
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests