eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_ORGFCST_PERIODS_TMP_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'