APPS.OPI_EDW_OPMINV_DAILY_STAT_F_C dependencies on OPI_EDW_OPMINV_DAILY_STAT_FCV

Line 113: OPI_EDW_OPMINV_DAILY_STAT_FCV

109: TRX_DATE,
110: 1,
111: NULL
112: FROM
113: OPI_EDW_OPMINV_DAILY_STAT_FCV
114: WHERE
115: INV_DAILY_STATUS_PK in ( SELECT INV_DAILY_STATUS_PK
116: FROM opi_edw_inv_daily_stat_fstg
117: WHERE COLLECTION_STATUS in ('RATE NOT AVAILABLE','INVALID CURRENCY')

Line 443: FROM opi_edw_opminv_daily_stat_fcv

439: ,TRX_DATE
440: ,PERIOD_FLAG
441: ,NULL
442: ,DECODE(END_ONH_VAL_G,-1,'RATE NOT AVAILABLE',-2,'INVALID CURRENCY','LOCAL READY')
443: FROM opi_edw_opminv_daily_stat_fcv
444: WHERE view_id=p_view_id
445: AND seq_id = p_seq_id;
446: l_no_rows := sql%rowcount;
447: /* Push Currency Conversion Missing Rows */