View: PN_GL_PERIOD_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_GL_PERIOD_V

View Text

SELECT PERIOD_NAME
, START_DATE
, END_DATE
FROM GL_PERIOD_STATUSES G
, GL_SETS_OF_BOOKS B
WHERE B.SET_OF_BOOKS_ID = G.SET_OF_BOOKS_ID
AND G.APPLICATION_ID = 101
AND G.SET_OF_BOOKS_ID = PN_MO_CACHE_UTILS.GET_PROFILE_VALUE('PN_SET_OF_BOOKS_ID')
AND G.PERIOD_TYPE = B.ACCOUNTED_PERIOD_TYPE
AND G.ADJUSTMENT_PERIOD_FLAG = 'N'
AND CLOSING_STATUS IN ('O'
, 'F') ORDER BY EFFECTIVE_PERIOD_NUM

Columns