DBA Data[Home] [Help]

APPS.BIM_EDW_MDCHN_M_SIZE dependencies on AMS_MEDIA_VL

Line 15: from ams_media_vl ame,

11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: from ams_media_vl ame,
16: edw_local_instance inst
17: where ame.last_update_date between
18: p_from_date and p_to_date
19: );

Line 60: FROM ams_media_vl

56: avg(nvl(vsize(inbound_flag ), 0)),
57: avg(nvl(vsize(enabled_flag ), 0)),
58: avg(nvl(vsize(media_name ), 0)),
59: avg(nvl(vsize(description ), 0))
60: FROM ams_media_vl
61: where last_update_date between
62: p_from_date and p_to_date;
63:
64: