APPS.BIM_EDW_EVENTS_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 17: edw_local_instance inst

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'))
21: or

Line 29: edw_local_instance inst

25: p_from_date and p_to_date
26: UNION
27: select count(*)
28: FROM ams_event_headers_vl aeh ,
29: edw_local_instance inst
30: WHERE
31: aeh.event_level = 'MAIN' and
32: aeh.last_update_date between
33: p_from_date and p_to_date

Line 189: edw_local_instance inst

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'))
193: or

Line 200: from EDW_LOCAL_INSTANCE ;

196:
197: CURSOR c_2 IS
198: select
199: avg(nvl(vsize(INSTANCE_CODE), 0))
200: from EDW_LOCAL_INSTANCE ;
201:
202:
203:
204: BEGIN