eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_EDW_SRCLSTS_M_SIZE dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 16: ams_imp_list_headers_all ail ,

12: select sum(cnt)
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(+)

Line 88: ams_imp_list_headers_all

84: avg(nvl(vsize( source_system ), 0)),
85: avg(nvl(vsize( keywords ), 0)),
86: avg(nvl(vsize( description ), 0))
87: from
88: ams_imp_list_headers_all
89: where last_update_date between
90: p_from_date and p_to_date;
91:
92: