APPS.BIM_EDW_SRCLSTS_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_imp_list_headers_all ail ,
	ams_list_src_types als ,
	edw_local_instance inst
	WHERE
	ail.list_source_type_id = als.list_source_type_id(+)
	and ail.import_type = 'SOURCE'
        and ail.last_update_date between
        p_from_date  and  p_to_date
	);

Line: 70

	SELECT
	avg(nvl(vsize( name ), 0)),
	avg(nvl(vsize( import_list_header_id ), 0)),
	avg(nvl(vsize( list_source_type_id ), 0)),
	avg(nvl(vsize( user_status_id ), 0)),
	avg(nvl(vsize( status_code ), 0)),
	avg(nvl(vsize( status_date ), 0)),
	avg(nvl(vsize( vendor_id ), 0)),
	avg(nvl(vsize( transactional_cost ), 0)),
	avg(nvl(vsize( transactional_currency_code ), 0)),
	avg(nvl(vsize( functional_cost ), 0)),
	avg(nvl(vsize( functional_currency_code ), 0)),
	avg(nvl(vsize( pin_id ), 0)),
	avg(nvl(vsize( org_id ), 0)),
	avg(nvl(vsize( source_system ), 0)),
	avg(nvl(vsize( keywords ), 0)),
	avg(nvl(vsize( description ), 0))
	from
	ams_imp_list_headers_all
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 95

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

Line: 101

        select
	avg(nvl(vsize(list_source_type), 0))
        from ams_list_src_types;