APPS.OPI_EDW_OPI_OPRN_M_SZ SQL Statements

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

Line: 8

     select sum(cnt)
       from (select count(*) cnt
	     FROM
	     BOM_OPERATION_SEQUENCES BOS,
	     BOM_OPERATIONAL_ROUTINGS BOR,
	     BOM_STANDARD_OPERATIONS bso
	     WHERE BOS.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID
	     AND bos.STANDARD_OPERATION_ID =  BSO.STANDARD_OPERATION_ID (+)
	     AND Greatest( bos.last_update_date, bor.last_update_date,
			   bso.last_update_date) between p_from_date and p_to_date
          UNION ALL
	     SELECT count(*) cnt
	     FROM dual
	     );

Line: 41

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

Line: 46

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

Line: 51

     SELECT   avg(nvl(vsize(operation_sequence_id), 0)) seq_id,
       avg(nvl(vsize(DEPARTMENT_ID), 0))      dept_id
       FROM bom_operation_sequences
       WHERE last_update_date between p_from_date  and  p_to_date;

Line: 57

     SELECT  avg(nvl(vsize(OPERATION_CODE), 0)) code,
       avg(nvl(vsize(OPERATION_DESCRIPTION), 0)) des
       FROM   bom_standard_operations
       WHERE last_update_date between p_from_date  and  p_to_date;