APPS.OPI_EDW_UOM_CONV_F_SZ SQL Statements

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

Line: 8

	select sum(cnt)
	from (select count(*) cnt
		FROM EDW_LOCAL_INSTANCE ELI, MTL_UOM_CONVERSIONS MUC,
		MTL_UNITS_OF_MEASURE MUOM, MTL_UNITS_OF_MEASURE BUOM,
		mtl_system_items_kfv msik
		WHERE
		muom.uom_code = muc.uom_code and
		muom.uom_class = muc.uom_class and
		muom.uom_class = buom.uom_class and
		buom.BASE_UOM_FLAG='Y' and
		msik.inventory_item_id (+) = MUC.INVENTORY_ITEM_ID and
		muom.last_update_date between p_from_date and p_to_date
		UNION
		select count(*) cnt
		FROM
		edw_local_instance eli,
		mtl_uom_class_conversions mucc ,
		mtl_system_items_kfv msik
		where
		mucc.from_uom_code <> mucc.to_uom_code and
		msik.inventory_item_id = MUCC.INVENTORY_ITEM_ID and
		mucc.last_update_date between p_from_date and p_to_date
		group by DECODE(MUCC.INVENTORY_ITEM_ID,0, 'STANDARD',
		TO_CHAR(MUCC.INVENTORY_ITEM_ID)) ||'-' ||
		MUCC.FROM_UOM_CODE||'-'||MUCC.TO_UOM_CODE||'-'||
		ELI.INSTANCE_CODE , MUCC.INVENTORY_ITEM_ID,
		MUCC.FROM_UOM_CODE, MUCC.TO_UOM_CODE,
		MUCC.CONVERSION_RATE, ELI.INSTANCE_CODE, MUCC.LAST_UPDATE_DATE, MUCC.CREATION_DATE ) ;

Line: 57

	x_LAST_UPDATE_DATE NUMBER ;

Line: 64

		SELECT
			--	x_UOM_CONV_PK NUMBER ;

Line: 85

			-- x_LAST_UPDATE_DATE NUMBER ;

Line: 86

			avg(nvl(vsize(MUC.LAST_UPDATE_DATE), 0)),
			-- x_CREATION_DATE NUMBER ;

Line: 102

			muom.last_update_date between p_from_date and p_to_date ;

Line: 113

			x_LAST_UPDATE_DATE,
			x_CREATION_DATE  ;

Line: 125

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