APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_FP_AGGR_PJP0

Line 588: ,p_tabname => 'PJI_FP_AGGR_PJP0'

584: ,p_partname => 'P'||g_worker_id
585: ,p_percent => 10);
586:
587: GATHER_TEMP_STATS(p_ownname => l_pji_schema
588: ,p_tabname => 'PJI_FP_AGGR_PJP0'
589: ,p_partname => 'P'||g_worker_id
590: ,p_percent => 10);
591:
592: GATHER_TEMP_STATS(p_ownname => l_pji_schema

Line 5879: select /*+ parallel(PJI_FP_AGGR_PJP0) */

5875: sum(CUSTOM14) CUSTOM14,
5876: sum(CUSTOM15) CUSTOM15
5877: from
5878: (
5879: select /*+ parallel(PJI_FP_AGGR_PJP0) */
5880: WORKER_ID,
5881: to_char(null) LINE_TYPE,
5882: PROJECT_ID,
5883: PROJECT_ORG_ID,

Line 5954: PJI_FP_AGGR_PJP0

5950: to_number(null) CUSTOM13,
5951: to_number(null) CUSTOM14,
5952: to_number(null) CUSTOM15
5953: from
5954: PJI_FP_AGGR_PJP0
5955: where
5956: WORKER_ID = p_worker_id
5957: union all
5958: select /*+ parallel(PJI_FP_AGGR_PJP0) */

Line 5958: select /*+ parallel(PJI_FP_AGGR_PJP0) */

5954: PJI_FP_AGGR_PJP0
5955: where
5956: WORKER_ID = p_worker_id
5957: union all
5958: select /*+ parallel(PJI_FP_AGGR_PJP0) */
5959: WORKER_ID,
5960: to_char(null) LINE_TYPE,
5961: PROJECT_ID,
5962: PROJECT_ORG_ID,