View: PA_FP_VP_PERIOD_NAMES_V

Product:	PA - Projects
Description:	The pa_fp_vp_period_names_v view store the names of forecasting periods to be displayed.
Implementation/DBA Data:	APPS.PA_FP_VP_PERIOD_NAMES_V

View Text

SELECT PERIOD_NAME PERIOD_NAME1
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
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
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
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) )

Columns