View: PA_REP_YEAR_GL_V

Product:	PA - Projects
Description:	PA_REP_YEAR_GL_V is a view to get GL year numbers
Implementation/DBA Data:	APPS.PA_REP_YEAR_GL_V

View Text

SELECT DISTINCT GLPER.PERIOD_YEAR AS PERIOD_YEAR
, IMP.ORG_ID
FROM PA_IMPLEMENTATIONS IMP
, GL_SETS_OF_BOOKS GL
, GL_PERIODS GLPER
WHERE IMP.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND GL.PERIOD_SET_NAME = GLPER.PERIOD_SET_NAME
AND GL.ACCOUNTED_PERIOD_TYPE = GLPER.PERIOD_TYPE

Columns