APPS.PJI_FM_EXTR dependencies on PJI_FM_REXT_CRDL

Line 1706: INSERT /*+ APPEND */ INTO PJI_FM_REXT_CRDL

1702: degree => PJI_UTILS.
1703: GET_DEGREE_OF_PARALLELISM);
1704: end if;
1705:
1706: INSERT /*+ APPEND */ INTO PJI_FM_REXT_CRDL
1707: (
1708: WORKER_ID
1709: , CRDL_ROWID
1710: , PA_DATE

Line 1926: tabname => 'PJI_FM_REXT_CRDL',

1922: degree => PJI_UTILS.
1923: GET_DEGREE_OF_PARALLELISM);
1924: -- implicit commit
1925: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1926: tabname => 'PJI_FM_REXT_CRDL',
1927: percent => 10,
1928: degree => PJI_UTILS.
1929: GET_DEGREE_OF_PARALLELISM);
1930: end if;

Line 2289: PJI_FM_REXT_CRDL scope

2285: , to_number(null) AS QUANTITY
2286: , to_number(null) AS BILL_QUANTITY
2287: , ei.CBS_ELEMENT_ID AS CBS_ELEMENT_ID /* Added for CBS Changes */
2288: FROM
2289: PJI_FM_REXT_CRDL scope
2290: , pa_cust_rev_dist_lines_all crdl
2291: , pa_expenditure_items_all ei
2292: , pa_expenditures_all exp
2293: , pa_expenditure_types et

Line 2350: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL' , 'NORMAL',null);

2346: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);');
2347:
2348: -- truncate intermediate tables no longer required
2349: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2350: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL' , 'NORMAL',null);
2351:
2352: commit;
2353:
2354: end EXTRACT_BATCH_CDL_AND_CRDL;

Line 3793: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);

3789: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN', 'NORMAL',null);
3790:
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);