1694: -1
1695: from msc_exception_details med,
1696: msc_system_items msi,
1697: msc_demands md,
1698: msc_full_pegging mfp
1699: where med.plan_id = p_plan_id
1700: and med.exception_type in (15,16,23,35,41,42,69)
1701: and md.plan_id=med.plan_id
1702: and mfp.pegging_id=med.number2
1750: from msc_exception_details med,
1751: msc_system_items msi,
1752: msc_demands md,
1753: msc_supplies ms,
1754: msc_full_pegging mfp
1755: where med.plan_id = p_plan_id
1756: and med.exception_type = 19
1757: and md.plan_id=med.plan_id
1758: and mfp.pegging_id=med.number2