APPS.EDW_MRP_FORECAST_M_SIZE dependencies on MRP_FORECAST_DESIGNATORS

Line 19: FROM mrp_forecast_designators fd,

15: BEGIN
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;

Line 71: FROM mrp_forecast_designators

67: nvl(avg(nvl(vsize(organization_id),0)),0),
68: nvl(avg(nvl(vsize(forecast_set),0)),0),
69: nvl(avg(nvl(vsize(description),0)),0),
70: nvl(avg(nvl(vsize(disable_date),0)),0)
71: FROM mrp_forecast_designators
72: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
73:
74: CURSOR c_3 IS
75: SELECT nvl(avg(nvl(vsize(meaning),0)),0)