352: from
353: msc_exception_details med,
354: msc_apcc_item_d msi,
355: msc_trading_partners mtp,
356: msc_supplies ms,
357: msc_demands md,
358: msc_full_pegging mfp,
359: msc_demands md2
360: where med.plan_id=p_plan_id