FND Design Data [Home] [Help]

View: PA_FP_PERIODS_PL_V

Product: PA - Projects
Description: The pa_fp_periods_pl_v view is created for the start period poplist.
Implementation/DBA Data: ViewAPPS.PA_FP_PERIODS_PL_V
View Text

SELECT PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NAME
, START_DATE
, END_DATE
FROM PA_ORGFCST_PERIODS_TMP_V
WHERE START_DATE >=PA_FIN_PLAN_VIEW_GLOBAL.GET_PLAN_START_DATE()
AND END_DATE <= PA_FIN_PLAN_VIEW_GLOBAL.GET_PLAN_END_DATE()

Columns

Name
PERIOD_TYPE
PERIOD_YEAR
PERIOD_NAME
START_DATE
END_DATE