View: PA_REP_QUARTER_GL_V

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

View Text

SELECT DISTINCT GLPER.QUARTER_NUM AS QUARTER_NUM
, IMP.ORG_ID AS 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 ORDER BY QUARTER_NUM

Columns