373: ) org
374: where
375: p_settings_util_flag = 'Y' and
376: p_params_util_flag = 'N' and
377: exists (select /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2)
378: parallel_index(fid, PA_FORECAST_ITEM_DETAILS_N2) */
379: 1
380: from PA_FORECAST_ITEM_DETAILS fid
381: where fid.EXPENDITURE_ORGANIZATION_ID > 0 and
374: where
375: p_settings_util_flag = 'Y' and
376: p_params_util_flag = 'N' and
377: exists (select /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2)
378: parallel_index(fid, PA_FORECAST_ITEM_DETAILS_N2) */
379: 1
380: from PA_FORECAST_ITEM_DETAILS fid
381: where fid.EXPENDITURE_ORGANIZATION_ID > 0 and
382: fid.EXPENDITURE_ORGANIZATION_ID = org.ORGANIZATION_ID)
376: p_params_util_flag = 'N' and
377: exists (select /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2)
378: parallel_index(fid, PA_FORECAST_ITEM_DETAILS_N2) */
379: 1
380: from PA_FORECAST_ITEM_DETAILS fid
381: where fid.EXPENDITURE_ORGANIZATION_ID > 0 and
382: fid.EXPENDITURE_ORGANIZATION_ID = org.ORGANIZATION_ID)
383: union -- Financial Management
384: select /*+ ordered