APPS.EDW_MRP_DM_CLS_M_SIZE SQL Statements

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

Line: 17

      SELECT count(*)
        INTO p_num_rows
        FROM fnd_lookup_values fnd
       WHERE fnd.lookup_type='DEMAND_CLASS'
         AND fnd.language = userenv('LANG')
         AND fnd.view_application_id = 3
         AND fnd.security_group_id = 0
         AND fnd.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 51

         SELECT nvl(avg(nvl(vsize(lookup_code),0)),0),
   	        nvl(avg(nvl(vsize(description),0)),0),
	        nvl(avg(nvl(vsize(meaning),0)),0)
         FROM fnd_lookup_values
         WHERE last_update_date BETWEEN p_from_date AND p_to_date;