APPS.EDW_MRP_FORECAST_M_SIZE dependencies on MTL_PARAMETERS

Line 20: mtl_parameters mp

16:
17: SELECT count(*)
18: INTO p_num_rows
19: FROM mrp_forecast_designators fd,
20: mtl_parameters mp
21: WHERE fd.forecast_set IS NOT NULL
22: AND fd.organization_id = mp.organization_id
23: AND fd.last_update_date BETWEEN p_from_date AND p_to_date;
24:

Line 63: FROM mtl_parameters;

59: x_SET_DISABLE_DATE NUMBER;
60:
61: CURSOR c_1 IS
62: SELECT nvl(avg(nvl(vsize(organization_code),0)),0)
63: FROM mtl_parameters;
64:
65: CURSOR c_2 IS
66: SELECT nvl(avg(nvl(vsize(forecast_designator),0)),0),
67: nvl(avg(nvl(vsize(organization_id),0)),0),