View: PA_ORGFCST_PERIODS_TMP_V

Product:	PA - Projects
Description:	The PA_ORGFCST_PERIODS_TMP_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_ORGFCST_PERIODS_TMP_V

View Text

SELECT 'GL'
, GLPER.PERIOD_YEAR
, GLPER.PERIOD_NAME
, GLPER.START_DATE
, GLPER.END_DATE
FROM PA_IMPLEMENTATIONS_ALL IMP
, GL_SETS_OF_BOOKS GL
, GL_PERIODS GLPER
, GL_PERIOD_STATUSES GLPERSTS
, GL_LOOKUPS PRSTS
, GL_DATE_PERIOD_MAP GLMAPS
, PA_PROJ_PERIOD_PROFILES PPPP
, PA_BUDGET_VERSIONS PBV
WHERE PBV.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PBV.PERIOD_PROFILE_ID = PPPP.PERIOD_PROFILE_ID
AND PPPP.PLAN_PERIOD_TYPE = 'GL'
AND NVL(IMP.ORG_ID
, -99) = PA_FIN_PLAN_VIEW_GLOBAL.GET_ORG_ID()
AND 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_PROJ_PERIOD_PROFILES PPPP
, PA_BUDGET_VERSIONS PBV
WHERE PBV.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PBV.PERIOD_PROFILE_ID = PPPP.PERIOD_PROFILE_ID
AND PPPP.PLAN_PERIOD_TYPE = 'PA'

Columns