DBA Data[Home] [Help]

APPS.PJI_AUDIT_RPT dependencies on PA_FORECAST_ITEM_DETAILS

Line 377: exists (select /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2)

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

Line 378: parallel_index(fid, PA_FORECAST_ITEM_DETAILS_N2) */

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)

Line 380: from PA_FORECAST_ITEM_DETAILS fid

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