APPS.BIM_EDW_OFFERS_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_act_offers aao ,
	qp_list_headers_vl qlh ,
	edw_local_instance inst
	WHERE aao.qp_list_header_id = qlh.list_header_id and
	((aao.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD'))
	or (qlh.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD')))
        and aao.last_update_date between
        p_from_date  and  p_to_date
	);

Line: 60

	SELECT
	avg(nvl(vsize(activity_offer_id ), 0)),
	avg(nvl(vsize(offer_code ), 0)),
	avg(nvl(vsize(offer_type ), 0)),
	avg(nvl(vsize(primary_offer_flag ), 0))
        FROM ams_act_offers
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 71

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

Line: 76

	select
	avg(nvl(vsize(name ), 0)),
	avg(nvl(vsize(list_header_id ), 0)),
	avg(nvl(vsize(description ), 0))
        FROM qp_list_headers_vl;