APPS.BIM_EDW_LEADS_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 AS_SALES_LEAD_LINES ASLL ,
	AS_SALES_LEADS ASL ,
	EDW_LOCAL_INSTANCE INST
	WHERE ASLL.SALES_LEAD_ID = ASL.SALES_LEAD_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.DELETED_FLAG IS NULL OR ASL.DELETED_FLAG <> 'Y' )
        and
        asl.last_update_date between
        p_from_date  and  p_to_date
        );

Line: 53

	SELECT
	avg(nvl(vsize( ASLL.SALES_LEAD_LINE_ID ), 0)),
	avg(nvl(vsize( ASL.SALES_LEAD_ID), 0))
        FROM AS_SALES_LEAD_LINES ASLL ,
        AS_SALES_LEADS ASL ,
        EDW_LOCAL_INSTANCE INST
        WHERE ASLL.SALES_LEAD_ID = ASL.SALES_LEAD_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.DELETED_FLAG IS NULL OR ASL.DELETED_FLAG <> 'Y' )
	AND ASL.last_update_date between
        p_from_date  and  p_to_date ;

Line: 68

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