APPS.MSC_SUPPLIER_PKG dependencies on MSC_SUPPLIES

Line 108: from msc_supplies ms

104: trunc(case when l_plan_type in (101) then ms.new_schedule_date
105: else nvl(ms.new_order_placement_date, nvl(ms.firm_date,ms.new_schedule_date)) end)
106: analysis_date,
107: sum(ms.new_order_quantity) required_qty
108: from msc_supplies ms
109: where l_plan_type not in (6)
110: and ms.plan_id = p_plan_id
111: and nvl(ms.disposition_status_type,1)=1
112: and (l_plan_type in (4,5) or l_plan_constrained=2)