APPS.BIM_EDW_MDCHN_M_SIZE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

   select sum(cnt)
   from (
	select count(*) cnt
	from ams_media_vl ame,
	edw_local_instance inst
        where ame.last_update_date between
        p_from_date  and  p_to_date
	);

Line: 53

	SELECT
	avg(nvl(vsize(media_type_code ), 0)),
	avg(nvl(vsize(media_id ), 0)),
	avg(nvl(vsize(inbound_flag ), 0)),
	avg(nvl(vsize(enabled_flag ), 0)),
	avg(nvl(vsize(media_name ), 0)),
	avg(nvl(vsize(description ), 0))
        FROM ams_media_vl
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 66

	select
	 avg(nvl(vsize(INSTANCE_CODE), 0))
	 from EDW_LOCAL_INSTANCE ;