DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_AC_CUST_PJP0

Line 9164: fnd_stats.gather_table_stats('PJI','PJI_AC_CUST_PJP0',PERCENT=>40);

9160: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_process, 'PLAN_TYPE_ID');
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);

Line 9415: PJI_AC_CUST_PJP0

9411: CUSTOM13,
9412: CUSTOM14,
9413: CUSTOM15
9414: from
9415: PJI_AC_CUST_PJP0
9416: where
9417: WORKER_ID = p_worker_id
9418: union all -- partial refresh reversals
9419: select /*+ full(map) use_nl(acr) */

Line 9779: PJI_AC_CUST_PJP0

9775: CUSTOM13,
9776: CUSTOM14,
9777: CUSTOM15
9778: from
9779: PJI_AC_CUST_PJP0
9780: where
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

Line 20335: 'PJI_AC_CUST_PJP0',

20331: l_tab5 := 'Y';
20332: end if;
20333: if l_tab6 = 'N' then
20334: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
20335: 'PJI_AC_CUST_PJP0',
20336: 'PARTITION',
20337: 'P' || p_worker_id);
20338: l_tab6 := 'Y';
20339: end if;