How to find latest Open GL Period in R12?
Posted: Tue Sep 10, 2019 4:18 am
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')
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')