View: PA_FCST_PERIODS_V

Product:	PA - Projects
Description:	PA_FCST_PERIODS_V is a view that shows the periods
Implementation/DBA Data:	APPS.PA_FCST_PERIODS_V

View Text

SELECT PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NAME
, START_DATE
, END_DATE
FROM PA_FCST_PERIODS_TMP_V
WHERE PERIOD_TYPE = FND_PROFILE.VALUE('PA_FORECASTING_PERIOD_TYPE')
AND (TO_CHAR(PERIOD_YEAR) = TO_CHAR(SYSDATE
, 'YYYY') OR START_DATE BETWEEN ADD_MONTHS(SYSDATE
, -3)
AND ADD_MONTHS(SYSDATE
, 6)) ORDER BY START_DATE

Columns