APPS.BIM_EDW_OFFERS_M_SIZE dependencies on AMS_ACT_OFFERS

Line 15: from ams_act_offers aao ,

11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: from ams_act_offers aao ,
16: qp_list_headers_vl qlh ,
17: edw_local_instance inst
18: WHERE aao.qp_list_header_id = qlh.list_header_id and
19: ((aao.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD'))

Line 65: FROM ams_act_offers

61: avg(nvl(vsize(activity_offer_id ), 0)),
62: avg(nvl(vsize(offer_code ), 0)),
63: avg(nvl(vsize(offer_type ), 0)),
64: avg(nvl(vsize(primary_offer_flag ), 0))
65: FROM ams_act_offers
66: where last_update_date between
67: p_from_date and p_to_date;
68:
69: