eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_NETCHANGE_PKG dependencies on MSC_SYSTEM_ITEMS

Line 1359: msc_system_items msi

1355: trunc(sysdate),
1356: -1,
1357: -1
1358: from msc_exception_details med,
1359: msc_system_items msi
1360: where med.plan_id = p_plan_id
1361: and med.exception_type in (1,2,3,4,5,11,17,18,20,28,29,30,48)
1362: and msi.plan_id = med.plan_id
1363: and msi.organization_id = med.organization_id

Line 1414: msc_system_items msi,

1410: trunc(sysdate),
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

Line 1471: msc_system_items msi,

1467: trunc(sysdate),
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

Line 1534: msc_system_items msi,

1530: trunc(sysdate),
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

Line 1589: msc_system_items msi,

1585: trunc(sysdate),
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

Line 1642: msc_system_items msi,

1638: trunc(sysdate),
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

Line 1696: msc_system_items msi,

1692: trunc(sysdate),
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)

Line 1751: msc_system_items msi,

1747: trunc(sysdate),
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