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_AC_XBS_ACCUM_F

Line 9165: fnd_stats.gather_table_stats('PJI','PJI_AC_XBS_ACCUM_F',PERCENT=>40);

9161:
9162: -- Bug 15881881
9163: fnd_stats.gather_table_stats('PJI','PJI_AC_AGGR_PJP0',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);

Line 9476: PJI_AC_XBS_ACCUM_F acr

9472: - acr.CUSTOM14 CUSTOM14,
9473: - acr.CUSTOM15 CUSTOM15
9474: from
9475: PJI_PJP_PROJ_BATCH_MAP map,
9476: PJI_AC_XBS_ACCUM_F acr
9477: where
9478: l_extraction_type = 'PARTIAL' and
9479: map.WORKER_ID = p_worker_id and
9480: acr.PROJECT_ID = map.PROJECT_ID and

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 9896: PJI_AC_XBS_ACCUM_F acr,

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
9900: select 'SNAPSHOT' INVERT_ID from DUAL

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 10037: PJI_AC_XBS_ACCUM_F acr,

10033: to_number(null) CUSTOM14,
10034: to_number(null) CUSTOM15
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,

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 10184: PJI_AC_XBS_ACCUM_F acr,

10180: to_number(null) CUSTOM14,
10181: to_number(null) CUSTOM15
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,

Line 14728: PJI_AC_XBS_ACCUM_F acr,

14724: PJI_PA_PROJ_EVENTS_LOG log,
14725: PJI_PJP_WBS_HEADER wbs_hdr,
14726: PJI_XBS_DENORM_DELTA wbs,
14727: PJI_XBS_DENORM prg,
14728: PJI_AC_XBS_ACCUM_F acr,
14729: (
14730: select 1 WBS_SUP_LEVEL,
14731: 1 WBS_SUB_LEVEL,
14732: 'PRJ' INVERT_ID

Line 15360: PJI_AC_XBS_ACCUM_F acr,

15356: PA_PJI_PROJ_EVENTS_LOG log,
15357: PJI_PJP_WBS_HEADER wbs_hdr,
15358: PJI_XBS_DENORM_DELTA_T wbs,
15359: PJI_XBS_DENORM prg,
15360: PJI_AC_XBS_ACCUM_F acr,
15361: (
15362: select 1 WBS_SUP_LEVEL,
15363: 1 WBS_SUB_LEVEL,
15364: 'PRJ' INVERT_ID

Line 17015: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

17011: sum(pjp.CUSTOM14) CUSTOM14,
17012: sum(pjp.CUSTOM15) CUSTOM15
17013: from
17014: (
17015: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
17016: -- get structure level amounts from Reporting Lines
17017: /*prg.SUP_PROJECT_ID,
17018: prg.SUP_ID,
17019: prg.SUP_EMT_ID,

Line 17076: PJI_AC_XBS_ACCUM_F acr

17072: from
17073: PJI_XBS_DENORM_DELTA prg,
17074: PA_PROJ_ELEMENTS prj_emt,
17075: PJI_PJP_WBS_HEADER wbs_hdr,
17076: PJI_AC_XBS_ACCUM_F acr
17077: where
17078: prg.WORKER_ID = p_worker_id and
17079: prg.STRUCT_TYPE = 'PRG' and
17080: prg.RELATIONSHIP_TYPE = 'LF' and