DBA Data[Home] [Help]

APPS.MSC_NETCHANGE_PKG dependencies on MSC_DEMANDS

Line 1590: msc_demands md

1586: -1,
1587: -1
1588: from msc_exception_details med,
1589: msc_system_items msi,
1590: msc_demands md
1591: where med.plan_id = p_plan_id
1592: and med.exception_type in (13,14,24,25,26,27,52,67,68,70,71)
1593: and md.plan_id=med.plan_id
1594: and md.demand_id=med.number1

Line 1643: msc_demands md

1639: -1,
1640: -1
1641: from msc_exception_details med,
1642: msc_system_items msi,
1643: msc_demands md
1644: where med.plan_id = p_plan_id
1645: and med.exception_type =49
1646: and md.plan_id=med.plan_id
1647: and md.demand_id=med.supplier_id

Line 1697: msc_demands md,

1693: -1,
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

Line 1752: msc_demands md,

1748: -1,
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