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')
How to find latest Open GL Period in R12?
Who is online
Users browsing this forum: No registered users and 8 guests