APPS.BIM_EDW_LEADS_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 AS_SALES_LEAD_LINES ASLL,
	 AS_SALES_LEADS ASL,
	 EDW_BIM_SOURCE_CODE_DETAILS BSCD,
	 BIM_EDW_LEADS_INC INC,
	 EDW_LOCAL_INSTANCE INST
        WHERE ASL.SALES_LEAD_ID = ASLL.SALES_LEAD_ID
         AND ASLL.SALES_LEAD_LINE_ID = INC.PRIMARY_KEY
         AND NVL(ASLL.SOURCE_PROMOTION_ID,
	 -999) = BSCD.SOURCE_CODE_ID AND ( ( ASL.LAST_UPDATE_DATE
	> TO_DATE( '1000/01/01',
	 'YYYY/MM/DD' ) ) OR ( ASLL.LAST_UPDATE_DATE > TO_DATE(
	'1000/01/01',
	 'YYYY/MM/DD' ) ) )
	and
	ASL.last_update_date between
        p_from_date  and  p_to_date
        );

Line: 69

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

Line: 76

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

Line: 84

	select
	 avg(nvl(vsize(STATUS_CODE), 0)),
	 avg(nvl(vsize(CUSTOMER_ID), 0)),
	 avg(nvl(vsize(CURRENCY_CODE), 0)),
	 avg(nvl(vsize(ADDRESS_ID), 0))
	 from AS_SALES_LEADS
         where last_update_date between
         p_from_date  and  p_to_date;

Line: 95

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