DBA Data[Home] [Help]

APPS.MSC_EXCEPTION_PKG dependencies on MSC_SYSTEM_ITEMS

Line 355: msc_system_items msi,

351: msc_supplies ms,
352: msc_demands md,
353: msc_demands md2,
354: msc_full_pegging mfp,
355: msc_system_items msi,
356: msc_trading_partners mtp
357: where mp.plan_id = p_plan_id
358: and mp.plan_type <> 6
359: and mp.plan_id = med.plan_id

Line 562: msc_system_items msi,

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,
563: msc_trading_partners mtp
564: where msi.plan_id(+) = t.plan_id
565: and msi.inventory_item_id(+) = t.inventory_item_id
566: and msi.organization_id(+) = t.owning_org_id