VIEW: APPS.PA_RP_CALENDAR_PERIOD_NAMES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'