APPS.PJI_FM_EXTR dependencies on PJI_FM_EXTR_ARINV

Line 3484: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_ARINV

3480: end if;
3481:
3482: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3483:
3484: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_ARINV
3485: ( WORKER_ID
3486: , ROW_ID
3487: , PROJECT_ID
3488: , PROJECT_ORG_ID

Line 3590: PJI_FM_EXTR_ARINV

3586: BATCH_ID,
3587: null,
3588: null
3589: from
3590: PJI_FM_EXTR_ARINV
3591: where
3592: PJI_SUMMARIZED_FLAG = 'O';
3593:
3594: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 3665: FROM PJI_FM_EXTR_ARINV ar

3661: UPDATE pa_draft_invoices_all dinv
3662: SET dinv.pji_summarized_flag = NULL
3663: WHERE dinv.rowid in (SELECT /*+ cardinality(ar, 1) */
3664: ar.row_id
3665: FROM PJI_FM_EXTR_ARINV ar
3666: WHERE 1 = 2 -- We will always extract
3667: -- the AR snapshots for now.
3668: AND ar.pji_summarized_flag = 'O'
3669: AND ar.batch_id = l_helper_batch_id);

Line 3788: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);

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);
3787:
3788: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);
3789:
3790: end CLEANUP;
3791:
3792: end PJI_FM_EXTR;