APPS.BIM_EDW_IH_OUTCM_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 JTF_IH_OUTCOMES_VL OTC ,
	EDW_LOCAL_INSTANCE INST
        where OTC.last_update_date between
        p_from_date  and  p_to_date
	);

Line: 51

	SELECT
	avg(nvl(vsize(OUTCOME_ID ), 0)),
	avg(nvl(vsize(SHORT_DESCRIPTION ), 0)),
	avg(nvl(vsize(OUTCOME_CODE ), 0)),
	avg(nvl(vsize(POSITIVE_OUTCOME_FLAG ), 0)),
	avg(nvl(vsize(LONG_DESCRIPTION ), 0))
        FROM JTF_IH_OUTCOMES_VL
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 63

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