APPS.BIM_EDW_SRCLSTS_M_SIZE dependencies on AMS_LIST_SRC_TYPES

Line 17: ams_list_src_types als ,

13: from (
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'

Line 103: from ams_list_src_types;

99:
100: CURSOR c_3 IS
101: select
102: avg(nvl(vsize(list_source_type), 0))
103: from ams_list_src_types;
104:
105: BEGIN
106:
107: dbms_output.enable(1000000);