APPS.BIM_EDW_MKTSGMTS_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_CELLS_VL AMC ,
	EDW_LOCAL_INSTANCE INST
	WHERE AMC.MARKET_SEGMENT_FLAG = 'Y'
        and amc.last_update_date between
        p_from_date  and  p_to_date
        );

Line: 53

	SELECT
	avg(nvl(vsize( CELL_NAME ), 0)),
	avg(nvl(vsize( CELL_ID), 0)),
	avg(nvl(vsize( CELL_CODE), 0)),
	avg(nvl(vsize( ENABLED_FLAG), 0)),
	avg(nvl(vsize( DESCRIPTION), 0))
	FROM AMS_CELLS_VL AMC
	WHERE AMC.MARKET_SEGMENT_FLAG = 'Y'
        and last_update_date between
        p_from_date  and  p_to_date;

Line: 66

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