DBA Data[Home] [Help]

APPS.MSC_EXCEPTION_PKG dependencies on MSC_PLANS

Line 16: from msc_trading_partners o, msc_plans p

12: -- save owning organization's functional currency
13: begin
14: select o.currency_code
15: into l_owning_currency_code
16: from msc_trading_partners o, msc_plans p
17: where o.sr_instance_id=p.sr_instance_id
18: and o.sr_tp_id=p.organization_id
19: and o.partner_type=3
20: and p.plan_id=p_plan_id;

Line 350: msc_plans mp,

346:
347:
348: from
349: msc_exception_details med,
350: msc_plans mp,
351: msc_supplies ms,
352: msc_demands md,
353: msc_demands md2,
354: msc_full_pegging mfp,

Line 558: msc_plans mp

554: med.date1,
555: med.number2
556: from
557: msc_exception_details med,
558: msc_plans mp
559: where mp.plan_id = med.plan_id
560: and mp.plan_type = 6
561: and mp.plan_id = p_plan_id) t,
562: msc_system_items msi,