[Home] [Help]
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
Name |
PERIOD_NAME1 |
PERIOD_NAME2 |
PERIOD_NAME3 |
PERIOD_NAME4 |
PERIOD_NAME5 |
PERIOD_NAME6 |
PERIOD_NAME7 |
PERIOD_NAME8 |
PERIOD_NAME9 |
PERIOD_NAME10 |
PERIOD_NAME11 |
PERIOD_NAME12 |
PERIOD_NAME13 |
ROW_ID |