APPS.BIM_EDW_OPRNTIES_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_LEAD_LINES_ALL ASLL,
	 AS_LEADS_ALL ASL,
	 EDW_BIM_SOURCE_CODE_DETAILS BSCD,
	 BIM_EDW_OPRNTIES_INC INC,
	 EDW_LOCAL_INSTANCE INST
	WHERE ASL.LEAD_ID = ASLL.LEAD_ID
	 AND ASLL.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: 72

	SELECT
	avg(nvl(vsize( LEAD_LINE_ID ), 0)),
	avg(nvl(vsize( OFFER_ID ), 0)),
	avg(nvl(vsize( ORG_ID ), 0)),
	avg(nvl(vsize( TOTAL_AMOUNT ), 0)),
	avg(nvl(vsize( QUANTITY ), 0))
	FROM AS_LEAD_LINES_ALL
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 83

	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: 91

	select
	 avg(nvl(vsize(STATUS_CODE), 0)),
	 avg(nvl(vsize(CUSTOMER_ID), 0)),
	 avg(nvl(vsize(CURRENCY_CODE), 0)),
	 avg(nvl(vsize(CHANNEL_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: 103

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