APPS.EDW_MRP_PLAN_M_SIZE dependencies on MRP_PLANS

Line 21: mrp_plans mpl

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
25: AND mpl.plan_completion_date IS NOT NULL

Line 84: FROM mrp_plans

80: nvl(avg(nvl(vsize(plan_safety_stock),0)),0),
81: nvl(avg(nvl(vsize(cutoff_date),0)),0),
82: nvl(avg(nvl(vsize(creation_date),0)),0),
83: nvl(avg(nvl(vsize(last_update_date),0)),0)
84: FROM mrp_plans
85: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
86:
87: BEGIN
88: