VIEW: APPS.PA_FCST_PERIODS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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