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_NEC_EXC_DTL_COMPARE

Line 1314: insert into msc_nec_exc_dtl_compare(

1310:
1311: -- over commit, rep var, no act, neg on hand
1312: -- item with exc/shortage, below safety, supplier cap.
1313: -- sourcing split violation
1314: insert into msc_nec_exc_dtl_compare(
1315: report_id,
1316: status,
1317: exception_detail_id,
1318: plan_id,

Line 1370: insert into msc_nec_exc_dtl_compare(

1366: ;
1367:
1368: -- reschedule in/out, cancel, past due, compress, expired lot
1369: -- schedule to next inventory point
1370: insert into msc_nec_exc_dtl_compare(
1371: report_id,
1372: status,
1373: exception_detail_id,
1374: plan_id,

Line 1427: insert into msc_nec_exc_dtl_compare(

1423: and msi.sr_instance_id = med.sr_instance_id
1424: and msi.inventory_item_id = med.inventory_item_id;
1425:
1426: -- alternate
1427: insert into msc_nec_exc_dtl_compare(
1428: report_id,
1429: status,
1430: exception_detail_id,
1431: plan_id,

Line 1484: insert into msc_nec_exc_dtl_compare(

1480: and msi.sr_instance_id = ms.sr_instance_id
1481: and msi.inventory_item_id = ms.inventory_item_id;
1482:
1483: -- resource/material constraint
1484: insert into msc_nec_exc_dtl_compare(
1485: report_id,
1486: status,
1487: exception_detail_id,
1488: plan_id,

Line 1549: insert into msc_nec_exc_dtl_compare(

1545:
1546: -- late/early, past due sales order/forecast
1547: -- SO/FC at risk, demand qty not satisfied, SO overcommit
1548: -- SO changes, alt ship method used
1549: insert into msc_nec_exc_dtl_compare(
1550: report_id,
1551: status,
1552: exception_detail_id,
1553: plan_id,

Line 1602: insert into msc_nec_exc_dtl_compare(

1598: and msi.sr_instance_id = md.sr_instance_id
1599: and msi.inventory_item_id = md.inventory_item_id;
1600:
1601: --- demand using item substitute
1602: insert into msc_nec_exc_dtl_compare(
1603: report_id,
1604: status,
1605: exception_detail_id,
1606: plan_id,

Line 1657: insert into msc_nec_exc_dtl_compare(

1653:
1654: -- late supply pegged to so/forecast
1655: -- order at risk due to res/mat shortage/demand affected by res/mat constraint
1656: -- Late Replenishment for DRP/MPS Demands
1657: insert into msc_nec_exc_dtl_compare(
1658: report_id,
1659: status,
1660: exception_detail_id,
1661: plan_id,

Line 1713: insert into msc_nec_exc_dtl_compare(

1709: and msi.sr_instance_id = md.sr_instance_id
1710: and msi.inventory_item_id = md.inventory_item_id;
1711:
1712: -- cross project
1713: insert into msc_nec_exc_dtl_compare(
1714: report_id,
1715: status,
1716: exception_detail_id,
1717: plan_id,

Line 1772: insert into msc_nec_exc_dtl_compare(

1768: and msi.sr_instance_id = ms.sr_instance_id
1769: and msi.inventory_item_id = ms.inventory_item_id;
1770:
1771: -- (trans) res over/under, max/min batch
1772: insert into msc_nec_exc_dtl_compare(
1773: report_id,
1774: status,
1775: exception_detail_id,
1776: plan_id,

Line 1830: from MSC_NEC_EXC_DTL_COMPARE

1826: (from_plan = p_to_plan and to_plan = p_from_plan));
1827:
1828: CURSOR exc_c(p_plan_id number) is
1829: select exception_detail_id
1830: from MSC_NEC_EXC_DTL_COMPARE
1831: where plan_id = p_plan_id
1832: and report_id = p_report_id
1833: and rownum =1
1834: and exception_detail_id is not null;

Line 1956: delete from msc_nec_exc_dtl_compare

1952: where report_id = p_report_id;
1953: commit;
1954: end if;
1955:
1956: delete from msc_nec_exc_dtl_compare
1957: where report_id = p_report_id;
1958:
1959: populate_all_exceptions(p_from_plan,p_report_id);
1960: populate_all_exceptions(p_to_plan,p_report_id);

Line 1965: insert into msc_nec_exc_dtl_compare(

1961:
1962: compare_each_exception(p_report_id);
1963:
1964: -- insert summary rows which are grouped by exc_type
1965: insert into msc_nec_exc_dtl_compare(
1966: report_id,
1967: status,
1968: plan_id,
1969: exception_type,

Line 1990: from msc_nec_exc_dtl_compare

1986: -1,
1987: trunc(sysdate),
1988: -1,
1989: -1
1990: from msc_nec_exc_dtl_compare
1991: where report_id = p_report_id
1992: and exception_detail_id is not null
1993: group by report_id,
1994: status,

Line 2006: insert into msc_nec_exc_dtl_compare(

2002: -1,
2003: -1 ;
2004:
2005: -- insert summary rows which are grouped by exc_group
2006: insert into msc_nec_exc_dtl_compare(
2007: report_id,
2008: status,
2009: plan_id,
2010: exception_group,

Line 2029: from msc_nec_exc_dtl_compare

2025: -1,
2026: trunc(sysdate),
2027: -1,
2028: -1
2029: from msc_nec_exc_dtl_compare
2030: where report_id = p_report_id
2031: and exception_detail_id is null
2032: group by report_id,
2033: status,

Line 2050: tabname=>'MSC_NEC_EXC_DTL_COMPARE');

2046:
2047: commit;
2048:
2049: fnd_stats.gather_table_stats(ownname=>'MSC',
2050: tabname=>'MSC_NEC_EXC_DTL_COMPARE');
2051:
2052: END compare_all_exceptions;
2053:
2054: Procedure compare_each_exception(p_report_id number) IS

Line 2072: FROM msc_nec_exc_dtl_compare

2068: exception_detail_id,
2069: exception_type,
2070: id_key,
2071: compare_key
2072: FROM msc_nec_exc_dtl_compare
2073: WHERE from_plan = p_from_plan
2074: AND report_id = p_report_id
2075: AND status =0;
2076:

Line 2080: FROM msc_nec_exc_dtl_compare

2076:
2077: CURSOR same_exc_c IS
2078: SELECT
2079: exception_detail_id
2080: FROM msc_nec_exc_dtl_compare
2081: WHERE from_plan = p_to_plan
2082: AND report_id = p_report_id
2083: AND status =0
2084: and exception_type = a_exc_type

Line 2091: FROM msc_nec_exc_dtl_compare

2087:
2088: CURSOR change_exc_c IS
2089: SELECT
2090: exception_detail_id
2091: FROM msc_nec_exc_dtl_compare
2092: WHERE from_plan = p_to_plan
2093: AND report_id = p_report_id
2094: AND status =0
2095: and exception_type = a_exc_type

Line 2104: from msc_nec_exc_dtl_compare

2100: Begin
2101:
2102: select sum(decode(from_plan,1,1,0)), sum(decode(from_plan,2,1,0))
2103: into from_plan_count, to_plan_count
2104: from msc_nec_exc_dtl_compare
2105: where report_id = p_report_id
2106: and status =0;
2107:
2108: if from_plan_count > to_plan_count then

Line 2131: update msc_nec_exc_dtl_compare

2127: b_excp_id;
2128: CLOSE same_exc_c;
2129:
2130: if b_excp_id is not null then -- found the same excp
2131: update msc_nec_exc_dtl_compare
2132: set status = 1,
2133: match_id = b_excp_id
2134: where plan_id = p_from_plan_id
2135: and exception_detail_id = a_excp_id

Line 2138: update msc_nec_exc_dtl_compare

2134: where plan_id = p_from_plan_id
2135: and exception_detail_id = a_excp_id
2136: and report_id = p_report_id;
2137:
2138: update msc_nec_exc_dtl_compare
2139: set status = 1,
2140: match_id = a_excp_id
2141: where plan_id = p_to_plan_id
2142: and exception_detail_id = b_excp_id

Line 2162: update msc_nec_exc_dtl_compare

2158: FETCH change_exc_c INTO
2159: b_excp_id;
2160: CLOSE change_exc_c;
2161: if b_excp_id is not null then -- found the change excp
2162: update msc_nec_exc_dtl_compare
2163: set status = 2,
2164: match_id = b_excp_id
2165: where plan_id = p_from_plan_id
2166: and exception_detail_id = a_excp_id

Line 2169: update msc_nec_exc_dtl_compare

2165: where plan_id = p_from_plan_id
2166: and exception_detail_id = a_excp_id
2167: and report_id = p_report_id;
2168:
2169: update msc_nec_exc_dtl_compare
2170: set status = 2,
2171: match_id = a_excp_id
2172: where plan_id = p_to_plan_id
2173: and exception_detail_id = b_excp_id

Line 2224: ' from msc_nec_exc_dtl_compare med, '||

2220: if g_long_query or
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 '||

Line 2235: ' from msc_nec_exc_dtl_compare med '||

2231: ' medv.exception_id ' ||
2232: where_clause;
2233: else
2234: sql_statement := sql_statement ||
2235: ' from msc_nec_exc_dtl_compare med '||
2236: ' where med.report_id = :p_report_id '||
2237: ' and med.exception_type = :p_excp '||
2238: ' and med.exception_detail_id is not null '||
2239: where_clause;

Line 2329: delete msc_nec_exc_dtl_compare

2325:
2326: delete msc_nec_compare_plans
2327: where report_id = p_report_id;
2328:
2329: delete msc_nec_exc_dtl_compare
2330: where report_id = p_report_id;
2331: end loop;
2332:
2333: close compare_c;