APPS.OPI_EDW_COGS_F_SZ dependencies on AMS_LIST_ENTRIES

Line 199: FROM ams_list_entries

195: WHERE last_update_date between p_from_date and p_to_date;
196:
197: CURSOR c_target IS
198: SELECT AVG(Nvl(Vsize(cell_code), 0))
199: FROM ams_list_entries
200: WHERE last_update_date between p_from_date and p_to_date;
201:
202: CURSOR c_campaign IS
203: SELECT AVG(Nvl(Vsize(user_status_id), 0))