APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_SUPPLIES

Line 384: msc_supplies rec,

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

Line 568: from msc_supplies mr

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

Line 673: msc_supplies rec,

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

Line 835: from msc_supplies mr

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