APPS.EDW_MRP_PLAN_M_SIZE dependencies on MTL_PARAMETERS

Line 20: mtl_parameters mp,

16:
17: SELECT count(*)
18: INTO p_num_rows
19: FROM mfg_lookups ml1,
20: mtl_parameters mp,
21: mrp_plans mpl
22: WHERE ml1.lookup_type = 'MRP_PLAN_TYPE'
23: AND ml1.lookup_code = mpl.plan_type
24: AND mp.organization_id=mpl.organization_id

Line 70: FROM mtl_parameters;

66: WHERE lookup_type = 'MRP_PLAN_TYPE';
67:
68: CURSOR c_2 IS
69: SELECT nvl(avg(nvl(vsize(organization_code),0)),0)
70: FROM mtl_parameters;
71:
72: CURSOR c_3 IS
73: SELECT nvl(avg(nvl(vsize(compile_designator),0)),0),
74: nvl(avg(nvl(vsize(organization_id),0)),0),