APPS.BIM_EDW_INTRCTNS_F_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_ACTIVITIES JIA,
	 JTF_IH_INTERACTIONS JII,
	 HZ_PARTY_SITES HPS,
	 EDW_BIM_SOURCE_CODE_DETAILS BSCD,
	 BIM_EDW_INTRCTNS_INC INC,
	 EDW_LOCAL_INSTANCE INST
        WHERE JIA.INTERACTION_ID = JII.INTERACTION_ID
         AND JII.PARTY_ID = HPS.PARTY_ID (+)
	 AND HPS.IDENTIFYING_ADDRESS_FLAG(+) = 'Y'
         AND JIA.ACTIVITY_ID = INC.PRIMARY_KEY
	 AND NVL(JIA.SOURCE_CODE_ID, -999) = BSCD.SOURCE_CODE_ID
	 and
	 JIA.last_update_date between
         p_from_date  and  p_to_date
        );

Line: 65

	SELECT
	avg(nvl(vsize( ACTIVITY_ID ), 0)),
	avg(nvl(vsize( INTERACTION_ID), 0)),
	avg(nvl(vsize( DURATION), 0)),
	avg(nvl(vsize( SOURCE_CODE), 0))
	FROM JTF_IH_ACTIVITIES
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 77

	select
	 avg(nvl(vsize(CAMPAIGN_FK), 0)),
	 avg(nvl(vsize(EVENT_FK), 0)),
	 avg(nvl(vsize(MEDIA_CHANNEL_FK), 0)),
	 avg(nvl(vsize(OFFER_FK), 0))
	 from EDW_BIM_SOURCE_CODE_DETAILS  ;

Line: 86

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