APPS.OPI_EDW_COGS_F_SZ dependencies on AMS_ACT_OFFERS

Line 194: FROM ams_act_offers

190: FROM gl_sets_of_books;
191:
192: CURSOR c_offer IS
193: SELECT AVG(Nvl(Vsize(activity_offer_id), 0))
194: FROM ams_act_offers
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))