APPS.BIM_EDW_IH_MEDIA_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_MEDIA_ITEMS JMI ,
	FND_LOOKUP_VALUES_VL LKP ,
	EDW_LOCAL_INSTANCE INST
	WHERE JMI.MEDIA_ITEM_TYPE = LKP.LOOKUP_CODE AND
	LKP.LOOKUP_TYPE = 'JTF_MEDIA_TYPE' AND LKP.VIEW_APPLICATION_ID = 0
        AND
        LKP.SECURITY_GROUP_ID=FND_GLOBAL.LOOKUP_SECURITY_GROUP( LKP.LOOKUP_CODE,
        LKP.VIEW_APPLICATION_ID )
        and jmi.last_update_date between
        p_from_date  and  p_to_date
	);

Line: 54

	SELECT
	avg(nvl(vsize(JMI.DIRECTION ), 0))
        FROM JTF_IH_MEDIA_ITEMS JMI
        where jmi.last_update_date between
        p_from_date  and  p_to_date;

Line: 62

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