APPS.OPI_EDW_OPI_PRDL_M_SZ SQL Statements

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

Line: 8

	select count(*) cnt
	     FROM WIP_LINES WL,
		MTL_PARAMETERS MP
	     where WL.ORGANIZATION_ID = MP.ORGANIZATION_ID
		and wl.last_update_date between p_from_date and p_to_date;

Line: 32

    select avg(nvl(vsize(wl.line_id),0)) line_id,
	avg(nvl(vsize(wl.line_code),0))  code,
	avg(nvl(vsize(wl.description),0)) des
	from wip_lines wl
	where wl.last_update_date between p_from_date and p_to_date;

Line: 39

     SELECT avg(nvl(Vsize(organization_id), 0)) org_id,
       avg(nvl(Vsize(organization_code), 0))    org_code
       FROM mtl_parameters;

Line: 44

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