APPS.BIM_EDW_CMPSTATS_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_user_statuses_vl aus ,
	edw_local_instance inst
	WHERE aus.system_status_type = 'AMS_CAMPAIGN_STATUS' and
        aus.last_update_date between
        p_from_date  and  p_to_date
        );

Line: 54

 x_LAST_UPDATE_DATE NUMBER;

Line: 59

	SELECT
	 avg(nvl(vsize(NAME), 0)),
	 avg(nvl(vsize(USER_STATUS_ID), 0)),
	 avg(nvl(vsize(SYSTEM_STATUS_CODE), 0)),
	 avg(nvl(vsize(SYSTEM_STATUS_TYPE), 0)),
	 avg(nvl(vsize(ENABLED_FLAG), 0)),
	 avg(nvl(vsize(DEFAULT_FLAG), 0)),
	 avg(nvl(vsize(SEEDED_FLAG), 0)),
	 avg(nvl(vsize(START_DATE_ACTIVE), 0)),
	 avg(nvl(vsize(END_DATE_ACTIVE), 0)),
	 avg(nvl(vsize(DESCRIPTION), 0)),
	 avg(nvl(vsize(CREATION_DATE), 0)),
	 avg(nvl(vsize(LAST_UPDATE_DATE), 0))
	FROM ams_user_statuses_vl
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 79

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

Line: 102

	 x_LAST_UPDATE_DATE;

Line: 118

	 ceil(x_LAST_UPDATE_DATE + 1);