APPS.OPI_EDW_OPI_ACTV_M_SZ SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

	select count(*) cnt
	FROM
	CST_ACTIVITIES
	where  last_update_date between p_from_date and p_to_date ;

Line: 32

	x_LAST_UPDATE_DATE NUMBER ;

Line: 39

	SELECT
	-- ACTV_PK need to add instance_code
	avg(nvl(vsize(ACTIVITY_ID), 0)),
	-- EDW_LOT_DP
	-- ACTV_CODE
	avg(nvl(vsize(ACTIVITY), 0)),
	-- Name
	avg(nvl(vsize(ACTIVITY), 0)) ,
	-- ACTV_NAME
	avg(nvl(vsize(ACTIVITY), 0)),
	-- DESCRIPTION
	avg(nvl(vsize(DESCRIPTION), 0)) ,
	-- COST_ANALYSIS_CODE
	-- VALUE_ADDED ??
	avg(nvl(vsize(VALUE_ADDED_ACTIVITY_FLAG), 0)) ,
	-- LAST_UPDATE_DATE
	avg(nvl(vsize(LAST_UPDATE_DATE), 0)),
	-- CREATION_DATE
	avg(nvl(vsize(CREATION_DATE), 0))
	FROM
	CST_ACTIVITIES
	WHERE
	last_update_date between p_from_date and p_to_date ;

Line: 64

	SELECT
		avg(nvl(vsize(instance_code), 0))
	FROM	EDW_LOCAL_INSTANCE ;

Line: 80

	x_LAST_UPDATE_DATE,
	x_CREATION_DATE  ;

Line: 93

	ceil(x_LAST_UPDATE_DATE + 1) +
	ceil(x_CREATION_DATE+ 1)   ;