APPS.BIM_EDW_EVENTS_M_SIZE dependencies on AMS_EVENT_HEADERS_ALL_B

Line 16: ams_event_headers_all_b aeh ,

12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM ams_event_offers_vl aeo ,
16: ams_event_headers_all_b aeh ,
17: edw_local_instance inst
18: WHERE
19: aeo.event_header_id = aeh.event_header_id and aeo.event_level = 'MAIN'
20: and ((aeo.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD'))

Line 188: ams_event_headers_all_b aeh ,

184: avg(nvl(vsize(aeo.event_offer_name), 0)),
185: avg(nvl(vsize(aeo.description), 0)),
186: avg(nvl(vsize(aeo.creation_date), 0))
187: FROM ams_event_offers_vl aeo ,
188: ams_event_headers_all_b aeh ,
189: edw_local_instance inst
190: WHERE
191: aeo.event_header_id = aeh.event_header_id and aeo.event_level = 'MAIN'
192: and ((aeo.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD'))