APPS.EDW_MRP_PLAN_M_SIZE dependencies on MFG_LOOKUPS

Line 19: FROM mfg_lookups ml1,

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

Line 65: FROM mfg_lookups

61: x_LAST_UPDATE_DATE NUMBER;
62:
63: CURSOR c_1 IS
64: SELECT nvl(avg(nvl(vsize(meaning),0)),0)
65: FROM mfg_lookups
66: WHERE lookup_type = 'MRP_PLAN_TYPE';
67:
68: CURSOR c_2 IS
69: SELECT nvl(avg(nvl(vsize(organization_code),0)),0)