APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_TIME_RPT_STRUCT

Line 9171: fnd_stats.gather_table_stats('PJI','PJI_TIME_RPT_STRUCT',PERCENT=>40);

9167: fnd_stats.gather_table_stats('PJI','PJI_PJP_PROJ_BATCH_MAP',PERCENT=>40);
9168: fnd_stats.gather_table_stats('PJI','PJI_TIME_CAL_PERIOD',PERCENT=>40);
9169: fnd_stats.gather_table_stats('PJI','PJI_TIME_CAL_RPT_STRUCT',PERCENT=>40);
9170: fnd_stats.gather_table_stats('PJI','PJI_TIME_ENT_PERIOD',PERCENT=>40);
9171: fnd_stats.gather_table_stats('PJI','PJI_TIME_RPT_STRUCT',PERCENT=>40);
9172:
9173: --End Bug 15881881
9174: if (l_plan_type_id = -1) then
9175: l_plan_type_id := null;

Line 9785: select /*+ ordered use_nl(acr map) index(cal PJI_TIME_RPT_STRUCT_N1) index(acr PJI_AC_XBS_ACCUM_F_N1) index(map PJI_PJP_PROJ_BATCH_MAP_N1) */ -- Modified for bug 15996434

9781: WORKER_ID = p_worker_id
9782: union all -- activity and snapshot reversals - PART 1 - ENT dates
9783: -- Select old ITD amounts for snapshots with
9784: -- reverse sign from base level fact
9785: select /*+ ordered use_nl(acr map) index(cal PJI_TIME_RPT_STRUCT_N1) index(acr PJI_AC_XBS_ACCUM_F_N1) index(map PJI_PJP_PROJ_BATCH_MAP_N1) */ -- Modified for bug 15996434
9786: distinct -- Bug 6689297
9787: p_worker_id WORKER_ID,
9788: acr.PROJECT_ID,
9789: acr.PROJECT_ORG_ID,

Line 9895: PJI_TIME_RPT_STRUCT cal,

9891: to_number(null) CUSTOM15
9892: from
9893: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434
9894: PJI_TIME_ENT_PERIOD_V ent,
9895: PJI_TIME_RPT_STRUCT cal,
9896: PJI_AC_XBS_ACCUM_F acr,
9897: PJI_PJP_PROJ_BATCH_MAP map,
9898: (
9899: select 'ACTIVITY' INVERT_ID from DUAL union all