APPS.OPI_EDW_INV_DAILY_STAT_F_C dependencies on OPI_EDW_INV_DAILY_STAT_FSTG

Line 63: l_staging_table :='OPI_EDW_INV_DAILY_STAT_FSTG';

59:
60: BEGIN
61: --dbms_output.put_line('start of push ' || to_char(Sysdate, 'hh24:mi:ss') );
62: l_fact_name :='OPI_EDW_INV_DAILY_STAT_F';
63: l_staging_table :='OPI_EDW_INV_DAILY_STAT_FSTG';
64: l_exception_msg :=Null;
65: l_row_count := 0;
66: l_row_pushed := 0;
67: l_from_date := NULL;

Line 248: INSERT INTO opi_edw_inv_daily_stat_fstg(

244: -- --------------------------------------------------------
245: edw_log.put_line(' ');
246: edw_log.put_line('Insert into the local staging table');
247:
248: INSERT INTO opi_edw_inv_daily_stat_fstg(
249: AVG_INT_QTY
250: ,AVG_INT_VAL_B
251: ,AVG_INT_VAL_G
252: ,AVG_ONH_QTY