APPS.OPI_EDW_OPMINV_DAILY_STAT_F_C dependencies on OPI_PMI_INV_DAILY_STAT_SUM

Line 183: OPI_PMI_INV_DAILY_STAT_SUM OPM

179: TRX_DATE,
180: 1,
181: L_SEQ_ID
182: FROM
183: OPI_PMI_INV_DAILY_STAT_SUM OPM
184: WHERE OPM.LAST_UPDATE_DATE BETWEEN g_push_from_date and g_push_to_date
185: AND CO_CODE||ORGN_CODE||WHSE_CODE||LOCATION||ITEM_ID||LOT_ID||TRX_DATE
186: not in
187: (SELECT PRIMARY_KEY||PRIMARY_KEY1||PRIMARY_KEY2||PRIMARY_KEY3||PRIMARY_KEY4

Line 563: UPDATE OPI_PMI_INV_DAILY_STAT_SUM

559: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
560: ' rows into the staging table');
561: edw_log.put_line(' ');
562: /* Update Data Which has been pushed */
563: UPDATE OPI_PMI_INV_DAILY_STAT_SUM
564: SET DATA_PUSHED_IND = 1
565: WHERE LAST_UPDATE_DATE BETWEEN g_push_from_date AND g_push_to_date AND
566: CO_CODE||ORGN_CODE||WHSE_CODE||LOCATION||ITEM_ID||LOT_ID||TRX_DATE
567: not in