VIEW: APPS.PA_FCST_PERIODIC_HDR_V

Source

View Text - Preformatted

SELECT DISTINCT 'Y' forecast_exists_flag, sum1.project_currency_code Y1, DENSE_RANK() OVER (ORDER BY sum1.project_currency_code ) AS y1_seq, per.period_name X1, DENSE_RANK() OVER (ORDER BY per.start_date ) AS x1_seq, sum.value value FROM pa_fcst_periodic_sum_v sum, pa_fcst_periods_tmp per, pa_fcst_periodic_sum_v sum1, (SELECT pa_fcst_global.GetProjFcstStartDate StartDate, pa_fcst_global.GetProjFcstEndDate EndDate FROM DUAL) FilterBy WHERE ((per.start_date BETWEEN FilterBy.StartDate AND FilterBy.EndDate) OR (per.end_date BETWEEN FilterBy.StartDate AND FilterBy.EndDate)) AND per.period_name = sum.period_name (+) AND sum1.period_name = NVL(sum.period_name,sum1.period_name) UNION ALL SELECT 'N' forecast_exists_flag, NULL y1, 100000 y1_seq, per.period_name X1, DENSE_RANK() OVER (ORDER BY per.start_date ) AS x1_seq, 0 value FROM pa_fcst_periods_tmp per, (SELECT pa_fcst_global.GetProjFcstStartDate StartDate, pa_fcst_global.GetProjFcstEndDate EndDate FROM DUAL) FilterBy WHERE ((per.start_date BETWEEN FilterBy.StartDate AND FilterBy.EndDate) OR (per.end_date BETWEEN FilterBy.StartDate AND FilterBy.EndDate))

View Text - HTML Formatted

SELECT DISTINCT 'Y' FORECAST_EXISTS_FLAG
, SUM1.PROJECT_CURRENCY_CODE Y1
, DENSE_RANK() OVER (ORDER BY SUM1.PROJECT_CURRENCY_CODE ) AS Y1_SEQ
, PER.PERIOD_NAME X1
, DENSE_RANK() OVER (ORDER BY PER.START_DATE ) AS X1_SEQ
, SUM.VALUE VALUE
FROM PA_FCST_PERIODIC_SUM_V SUM
, PA_FCST_PERIODS_TMP PER
, PA_FCST_PERIODIC_SUM_V SUM1
, (SELECT PA_FCST_GLOBAL.GETPROJFCSTSTARTDATE STARTDATE
, PA_FCST_GLOBAL.GETPROJFCSTENDDATE ENDDATE
FROM DUAL) FILTERBY
WHERE ((PER.START_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE) OR (PER.END_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE))
AND PER.PERIOD_NAME = SUM.PERIOD_NAME (+)
AND SUM1.PERIOD_NAME = NVL(SUM.PERIOD_NAME
, SUM1.PERIOD_NAME) UNION ALL SELECT 'N' FORECAST_EXISTS_FLAG
, NULL Y1
, 100000 Y1_SEQ
, PER.PERIOD_NAME X1
, DENSE_RANK() OVER (ORDER BY PER.START_DATE ) AS X1_SEQ
, 0 VALUE
FROM PA_FCST_PERIODS_TMP PER
, (SELECT PA_FCST_GLOBAL.GETPROJFCSTSTARTDATE STARTDATE
, PA_FCST_GLOBAL.GETPROJFCSTENDDATE ENDDATE
FROM DUAL) FILTERBY
WHERE ((PER.START_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE) OR (PER.END_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE))