APPS.BIM_EDW_CMPSTATS_M_SIZE dependencies on AMS_USER_STATUSES_VL

Line 16: ams_user_statuses_vl aus ,

12: select sum(cnt)
13: from (
14: select count(*) cnt
15: from
16: ams_user_statuses_vl aus ,
17: edw_local_instance inst
18: WHERE aus.system_status_type = 'AMS_CAMPAIGN_STATUS' and
19: aus.last_update_date between
20: p_from_date and p_to_date

Line 72: FROM ams_user_statuses_vl

68: avg(nvl(vsize(END_DATE_ACTIVE), 0)),
69: avg(nvl(vsize(DESCRIPTION), 0)),
70: avg(nvl(vsize(CREATION_DATE), 0)),
71: avg(nvl(vsize(LAST_UPDATE_DATE), 0))
72: FROM ams_user_statuses_vl
73: where last_update_date between
74: p_from_date and p_to_date;
75:
76: