APPS.PJI_FM_SUM_ACT dependencies on PJI_FM_EXTR_DINVCITM

Line 719: PJI_FM_EXTR_DINVCITM dii

715: dii.AR_APPR_INVOICE_COUNT AR_APPR_INVOICE_COUNT,
716: to_number(null) AR_COUNT_DUE,
717: to_number(null) AR_COUNT_OVERDUE
718: from
719: PJI_FM_EXTR_DINVCITM dii
720: where
721: dii.WORKER_ID = p_worker_id
722: union all
723: select /*+ parallel(ar) */ -- AR data in functional currency only

Line 825: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM' , 'NORMAL',null);

821: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
822: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG' , 'NORMAL',null);
823: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN' , 'NORMAL',null);
824: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC' , 'NORMAL',null);
825: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM' , 'NORMAL',null);
826: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV' , 'NORMAL',null);
827:
828: commit;
829: