APPS.PJI_FM_EXTR dependencies on PJI_FM_REXT_CRDL

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

1695: degree => PJI_UTILS.
1696: GET_DEGREE_OF_PARALLELISM);
1697: end if;
1698:
1699: INSERT /*+ APPEND */ INTO PJI_FM_REXT_CRDL
1700: (
1701: WORKER_ID
1702: , CRDL_ROWID
1703: , PA_DATE

Line 1919: tabname => 'PJI_FM_REXT_CRDL',

1915: degree => PJI_UTILS.
1916: GET_DEGREE_OF_PARALLELISM);
1917: -- implicit commit
1918: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1919: tabname => 'PJI_FM_REXT_CRDL',
1920: percent => 10,
1921: degree => PJI_UTILS.
1922: GET_DEGREE_OF_PARALLELISM);
1923: end if;

Line 2277: PJI_FM_REXT_CRDL scope

2273: , to_number(null) AS EOU_UER
2274: , to_number(null) AS QUANTITY
2275: , to_number(null) AS BILL_QUANTITY
2276: FROM
2277: PJI_FM_REXT_CRDL scope
2278: , pa_cust_rev_dist_lines_all crdl
2279: , pa_expenditure_items_all ei
2280: , pa_expenditures_all exp
2281: , pa_expenditure_types et

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

2333: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);');
2334:
2335: -- truncate intermediate tables no longer required
2336: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2337: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL' , 'NORMAL',null);
2338:
2339: commit;
2340:
2341: end EXTRACT_BATCH_CDL_AND_CRDL;

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

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