APPS.BIM_EDW_CMPGNS_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 AMS_CAMPAIGN_SCHEDULES AMS ,
	 AMS_CAMPAIGNS_VL AMC ,
	 EDW_LOCAL_INSTANCE INST
	WHERE AMS.CAMPAIGN_ID = AMC.CAMPAIGN_ID
	and
	AMS.last_update_date between
        p_from_date  and  p_to_date
        );

Line: 58

 x_LAST_UPDATE_DATE  NUMBER;

Line: 63

	SELECT
	avg(nvl(vsize( CAMPAIGN_SCHEDULE_ID ), 0)),
	avg(nvl(vsize( CAMPAIGN_ID), 0)),
	avg(nvl(vsize( SOURCE_CODE), 0)),
	avg(nvl(vsize( FREQUENCY), 0)),
	avg(nvl(vsize( FREQUENCY_UOM_CODE), 0)),
	avg(nvl(vsize( DELIVERABLE_ID), 0)),
	avg(nvl(vsize( ACTIVITY_OFFER_ID), 0)),
	avg(nvl(vsize( FORECASTED_START_DATE_TIME), 0)),
	avg(nvl(vsize( FORECASTED_END_DATE_TIME), 0)),
	avg(nvl(vsize( ACTUAL_START_DATE_TIME), 0)),
	avg(nvl(vsize( ACTUAL_END_DATE_TIME), 0)),
	avg(nvl(vsize( CREATION_DATE), 0)),
	avg(nvl(vsize( LAST_UPDATE_DATE ), 0))
	FROM AMS_CAMPAIGN_SCHEDULES
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 84

	select
	 avg(nvl(vsize(campaign_id), 0))
	 from AMS_CAMPAIGNS_VL  ;

Line: 90

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

Line: 114

	 x_LAST_UPDATE_DATE;

Line: 131

		ceil(	 x_LAST_UPDATE_DATE +1);