APPS.BIM_EDW_TGSMT_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_CELLS_VL AMC ,
	 EDW_BIM_TGSMT_DENORM BTD ,
	 EDW_LOCAL_INSTANCE INST
	WHERE AMC.CELL_ID = BTD.TARGET_SEGMENT_ID AND BTD.LEVEL_FROM_ROOT >= 8
	AND BTD.PARENT_LEVEL_FROM_ROOT = 7
        and amc.last_update_date between
        p_from_date  and  p_to_date
        );

Line: 58

	SELECT
	 avg(nvl(vsize(AMC.CELL_NAME), 0)),
	 avg(nvl(vsize(AMC.CELL_ID), 0)),
	 avg(nvl(vsize(AMC.CELL_CODE), 0)),
	 avg(nvl(vsize(AMC.MARKET_SEGMENT_FLAG), 0)),
	 avg(nvl(vsize(AMC.ENABLED_FLAG), 0)),
	 avg(nvl(vsize(AMC.ORIGINAL_SIZE), 0)),
	 avg(nvl(vsize(AMC.DESCRIPTION), 0))
        FROM AMS_CELLS_VL AMC
        WHERE
        amc.last_update_date between
        p_from_date  and  p_to_date;

Line: 74

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