APPS.MSC_NETCHANGE_PKG dependencies on MSC_SUPPLIES

Line 1415: msc_supplies ms

1411: -1,
1412: -1
1413: from msc_exception_details med,
1414: msc_system_items msi,
1415: msc_supplies ms
1416: where med.plan_id = p_plan_id
1417: and med.exception_type in (6,7,8,9,10,12,47)
1418: and ms.plan_id=med.plan_id
1419: and ms.transaction_id=med.number1

Line 1472: msc_supplies ms

1468: -1,
1469: -1
1470: from msc_exception_details med,
1471: msc_system_items msi,
1472: msc_supplies ms
1473: where med.plan_id = p_plan_id
1474: and med.exception_type in (31,32,33,34,43,44)
1475: and ms.plan_id=med.plan_id
1476: and ms.transaction_id=med.number1

Line 1535: msc_supplies ms

1531: -1,
1532: -1
1533: from msc_exception_details med,
1534: msc_system_items msi,
1535: msc_supplies ms
1536: where med.plan_id = p_plan_id
1537: and med.exception_type in (36,37,40,53,54,55,56,57,58,59,60,61,62,63,64,65,66,71,72)
1538: and ms.plan_id=med.plan_id
1539: and ms.transaction_id=med.number1

Line 1753: msc_supplies ms,

1749: -1
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