APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_SUPPLIES

Line 381: msc_supplies rec,

377: FLOW_SCHED_BY, -1, 1))) new_quantity
378: FROM msc_plans p,
379: msc_trading_partners param,
380: msc_system_items msi,
381: msc_supplies rec,
382: msc_plan_buckets mpb,
383: msc_plan_organizations_v ov,
384: msc_companies c,
385: msc_company_sites s,

Line 565: from msc_supplies mr

561: AND trunc(mgr.using_assembly_demand_date) BETWEEN nvl(trunc(p.plan_start_date), trunc(mgr.using_assembly_demand_date))
562: AND nvl(trunc(p_horizon_end), trunc(mgr.using_assembly_demand_date))
563: AND not exists (
564: select 'cancelled IR'
565: from msc_supplies mr
566: where mgr.origination_type in (30,6)
567: and mgr.disposition_id = mr.transaction_id
568: and mgr.plan_id = mr.plan_id
569: and mgr.sr_instance_id = mr.sr_instance_id

Line 670: msc_supplies rec,

666: FLOW_SCHED_BY, -1, 1))) new_quantity
667: FROM msc_plans p,
668: msc_trading_partners param,
669: msc_system_items msi,
670: msc_supplies rec,
671: msc_companies c,
672: msc_company_sites s,
673: msc_trading_partners t,
674: msc_trading_partner_maps m

Line 832: from msc_supplies mr

828: AND trunc(mgr.using_assembly_demand_date) <= nvl(trunc(p_horizon_end), trunc(mgr.using_assembly_demand_date))
829: AND trunc(mgr.using_assembly_demand_date) < trunc(p.plan_start_date)
830: AND not exists (
831: select 'cancelled IR'
832: from msc_supplies mr
833: where mgr.origination_type in (30,6)
834: and mgr.disposition_id = mr.transaction_id
835: and mgr.plan_id = mr.plan_id
836: and mgr.sr_instance_id = mr.sr_instance_id