eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_TIME_C

Line 3004: PJI_TIME_C.LOAD(null, null, l_return_status, l_msg_count, l_msg_data);

3000: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);')) then
3001: return;
3002: end if;
3003:
3004: PJI_TIME_C.LOAD(null, null, l_return_status, l_msg_count, l_msg_data);
3005:
3006: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);');
3007:
3008: commit;

Line 9168: fnd_stats.gather_table_stats('PJI','PJI_TIME_CAL_PERIOD',PERCENT=>40);

9164: fnd_stats.gather_table_stats('PJI','PJI_AC_CUST_PJP0',PERCENT=>40);
9165: fnd_stats.gather_table_stats('PJI','PJI_AC_XBS_ACCUM_F',PERCENT=>40);
9166: fnd_stats.gather_table_stats('PJI','PJI_ORG_EXTR_INFO',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:

Line 9169: fnd_stats.gather_table_stats('PJI','PJI_TIME_CAL_RPT_STRUCT',PERCENT=>40);

9165: fnd_stats.gather_table_stats('PJI','PJI_AC_XBS_ACCUM_F',PERCENT=>40);
9166: fnd_stats.gather_table_stats('PJI','PJI_ORG_EXTR_INFO',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

Line 9928: select /+ ordered use_nl(acr map) full(info) index(cal PJI_TIME_CAL_RPT_STRUCT_N1) index(acr PJI_AC_XBS_ACCUM_F_N1) index(map PJI_PJP_PROJ_BATCH_MAP_N1) / -- Modified for bug 15996434

9924: abs(nvl(acr.AR_COUNT_OVERDUE,0)) > 0
9925: union all -- activity and snapshot reversals - PART 2 - GL dates
9926: -- Select old ITD amounts for snapshots with
9927: -- reverse sign from base level fact
9928: select /*+ ordered use_nl(acr map) full(info) index(cal PJI_TIME_CAL_RPT_STRUCT_N1) index(acr PJI_AC_XBS_ACCUM_F_N1) index(map PJI_PJP_PROJ_BATCH_MAP_N1) */ -- Modified for bug 15996434
9929: distinct -- Bug 6689297
9930: p_worker_id WORKER_ID,
9931: acr.PROJECT_ID,
9932: acr.PROJECT_ORG_ID,

Line 10039: PJI_TIME_CAL_PERIOD_V gl_cal,

10035: from
10036: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434
10037: PJI_AC_XBS_ACCUM_F acr,
10038: PJI_ORG_EXTR_INFO info,
10039: PJI_TIME_CAL_PERIOD_V gl_cal,
10040: PJI_TIME_CAL_RPT_STRUCT cal,
10041: PJI_PJP_PROJ_BATCH_MAP map,
10042: (
10043: select 'ACTIVITY' INVERT_ID from DUAL union all

Line 10040: PJI_TIME_CAL_RPT_STRUCT cal,

10036: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434
10037: PJI_AC_XBS_ACCUM_F acr,
10038: PJI_ORG_EXTR_INFO info,
10039: PJI_TIME_CAL_PERIOD_V gl_cal,
10040: PJI_TIME_CAL_RPT_STRUCT cal,
10041: PJI_PJP_PROJ_BATCH_MAP map,
10042: (
10043: select 'ACTIVITY' INVERT_ID from DUAL union all
10044: select 'SNAPSHOT' INVERT_ID from DUAL

Line 10075: select /+ ordered use_nl(acr map) full(info) index(cal PJI_TIME_CAL_RPT_STRUCT_N1) index(acr PJI_AC_XBS_ACCUM_F_N1) index(map PJI_PJP_PROJ_BATCH_MAP_N1) / -- Modified for bug 15996434

10071: abs(nvl(acr.AR_COUNT_OVERDUE,0)) > 0
10072: union all -- activity and snapshot reversals - PART 3 - PA dates
10073: -- Select old ITD amounts for snapshots with
10074: -- reverse sign from base level fact
10075: select /*+ ordered use_nl(acr map) full(info) index(cal PJI_TIME_CAL_RPT_STRUCT_N1) index(acr PJI_AC_XBS_ACCUM_F_N1) index(map PJI_PJP_PROJ_BATCH_MAP_N1) */ -- Modified for bug 15996434
10076: distinct -- Bug 6689297
10077: p_worker_id WORKER_ID,
10078: acr.PROJECT_ID,
10079: acr.PROJECT_ORG_ID,

Line 10186: PJI_TIME_CAL_PERIOD_V pa_cal,

10182: from
10183: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434
10184: PJI_AC_XBS_ACCUM_F acr,
10185: PJI_ORG_EXTR_INFO info,
10186: PJI_TIME_CAL_PERIOD_V pa_cal,
10187: PJI_TIME_CAL_RPT_STRUCT cal,
10188: PJI_PJP_PROJ_BATCH_MAP map,
10189: (
10190: select 'ACTIVITY' INVERT_ID from DUAL union all

Line 10187: PJI_TIME_CAL_RPT_STRUCT cal,

10183: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434
10184: PJI_AC_XBS_ACCUM_F acr,
10185: PJI_ORG_EXTR_INFO info,
10186: PJI_TIME_CAL_PERIOD_V pa_cal,
10187: PJI_TIME_CAL_RPT_STRUCT cal,
10188: PJI_PJP_PROJ_BATCH_MAP map,
10189: (
10190: select 'ACTIVITY' INVERT_ID from DUAL union all
10191: select 'SNAPSHOT' INVERT_ID from DUAL