APPS.MSC_SUPPLIER_PKG dependencies on MSC_PLANS

Line 84: --select CURR_PLAN_TYPE into g_plan_type from msc_plans where plan_id = p_plan_id;

80: retcode := 0;
81: errbuf := null;
82:
83:
84: --select CURR_PLAN_TYPE into g_plan_type from msc_plans where plan_id = p_plan_id;
85: l_plan_constrained := msc_phub_util.is_plan_constrained(p_plan_id);
86: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
87: --dbms_output.put_line('populate_details '||p_plan_id||', '||p_plan_run_id||', '||l_plan_type);
88:

Line 204: msc_plans mp,

200: sum(msc_supplier_pkg.is_new_buy_order(ms.order_type, l_plan_type, msi.purchasing_enabled_flag)) buy_order_count
201: from
202: MSC_SUPPLIES ms,
203: MSC_SYSTEM_ITEMS msi,
204: msc_plans mp,
205: msc_trading_partners mtp
206: where
207: mp.plan_id = p_plan_id
208: and l_plan_constrained = SYS_NO -- are we double counting constrained plan with previous?

Line 330: msc_plans mp

326: msc_supplier_capacities mscp,
327: msc_calendar_dates mcd,
328: msc_trading_partners mtp,
329: msc_item_suppliers mis,
330: msc_plans mp
331: where mp.plan_id = mscp.plan_id
332: and mscp.capacity > 0
333: and mis.plan_id = mscp.plan_id
334: and mis.supplier_id = mscp.supplier_id