APPS.OPI_EDW_OPI_LOT_M_SZ SQL Statements

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

Line: 8

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

Line: 31

	x_LAST_UPDATE_DATE NUMBER ;

Line: 39

	SELECT
	-- EDW_LOT_PK need to add instance_code
	avg(nvl(vsize(INVENTORY_ITEM_ID||ORGANIZATION_ID||LOT_NUMBER), 0)),
	-- EDW_LOT_DP
	-- Organization_id
	avg(nvl(vsize(ORGANIZATION_ID), 0)),
	-- Inventory_Item_id
	avg(nvl(vsize(Inventory_Item_id), 0)),
	-- Name
	avg(nvl(vsize(lot_number||Inventory_Item_ID||Organization_ID), 0)) ,
	-- LOT_NAME
	avg(nvl(vsize(lot_number), 0)),
	-- ITEM_REVISION
	-- NETTABLE_FLAG
	-- EXPIRATION_DATE
	avg(nvl(vsize(expiration_date), 0)),
	-- LOT_DESCRIPTION
	avg(nvl(vsize(lot_number), 0)) ,
	-- LAST_UPDATE_DATE
	avg(nvl(vsize(LAST_UPDATE_DATE), 0)),
	-- CREATION_DATE
	avg(nvl(vsize(CREATION_DATE), 0))
	FROM
	MTL_LOT_NUMBERS ;

Line: 64

	--last_update_date between p_from_date and p_to_date ;

Line: 67

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

Line: 85

	x_LAST_UPDATE_DATE ,
	x_CREATION_DATE  ;

Line: 99

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