APPS.PJI_FM_EXTR dependencies on PJI_FM_REXT_ERDL

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

1778: end if;
1779:
1780: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then
1781:
1782: INSERT /*+ APPEND */ INTO PJI_FM_REXT_ERDL
1783: (
1784: WORKER_ID
1785: , ERDL_ROWID
1786: , PROJECT_ORG_ID

Line 2587: tabname => 'PJI_FM_REXT_ERDL',

2583: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2584: 'CURRENT_BATCH') = 1) then
2585: -- implicit commit
2586: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
2587: tabname => 'PJI_FM_REXT_ERDL',
2588: percent => 10,
2589: degree => PJI_UTILS.
2590: GET_DEGREE_OF_PARALLELISM);
2591: end if;

Line 2800: PJI_FM_REXT_ERDL scope

2796: , to_number(null) AS EOU_UER
2797: , to_number(null) AS QUANTITY
2798: , to_number(null) AS BILL_QUANTITY
2799: FROM
2800: PJI_FM_REXT_ERDL scope
2801: , pa_cust_event_rdl_all erdl
2802: WHERE
2803: scope.worker_id = p_worker_id
2804: and scope.erdl_rowid = erdl.rowid

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

2848: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);');
2849:
2850: -- truncate intermediate tables no longer required
2851: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2852: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL' , 'NORMAL',null);
2853:
2854: commit;
2855:
2856: end EXTRACT_BATCH_ERDL;

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

3791: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CDL', 'NORMAL',null);
3792:
3793: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);
3794:
3795: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);
3796:
3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3798:
3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);