APPS.EDW_OPI_LOT_MOPM_SZ SQL Statements

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

Line: 10

    SELECT count(*) into p_num_rows
    FROM IC_LOTS_MST LT
    WHERE lt.last_update_date between p_from_date and p_to_date;

Line: 36

    x_last_update_date     NUMBER := x_date;

Line: 39

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

Line: 43

      SELECT avg(nvl(vsize(LT.LOT_NO),0)) LOT_NO,
             avg(nvl(vsize(LT.SUBLOT_NO),0)) SUBLOT_NO,
             avg(nvl(vsize(LT.LOT_DESC),0)) LOT_DESC,
             avg(nvl(vsize(LOT_NO||DECODE(SUBLOT_NO,NULL,NULL,'-'||SUBLOT_NO) ||'('|| IIM.ITEM_NO ||')'),0)) NAME,
             avg(nvl(vsize(LT.LOT_ID||'-'||LT.ITEM_ID||'-'||'OPM'||'-'),0)) LOT_PK,
             avg(vsize('LOTD'))
      FROM IC_LOTS_MST LT,
           IC_ITEM_MST IIM
      WHERE LT.ITEM_ID = IIM.ITEM_ID
        AND LT.LAST_UPDATE_DATE BETWEEN P_FROM_DATE AND P_TO_DATE;