APPS.PJI_RM_SUM_EXTR dependencies on PA_FORECAST_ITEM_DETAILS

Line 187: from pa_forecast_item_details fid

183: l_min_date number;
184:
185: cursor c_update_fid is
186: select fid.ROWID as row_id
187: from pa_forecast_item_details fid
188: where fid.expenditure_organization_id in (select organization_id
189: from pji_rm_org_batch_map
190: where worker_id = p_worker_id)
191: and fid.pji_summarized_flag = 'N';

Line 362: PA_FORECAST_ITEM_DETAILS fid,

358: fid.WORK_TYPE_ID,
359: fid.PROJECT_ID
360: from
361: PJI_RM_WORK_TYPE_INFO wt,
362: PA_FORECAST_ITEM_DETAILS fid,
363: PA_FORECAST_ITEMS fi,
364: PJI_RESOURCES_DENORM res,
365: PJI_ORG_EXTR_INFO res_info
366: where

Line 484: update PA_FORECAST_ITEM_DETAILS fid

480: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
481: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
482: l_program_update_date := sysdate;
483:
484: update PA_FORECAST_ITEM_DETAILS fid
485: set fid.PJI_SUMMARIZED_FLAG = null,
486: fid.LAST_UPDATE_DATE = l_last_update_date,
487: fid.LAST_UPDATED_BY = l_last_updated_by,
488: fid.REQUEST_ID = l_request_id,

Line 521: SELECT /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2) */

517: , END_DATE
518: , PJI_SUMMARIZED_FLAG
519: , BATCH_ID
520: )
521: SELECT /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2) */
522: p_worker_id
523: , fid.ROWID
524: , null
525: , null

Line 529: PA_FORECAST_ITEM_DETAILS fid

525: , null
526: , fid.PJI_SUMMARIZED_FLAG
527: , ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)
528: FROM
529: PA_FORECAST_ITEM_DETAILS fid
530: WHERE
531: fid.PJI_SUMMARIZED_FLAG = 'N';
532:
533: else

Line 546: INDEX(fid, PA_FORECAST_ITEM_DETAILS_N2)

542: , BATCH_ID
543: )
544: SELECT /*+ ORDERED
545: USE_NL(fid)
546: INDEX(fid, PA_FORECAST_ITEM_DETAILS_N2)
547: NOPARALLEL(bat)
548: */
549: p_worker_id WORKER_ID
550: , fid.ROWID FID_ROWID

Line 557: , pa_forecast_item_details fid

553: , fid.PJI_SUMMARIZED_FLAG
554: , ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)
555: FROM
556: pji_rm_org_batch_map bat
557: , pa_forecast_item_details fid
558: , pji_rm_rext_fcstitem fcst
559: WHERE
560: bat.WORKER_ID = p_worker_id and
561: fid.EXPENDITURE_ORGANIZATION_ID = bat.ORGANIZATION_ID and

Line 773: PA_FORECAST_ITEM_DETAILS fid,

769: fid.WORK_TYPE_ID,
770: fid.PROJECT_ID
771: from
772: PJI_RM_REXT_FCSTITEM scope,
773: PA_FORECAST_ITEM_DETAILS fid,
774: PA_FORECAST_ITEMS fi,
775: PJI_RM_WORK_TYPE_INFO wt,
776: PJI_RESOURCES_DENORM res,
777: PJI_ORG_EXTR_INFO res_info

Line 1559: update PA_FORECAST_ITEM_DETAILS

1555: if (sql%rowcount <> 0) then
1556:
1557: commit;
1558:
1559: update PA_FORECAST_ITEM_DETAILS
1560: set
1561: PJI_SUMMARIZED_FLAG = null,
1562: LAST_UPDATE_DATE = l_last_update_date,
1563: LAST_UPDATED_BY = l_last_updated_by,