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_FP_VP_PERIOD_NAMES_V

Source

View Text - Preformatted


SELECT period_name1 period_name1, null, null, null, null, null, null, null, null, null, null, null, null, null from( select period_name period_name1 , start_date start_date from pa_periods_all WHERE org_id = pa_fp_view_plans_pub.Get_Org_ID() and pa_fp_view_plans_pub.Get_Period_Type() = 'PA' and ( pa_fp_view_plans_pub.Get_Period_Start_Date1() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date2() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date3() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date4() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date5() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date6() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date7() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date8() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date9() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date10() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date11() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date12() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date13() = trunc(start_date) ) UNION ALL select period_name period_name1, start_date start_date from gl_period_statuses gl where pa_fp_view_plans_pub.Get_Period_Type() = 'GL' and application_id = 101 and set_of_books_id in (select impl.set_of_books_id from pa_implementations_all impl where impl.org_id = pa_fp_view_plans_pub.Get_Org_ID()) and ( pa_fp_view_plans_pub.Get_Period_Start_Date1() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date2() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date3() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date4() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date5() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date6() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date7() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date8() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date9() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date10() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date11() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date12() = trunc(start_date) OR pa_fp_view_plans_pub.Get_Period_Start_Date13() = trunc(start_date) )) order by start_date

View Text - HTML Formatted

SELECT PERIOD_NAME1 PERIOD_NAME1
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL FROM( SELECT PERIOD_NAME PERIOD_NAME1
, START_DATE START_DATE
FROM PA_PERIODS_ALL
WHERE ORG_ID = PA_FP_VIEW_PLANS_PUB.GET_ORG_ID()
AND PA_FP_VIEW_PLANS_PUB.GET_PERIOD_TYPE() = 'PA'
AND ( PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE1() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE2() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE3() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE4() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE5() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE6() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE7() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE8() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE9() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE10() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE11() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE12() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE13() = TRUNC(START_DATE) ) UNION ALL SELECT PERIOD_NAME PERIOD_NAME1
, START_DATE START_DATE
FROM GL_PERIOD_STATUSES GL
WHERE PA_FP_VIEW_PLANS_PUB.GET_PERIOD_TYPE() = 'GL'
AND APPLICATION_ID = 101
AND SET_OF_BOOKS_ID IN (SELECT IMPL.SET_OF_BOOKS_ID
FROM PA_IMPLEMENTATIONS_ALL IMPL
WHERE IMPL.ORG_ID = PA_FP_VIEW_PLANS_PUB.GET_ORG_ID())
AND ( PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE1() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE2() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE3() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE4() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE5() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE6() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE7() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE8() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE9() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE10() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE11() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE12() = TRUNC(START_DATE) OR PA_FP_VIEW_PLANS_PUB.GET_PERIOD_START_DATE13() = TRUNC(START_DATE) )) ORDER BY START_DATE