APPS.PJI_FM_EXTR dependencies on PJI_FM_REXT_ERDL

Line 1775: INSERT /*+ APPEND */ INTO PJI_FM_REXT_ERDL

1771: end if;
1772:
1773: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then
1774:
1775: INSERT /*+ APPEND */ INTO PJI_FM_REXT_ERDL
1776: (
1777: WORKER_ID
1778: , ERDL_ROWID
1779: , PROJECT_ORG_ID

Line 2574: tabname => 'PJI_FM_REXT_ERDL',

2570: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2571: 'CURRENT_BATCH') = 1) then
2572: -- implicit commit
2573: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
2574: tabname => 'PJI_FM_REXT_ERDL',
2575: percent => 10,
2576: degree => PJI_UTILS.
2577: GET_DEGREE_OF_PARALLELISM);
2578: end if;

Line 2787: PJI_FM_REXT_ERDL scope

2783: , to_number(null) AS EOU_UER
2784: , to_number(null) AS QUANTITY
2785: , to_number(null) AS BILL_QUANTITY
2786: FROM
2787: PJI_FM_REXT_ERDL scope
2788: , pa_cust_event_rdl_all erdl
2789: WHERE
2790: scope.worker_id = p_worker_id
2791: and scope.erdl_rowid = erdl.rowid

Line 2839: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL' , 'NORMAL',null);

2835: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);');
2836:
2837: -- truncate intermediate tables no longer required
2838: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2839: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL' , 'NORMAL',null);
2840:
2841: commit;
2842:
2843: end EXTRACT_BATCH_ERDL;

Line 3782: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);

3778: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CDL', 'NORMAL',null);
3779:
3780: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);
3781:
3782: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);
3783:
3784: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3785:
3786: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);