APPS.EDW_OE_SLCHNL_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='SALES_CHANNEL'
	 AND fnd.language = userenv('LANG')
	 AND fnd.view_application_id = 660
	 AND fnd.security_group_id = 0
         AND fnd.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 52

    x_LAST_UPDATE_DATE		NUMBER;

Line: 55

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

Line: 71

			x_CREATION_DATE, x_LAST_UPDATE_DATE;

Line: 80

		 ceil(x_CREATION_DATE + 1) + ceil(x_LAST_UPDATE_DATE + 1);