[Home] [Help]
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