APPS.MSC_NETCHANGE_PKG dependencies on MSC_EXCEPTION_DETAILS

Line 1358: from msc_exception_details med,

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

Line 1413: from msc_exception_details med,

1409: -1,
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)

Line 1470: from msc_exception_details med,

1466: -1,
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)

Line 1533: from msc_exception_details med,

1529: -1,
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)

Line 1588: from msc_exception_details med,

1584: -1,
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)

Line 1641: from msc_exception_details med,

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

Line 1695: from msc_exception_details med,

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

Line 1750: from msc_exception_details med,

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

Line 1803: from msc_exception_details med

1799: -1,
1800: trunc(sysdate),
1801: -1,
1802: -1
1803: from msc_exception_details med
1804: where med.plan_id = p_plan_id
1805: and med.exception_type in (21,22,38,39,45,46,50,51);
1806:
1807: END populate_all_exceptions;

Line 1838: from msc_exception_details med

1834: and exception_detail_id is not null;
1835:
1836: CURSOR need_recompare_c(p_plan_id number) is
1837: select 1
1838: from msc_exception_details med
1839: where med.plan_id = p_plan_id
1840: and med.exception_detail_id = p_excp_id;
1841:
1842: begin

Line 2225: ' msc_exception_details_v medv '||

2221: (where_clause is not null and p_excp_type in
2222: (21,22,23,35,36,38,39,40,45,46,50,51)) then
2223: sql_statement := sql_statement ||
2224: ' from msc_nec_exc_dtl_compare med, '||
2225: ' msc_exception_details_v medv '||
2226: ' where med.report_id = :p_report_id '||
2227: ' and med.exception_type = :p_excp '||
2228: ' and med.exception_detail_id is not null '||
2229: ' and med.plan_id = medv.plan_id ' ||