APPS.PJI_FM_SUM_ROLLUP_FIN dependencies on PJI_FM_AGGR_FIN3

Line 687: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i

683: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_SLICES(p_worker_id);')) then
684: return;
685: end if;
686:
687: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i
688: (
689: WORKER_ID,
690: PROJECT_ID,
691: PROJECT_ORG_ID,

Line 1814: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_EN

1810:
1811: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1812: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
1813:
1814: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_EN
1815: (
1816: WORKER_ID,
1817: PROJECT_ID,
1818: PROJECT_ORG_ID,

Line 1953: PJI_FM_AGGR_FIN3 fin

1949: to_number(null) FORECAST_BURDENED_COST,
1950: to_number(null) FORECAST_LABOR_HRS
1951: from
1952: FII_TIME_DAY time,
1953: PJI_FM_AGGR_FIN3 fin
1954: where
1955: fin.WORKER_ID = p_worker_id and
1956: fin.PERIOD_TYPE_ID = 1 and
1957: fin.CALENDAR_TYPE = 'C' and

Line 2202: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_PA

2198:
2199: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2200: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2201:
2202: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_PA
2203: (
2204: WORKER_ID,
2205: PROJECT_ID,
2206: PROJECT_ORG_ID,

Line 2341: PJI_FM_AGGR_FIN3 fin

2337: to_number(null) FORECAST_BURDENED_COST,
2338: to_number(null) FORECAST_LABOR_HRS
2339: from
2340: FII_TIME_CAL_DAY_MV time,
2341: PJI_FM_AGGR_FIN3 fin
2342: where
2343: fin.WORKER_ID = p_worker_id and
2344: fin.PERIOD_TYPE_ID = 1 and
2345: fin.CALENDAR_TYPE = 'P' and

Line 2589: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_GL

2585:
2586: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2587: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2588:
2589: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_GL
2590: (
2591: WORKER_ID,
2592: PROJECT_ID,
2593: PROJECT_ORG_ID,

Line 2731: PJI_FM_AGGR_FIN3 fin

2727: to_number(null) FORECAST_BURDENED_COST,
2728: to_number(null) FORECAST_LABOR_HRS
2729: from
2730: FII_TIME_CAL_DAY_MV time,
2731: PJI_FM_AGGR_FIN3 fin
2732: where
2733: fin.WORKER_ID = p_worker_id and
2734: fin.PERIOD_TYPE_ID = 1 and
2735: fin.CALENDAR_TYPE = 'C' and

Line 2982: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_WK

2978:
2979: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2980: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2981:
2982: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_WK
2983: (
2984: WORKER_ID,
2985: PROJECT_ID,
2986: PROJECT_ORG_ID,

Line 3097: PJI_FM_AGGR_FIN3 fin

3093: to_number(null) FORECAST_BURDENED_COST,
3094: to_number(null) FORECAST_LABOR_HRS
3095: from
3096: FII_TIME_DAY time,
3097: PJI_FM_AGGR_FIN3 fin
3098: where
3099: fin.WORKER_ID = p_worker_id and
3100: fin.PERIOD_TYPE_ID = 1 and
3101: fin.CALENDAR_TYPE = 'C' and

Line 4420: PJI_FM_AGGR_FIN3 fin3

4416: l_creation_date,
4417: l_created_by,
4418: l_last_update_login
4419: from
4420: PJI_FM_AGGR_FIN3 fin3
4421: where
4422: fin3.WORKER_ID = p_worker_id and
4423: (nvl(fin3.REVENUE , 0) <> 0 or
4424: nvl(fin3.LABOR_REVENUE , 0) <> 0 or

Line 4583: PJI_FM_AGGR_FIN3 fin3

4579: fin3.FORECAST_RAW_COST,
4580: fin3.FORECAST_BURDENED_COST,
4581: fin3.FORECAST_LABOR_HRS
4582: from
4583: PJI_FM_AGGR_FIN3 fin3
4584: where
4585: fin3.WORKER_ID = p_worker_id
4586: union all -- partial refresh
4587: select /*+ ordered full(map) parallel(map)

Line 4973: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN3' , 'NORMAL',null);

4969: );
4970:
4971: -- truncate intermediate tables no longer required
4972: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4973: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN3' , 'NORMAL',null);
4974:
4975: commit;
4976:
4977: end MERGE_FIN_INTO_FPP;