View: PA_RP_CALENDAR_PERIOD_NAMES_V

Product:	PA - Projects
Description:	This view shows period names of Reporting Pack
Implementation/DBA Data:	APPS.PA_RP_CALENDAR_PERIOD_NAMES_V

View Text

SELECT PAIMP.ORG_ID ORG_ID
, 'P' CALENDAR_TYPE
, PAP.PERIOD_NAME PERIOD_NAME
FROM PA_IMPLEMENTATIONS_ALL PAIMP
, GL_PERIOD_STATUSES GLS
, PA_PERIODS_ALL PAP
WHERE PAP.GL_PERIOD_NAME = GLS.PERIOD_NAME
AND GLS.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
AND GLS.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND GLS.CLOSING_STATUS<>'N'
AND PAP.ORG_ID = PAIMP.ORG_ID GROUP BY PAIMP.ORG_ID
, PAP.PERIOD_NAME UNION ALL SELECT PAIMP.ORG_ID ORG_ID
, 'G' CALENDAR_TYPE
, GLP.PERIOD_NAME PERIOD_NAME
FROM PA_IMPLEMENTATIONS_ALL PAIMP
, GL_SETS_OF_BOOKS SOB
, GL_PERIODS GLP
, GL_PERIOD_STATUSES GLS
WHERE 1=1
AND PAIMP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND SOB.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND SOB.ACCOUNTED_PERIOD_TYPE = GLP.PERIOD_TYPE
AND PAIMP.SET_OF_BOOKS_ID=GLS.SET_OF_BOOKS_ID
AND GLS.PERIOD_NAME=GLP.PERIOD_NAME
AND GLS.APPLICATION_ID=PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND GLS.CLOSING_STATUS<>'N'

Columns