Query to find Open PO Periods

Query to Find Open PO Periods for Month End Closure

SELECT sob.name "Set of Books" ,

fnd.product_code "Product Code" ,

ps.PERIOD_NAME "Period Name" ,

ps.START_DATE "Period Start Date" ,

ps.END_DATE "Period End Date" ,

DECODE(ps.closing_status, 'O','O - Open' ,

'N','N - Never Opened' ,

'F','F - Future Enterable' ,

'C','C - Closed' ,'Unknown') "Period Status"

FROM gl_period_statuses ps ,

Apps.GL_SETS_OF_BOOKS sob ,

FND_APPLICATION_VL fnd

WHERE ps.application_id IN (201) -- 101 GL & 201 PO

AND sob.SET_OF_BOOKS_ID = ps.SET_OF_BOOKS_ID

AND fnd.application_id = ps.application_id

AND sob.name not like '%Fisc%'

and sob.name not like '%Books2%'

and sob.name not like '%Books3%'

AND ps.adjustment_period_flag = 'N'

AND (TRUNC(SYSDATE) -- Comment line if a a date other than SYSDATE is being tested.

--AND ('01-DEC-2014' -- Uncomment line if a date other than SYSDATE is being tested.

BETWEEN TRUNC(ps.start_date) AND TRUNC (ps.end_date))

ORDER BY ps.SET_OF_BOOKS_ID,

fnd.product_code,

ps.start_date;