APPS.BIM_EDW_SRCLSTS_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 18: edw_local_instance inst

14: select count(*) cnt
15: from
16: ams_imp_list_headers_all ail ,
17: ams_list_src_types als ,
18: edw_local_instance inst
19: WHERE
20: ail.list_source_type_id = als.list_source_type_id(+)
21: and ail.import_type = 'SOURCE'
22: and ail.last_update_date between

Line 97: from EDW_LOCAL_INSTANCE ;

93:
94: CURSOR c_2 IS
95: select
96: avg(nvl(vsize(INSTANCE_CODE), 0))
97: from EDW_LOCAL_INSTANCE ;
98:
99:
100: CURSOR c_3 IS
101: select