APPS.BIM_EDW_OPPORTUNITIES_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 AS_LEAD_LINES_ALL OPL ,
	AS_LEADS_ALL OPH ,
	EDW_LOCAL_INSTANCE INST
	WHERE
	OPH.LEAD_ID = OPL.LEAD_ID AND ( (OPH.LAST_UPDATE_DATE > TO_DATE
	('1000/01/01',
	 'YYYY/MM/DD')) OR (OPL.LAST_UPDATE_DATE > TO_DATE('1000/01/01',
	 'YYYY/MM/DD')) ) AND ( OPH.DELETED_FLAG IS NULL OR OPH.DELETED_FLAG <> 'Y' )
        and oph.last_update_date between
        p_from_date  and  p_to_date
        );

Line: 53

	SELECT
	avg(nvl(vsize( LEAD_LINE_ID ), 0))
        FROM AS_LEAD_LINES_ALL;

Line: 59

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

Line: 64

	SELECT
	avg(nvl(vsize( LEAD_ID ), 0))
        FROM AS_LEADS_ALL
        where last_update_date between
        p_from_date  and  p_to_date;