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_DRP_UTIL dependencies on MSC_EXCEPTION_DETAILS

Line 1254: from msc_exception_details med

1250: p_lt_window number) RETURN numberArr IS
1251:
1252: cursor exc_id_c is
1253: select med.exception_detail_id
1254: from msc_exception_details med
1255: where med.plan_id = p_plan_id
1256: and med.inventory_item_id = p_item_id
1257: and med.organization_id = p_org_id
1258: and med.sr_instance_id = p_inst_id

Line 1318: From msc_exception_details med,

1314: msie.supplier_site_id,
1315: msie.source_org_id
1316: INTO p_plan_id, p_org_id, p_inst_id, p_item_id, p_excp_type,
1317: p_supplier_id, p_supplier_site_id, p_source_org_id
1318: From msc_exception_details med,
1319: Msc_srp_item_exceptions msie
1320: Where med.plan_id = msie.plan_id
1321: And med.organization_id = msie.organization_id
1322: And med.sr_instance_id = msie.sr_instance_id

Line 1338: -- lock msc_exception_details

1334: p_action_taken_date := sysdate;
1335: end if;
1336:
1337:
1338: -- lock msc_exception_details
1339: Select med.exception_detail_id
1340: BULK COLLECT INTO p_excp_id
1341: From msc_exception_details med
1342: Where med.plan_id = p_plan_id

Line 1341: From msc_exception_details med

1337:
1338: -- lock msc_exception_details
1339: Select med.exception_detail_id
1340: BULK COLLECT INTO p_excp_id
1341: From msc_exception_details med
1342: Where med.plan_id = p_plan_id
1343: And med.organization_id = p_org_id
1344: And med.sr_instance_id = p_inst_id
1345: And med.inventory_item_id = p_item_id

Line 1355: Update msc_exception_details

1351:
1352:
1353: -- update all the excp within the same criteria group
1354: Forall a in 1..nvl(p_excp_id.last,0)
1355: Update msc_exception_details
1356: Set action_taken_date = p_action_taken_date
1357: -- action_taken = p_action_taken
1358: Where plan_id = p_plan_id
1359: AND exception_detail_id = p_excp_id(a);

Line 1362: Update msc_exception_details

1358: Where plan_id = p_plan_id
1359: AND exception_detail_id = p_excp_id(a);
1360:
1361: /* a hack for bug9975016, only mark the selected exc as actionTaken */
1362: Update msc_exception_details
1363: Set action_taken = p_action_taken
1364: Where plan_id = p_plan_id
1365: AND rowid = p_rowid;
1366:

Line 1414: From msc_exception_details med,

1410: Select med.exception_detail_id,
1411: msie.action_taken_date,
1412: msie.last_generated_date
1413: BULK COLLECT INTO p_excp_id, p_action_date, p_gen_date
1414: From msc_exception_details med,
1415: Msc_srp_item_exceptions msie
1416: Where med.plan_id = msie.plan_id
1417: And med.organization_id = msie.organization_id
1418: And med.sr_instance_id = msie.sr_instance_id

Line 1429: Update msc_exception_details

1425: and msie.exist = 1
1426: and msie.plan_id = p_plan_id;
1427:
1428: Forall a in 1..nvl(p_excp_id.last,0)
1429: Update msc_exception_details
1430: Set action_taken_date = p_action_date(a),
1431: first_generated_date = p_gen_date(a),
1432: Action_taken = decode(p_action_date(a), null, 2, 1),
1433: new_exception = decode(p_gen_date(a), p_plan_date, 1, 0)