APPS.PJI_FM_EXTR dependencies on PJI_FM_EXTR_ARINV

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

3493: end if;
3494:
3495: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3496:
3497: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_ARINV
3498: ( WORKER_ID
3499: , ROW_ID
3500: , PROJECT_ID
3501: , PROJECT_ORG_ID

Line 3603: PJI_FM_EXTR_ARINV

3599: BATCH_ID,
3600: null,
3601: null
3602: from
3603: PJI_FM_EXTR_ARINV
3604: where
3605: PJI_SUMMARIZED_FLAG = 'O';
3606:
3607: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 3678: FROM PJI_FM_EXTR_ARINV ar

3674: UPDATE pa_draft_invoices_all dinv
3675: SET dinv.pji_summarized_flag = NULL
3676: WHERE dinv.rowid in (SELECT /*+ cardinality(ar, 1) */
3677: ar.row_id
3678: FROM PJI_FM_EXTR_ARINV ar
3679: WHERE 1 = 2 -- We will always extract
3680: -- the AR snapshots for now.
3681: AND ar.pji_summarized_flag = 'O'
3682: AND ar.batch_id = l_helper_batch_id);

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

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);
3800:
3801: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);
3802:
3803: end CLEANUP;
3804:
3805: end PJI_FM_EXTR;