APPS.EDW_MRP_FORECAST_M_SIZE SQL Statements

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

Line: 17

      SELECT count(*)
        INTO p_num_rows
        FROM mrp_forecast_designators fd,
	     mtl_parameters mp
       WHERE fd.forecast_set IS NOT NULL
	 AND fd.organization_id = mp.organization_id
         AND fd.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 62

         SELECT nvl(avg(nvl(vsize(organization_code),0)),0)
         FROM mtl_parameters;

Line: 66

         SELECT nvl(avg(nvl(vsize(forecast_designator),0)),0),
   	        nvl(avg(nvl(vsize(organization_id),0)),0),
	        nvl(avg(nvl(vsize(forecast_set),0)),0),
	        nvl(avg(nvl(vsize(description),0)),0),
	        nvl(avg(nvl(vsize(disable_date),0)),0)
         FROM mrp_forecast_designators
         WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 75

         SELECT nvl(avg(nvl(vsize(meaning),0)),0)
         FROM mfg_lookups;