DBA Data[Home] [Help]

APPS.PJI_RM_SUM_EXTR dependencies on PA_FORECAST_ITEMS

Line 363: PA_FORECAST_ITEMS fi,

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
367: nvl(fid.pji_summarized_flag,'Y') <> 'N' and

Line 497: PA_FORECAST_ITEMS fi

493: fid.FORECAST_ITEM_ID in
494: (select /*+ cardinality(delta, 1) */
495: fi.FORECAST_ITEM_ID
496: from PJI_RES_DELTA delta,
497: PA_FORECAST_ITEMS fi
498: where delta.CHANGE_TYPE = 'N' and
499: delta.RESOURCE_ID = fi.RESOURCE_ID and
500: fi.FORECAST_ITEM_TYPE in ('U', 'A') and
501: fi.DELETE_FLAG in ('Y', 'N') and

Line 774: PA_FORECAST_ITEMS fi,

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
778: where