APPS.EDW_OPI_OPRN_MOPM_SZ SQL Statements

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

Line: 10

    SELECT sum(cnt) into p_num_rows
    FROM  (SELECT count(*) cnt
           FROM FM_OPRN_CLS
           WHERE last_update_date between p_from_date and p_to_date
           UNION ALL
           SELECT count(*) cnt
           FROM FM_OPRN_MST
           WHERE last_update_date between p_from_date and p_to_date);

Line: 33

    x_last_update_date     NUMBER := x_date;

Line: 61

      select avg(nvl(vsize(instance_code),0))
      from edw_local_instance;

Line: 67

      SELECT
        avg(nvl(vsize(OPRN_CLASS||'-'||'-OPM'),0)),
        avg(nvl(vsize('OPRC'),0)),
        avg(nvl(vsize(OPRN_CLASS_DESC||'('||OPRN_CLASS||')'),0)),
        avg(nvl(vsize(OPRN_CLASS_DESC),0))
      FROM FM_OPRN_CLS
      WHERE LAST_UPDATE_DATE BETWEEN P_FROM_DATE AND P_TO_DATE;

Line: 78

      SELECT avg(nvl(vsize(OPRN_ID||'-'||'-OPM'),0)),
        avg(nvl(vsize('OPRN'),0)),
        avg(nvl(vsize(OPRN_NO),0)),
        avg(nvl(vsize(OPRN_DESC),0)),
        avg(nvl(vsize(PROCESS_QTY_UM),0))
      FROM FM_OPRN_MST
      WHERE LAST_UPDATE_DATE BETWEEN P_FROM_DATE AND P_TO_DATE;