APPS.EDW_MRP_PLAN_M_SIZE SQL Statements

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

Line: 17

      SELECT count(*)
        INTO p_num_rows
        FROM mfg_lookups ml1,
 	     mtl_parameters mp,
 	     mrp_plans mpl
       WHERE ml1.lookup_type = 'MRP_PLAN_TYPE'
	 AND ml1.lookup_code = mpl.plan_type
	 AND mp.organization_id=mpl.organization_id
	 AND mpl.plan_completion_date IS NOT NULL
         AND mpl.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 61

    x_LAST_UPDATE_DATE		NUMBER;

Line: 64

         SELECT nvl(avg(nvl(vsize(meaning),0)),0)
         FROM mfg_lookups
	 WHERE lookup_type = 'MRP_PLAN_TYPE';

Line: 69

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

Line: 73

         SELECT nvl(avg(nvl(vsize(compile_designator),0)),0),
		nvl(avg(nvl(vsize(organization_id),0)),0),
		nvl(avg(nvl(vsize(description),0)),0),
		nvl(avg(nvl(vsize(consider_po),0)),0),
		nvl(avg(nvl(vsize(consider_wip),0)),0),
		nvl(avg(nvl(vsize(plan_completion_date),0)),0),
		nvl(avg(nvl(vsize(consider_reservations),0)),0),
		nvl(avg(nvl(vsize(plan_safety_stock),0)),0),
		nvl(avg(nvl(vsize(cutoff_date),0)),0),
		nvl(avg(nvl(vsize(creation_date),0)),0),
		nvl(avg(nvl(vsize(last_update_date),0)),0)
         FROM mrp_plans
         WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 103

			x_CREATION_DATE, x_LAST_UPDATE_DATE;

Line: 117

		 ceil(x_LAST_UPDATE_DATE + 1);