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