View: PA_REP_PERIOD_DATES_V

Product:	PA - Projects
Description:	The PA_REP_PERIOD_DATES_V view displays information about period types such as the name of the period and the start and end dates.
Implementation/DBA Data:	APPS.PA_REP_PERIOD_DATES_V

View Text

SELECT 'GL'
, GLPER.PERIOD_YEAR
, GLPER.PERIOD_NAME
, GLPER.START_DATE
, GLPER.END_DATE
FROM PA_IMPLEMENTATIONS IMP
, GL_SETS_OF_BOOKS GL
, GL_PERIODS GLPER
, GL_PERIOD_STATUSES GLPERSTS
, GL_LOOKUPS PRSTS
, GL_DATE_PERIOD_MAP GLMAPS
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
AND GLPERSTS.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND GLPERSTS.PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLPERSTS.PERIOD_NAME = GLPER.PERIOD_NAME
AND GLPERSTS.PERIOD_YEAR = GLPER.PERIOD_YEAR
AND GLPERSTS.CLOSING_STATUS = PRSTS.LOOKUP_CODE
AND GLMAPS.PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLMAPS.PERIOD_NAME = GLPER.PERIOD_NAME
AND GLMAPS.PERIOD_SET_NAME = GLPER.PERIOD_SET_NAME
AND GLPERSTS.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND PRSTS.LOOKUP_CODE IN('C'
, 'F'
, 'N'
, 'O'
, 'P')
AND PRSTS.LOOKUP_TYPE ='CLOSING_STATUS' UNION SELECT 'PA'
, PAPERIOD.PERIOD_YEAR
, PAPERIOD.PERIOD_NAME
, PAPERIOD.PA_START_DATE
, PAPERIOD.PA_END_DATE
FROM PA_PERIODS_V PAPERIOD
, PA_IMPLEMENTATIONS IMP
, GL_PERIOD_STATUSES GLPERSTS
WHERE GLPERSTS.PERIOD_TYPE = IMP.PA_PERIOD_TYPE
AND IMP.SET_OF_BOOKS_ID = PAPERIOD.SET_OF_BOOKS_ID
AND GLPERSTS.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND GLPERSTS.PERIOD_NAME = PAPERIOD.PERIOD_NAME
AND GLPERSTS.PERIOD_YEAR = PAPERIOD.PERIOD_YEAR
AND GLPERSTS.APPLICATION_ID = 275 UNION SELECT 'QR'
, GLPER.PERIOD_YEAR
, TO_CHAR(GLPER.QUARTER_NUM)
, MIN(GLPER.START_DATE)
, MAX(GLPER.END_DATE)
FROM PA_IMPLEMENTATIONS IMP
, GL_SETS_OF_BOOKS GL
, GL_PERIODS GLPER
, GL_PERIOD_STATUSES GLPERSTS
, GL_LOOKUPS PRSTS
, GL_DATE_PERIOD_MAP GLMAPS
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
AND GLPERSTS.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND GLPERSTS.PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLPERSTS.PERIOD_NAME = GLPER.PERIOD_NAME
AND GLPERSTS.PERIOD_YEAR = GLPER.PERIOD_YEAR
AND GLPERSTS.CLOSING_STATUS = PRSTS.LOOKUP_CODE
AND GLMAPS.PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLMAPS.PERIOD_NAME = GLPER.PERIOD_NAME
AND GLMAPS.PERIOD_SET_NAME = GLPER.PERIOD_SET_NAME
AND GLPERSTS.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND PRSTS.LOOKUP_CODE IN('C'
, 'F'
, 'N'
, 'O'
, 'P')
AND PRSTS.LOOKUP_TYPE ='CLOSING_STATUS' GROUP BY GLPER.PERIOD_YEAR
, GLPER.QUARTER_NUM UNION SELECT 'YR'
, GLPER.PERIOD_YEAR
, TO_CHAR(GLPER.PERIOD_YEAR)
, MIN(GLPER.START_DATE)
, MAX(GLPER.END_DATE)
FROM PA_IMPLEMENTATIONS IMP
, GL_SETS_OF_BOOKS GL
, GL_PERIODS GLPER
, GL_PERIOD_STATUSES GLPERSTS
, GL_LOOKUPS PRSTS
, GL_DATE_PERIOD_MAP GLMAPS
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
AND GLPERSTS.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND GLPERSTS.PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLPERSTS.PERIOD_NAME = GLPER.PERIOD_NAME
AND GLPERSTS.PERIOD_YEAR = GLPER.PERIOD_YEAR
AND GLPERSTS.CLOSING_STATUS = PRSTS.LOOKUP_CODE
AND GLMAPS.PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLMAPS.PERIOD_NAME = GLPER.PERIOD_NAME
AND GLMAPS.PERIOD_SET_NAME = GLPER.PERIOD_SET_NAME
AND GLPERSTS.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND PRSTS.LOOKUP_CODE IN('C'
, 'F'
, 'N'
, 'O'
, 'P')
AND PRSTS.LOOKUP_TYPE ='CLOSING_STATUS' GROUP BY GLPER.PERIOD_YEAR UNION SELECT 'GE'
, PERIOD_YEAR
, TO_CHAR((NEXT_DAY(TO_DATE('01-JAN-'||TO_CHAR(PERIOD_YEAR)
, 'DD-MON-YYYY')
, TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (SEQ_NUMBER-1) * 7)
, ((NEXT_DAY(TO_DATE('01-JAN-'||TO_CHAR(PERIOD_YEAR)
, 'DD-MON-YYYY')
, TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (SEQ_NUMBER-1) * 7) - 6
, (NEXT_DAY(TO_DATE('01-JAN-'||TO_CHAR(PERIOD_YEAR)
, 'DD-MON-YYYY')
, TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (SEQ_NUMBER-1) * 7
FROM PA_REP_YEAR_CAL_V
, PA_REP_SEQ_NUMBER
WHERE SEQ_NUMBER BETWEEN 1
AND 53

Columns