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.INV_STATUS_PKG dependencies on MTL_MATERIAL_STATUS_HISTORY

Line 318: mtl_material_status_history mmsh

314:
315: CURSOR cur_onhand IS
316: select moqd.rowid FROM
317: mtl_onhand_quantities_detail moqd,
318: mtl_material_status_history mmsh
319: where moqd.inventory_item_id = mmsh.inventory_item_id
320: and moqd.organization_id = mmsh.organization_id
321: and moqd.subinventory_code = mmsh.zone_code
322: and nvl(moqd.locator_id, -9999) = nvl(mmsh.locator_id, Nvl(moqd.locator_id, -9999))

Line 338: mtl_material_status_history mmsh

334:
335:
336: CURSOR cur_onhserial IS
337: select msn.rowid FROM mtl_serial_numbers msn,
338: mtl_material_status_history mmsh
339: where msn.inventory_item_id = mmsh.inventory_item_id
340: and msn.current_organization_id = mmsh.organization_id
341: and msn.current_subinventory_code = mmsh.zone_code
342: and nvl(msn.current_locator_id, -9999) = nvl(mmsh.locator_id, Nvl(msn.current_locator_id, -9999))

Line 358: mtl_material_status_history mmsh

354: FOR UPDATE NOWAIT;
355:
356: CURSOR cur_Subinv IS
357: select ms.rowid FROM mtl_secondary_inventories ms,
358: mtl_material_status_history mmsh
359: where ms.organization_id = mmsh.organization_id
360: and ms.secondary_inventory_name = mmsh.zone_code
361: AND mmsh.status_update_id = p_transaction_id
362: FOR UPDATE NOWAIT;

Line 366: mtl_material_status_history mmsh

362: FOR UPDATE NOWAIT;
363:
364: CURSOR cur_Loc IS
365: select mil.rowid FROM mtl_item_locations mil,
366: mtl_material_status_history mmsh
367: where mil.organization_id = mmsh.organization_id
368: and mil.inventory_location_id = mmsh.locator_id
369: AND mmsh.status_update_id = p_transaction_id
370: FOR UPDATE NOWAIT;

Line 375: mtl_material_status_history mmsh

371:
372:
373: CURSOR cur_Lot IS
374: select mln.rowid FROM mtl_lot_numbers mln,
375: mtl_material_status_history mmsh
376: where mln.organization_id = mmsh.organization_id
377: and mln.inventory_item_id = mmsh.inventory_item_id
378: AND mln.lot_number = mmsh.lot_number
379: AND mmsh.status_update_id = p_transaction_id

Line 384: mtl_material_status_history mmsh

380: FOR UPDATE NOWAIT;
381:
382: CURSOR cur_Serial IS
383: select msn.rowid FROM mtl_serial_numbers msn,
384: mtl_material_status_history mmsh
385: where msn.current_organization_id = mmsh.organization_id
386: and msn.inventory_item_id = mmsh.inventory_item_id
387: AND msn.serial_number = mmsh.serial_number
388: AND mmsh.status_update_id = p_transaction_id

Line 410: UPDATE mtl_material_status_history

406: mdebug('p_pending_status is:'||p_pending_status||'l_signature_status is:'||l_signature_status||'p_event_name is:'||p_event_name);
407: IF (p_pending_status = 0) OR (l_signature_status = 'SUCCESS') THEN
408: IF p_event_name = 'oracle.apps.inv.onhandStatus' THEN
409: mdebug('before updating MMSH');
410: UPDATE mtl_material_status_history
411: SET pending_status = 0
412: WHERE pending_status = 1
413: AND group_id = p_transaction_id;
414:

Line 452: UPDATE mtl_material_status_history

448: CLOSE cur_onhserial;
449:
450: END IF;
451: ELSIF p_event_name = 'oracle.apps.inv.subinvStatus' THEN
452: UPDATE mtl_material_status_history
453: SET pending_status = 0
454: WHERE pending_status = 1
455: AND status_update_id = p_transaction_id;
456:

Line 475: UPDATE mtl_material_status_history

471: mdebug(' update executed in sql: Onhand');
472:
473:
474: ELSIF p_event_name = 'oracle.apps.inv.loctStatus' THEN
475: UPDATE mtl_material_status_history
476: SET pending_status = 0
477: WHERE pending_status = 1
478: AND status_update_id = p_transaction_id;
479:

Line 496: UPDATE mtl_material_status_history

492: CLOSE cur_Loc;
493:
494: mdebug(' update executed in sql: Onhand');
495: ELSIF p_event_name = 'oracle.apps.inv.lotStatus' THEN
496: UPDATE mtl_material_status_history
497: SET pending_status = 0
498: WHERE pending_status = 1
499: AND status_update_id = p_transaction_id;
500:

Line 519: UPDATE mtl_material_status_history

515: mdebug(' update executed in sql: Onhand');
516:
517:
518: ELSIF p_event_name = 'oracle.apps.inv.serialStatus' THEN
519: UPDATE mtl_material_status_history
520: SET pending_status = 0
521: WHERE pending_status = 1
522: AND status_update_id = p_transaction_id;
523:

Line 548: DELETE FROM mtl_material_status_history

544:
545:
546: IF (l_signature_status = 'REJECTED' OR l_signature_status = 'TIMEDOUT') THEN
547: mdebug('ERES Rejected');
548: DELETE FROM mtl_material_status_history
549: WHERE pending_status = 1
550: AND (group_id = p_transaction_id OR status_update_id = p_transaction_id);
551: COMMIT;
552: END IF;

Line 732: FROM mtl_material_status_history

728: mdebug('p_inventory_item_id is:'||p_inventory_item_id);
729: mdebug('p_organization_id is:'||p_organization_id);
730: mdebug('p_sub_code is:'||p_sub_code);
731: SELECT Count(1) INTO l_pending_eres_chk
732: FROM mtl_material_status_history
733: WHERE inventory_item_id = NVL(p_inventory_item_id, inventory_item_id)
734: AND organization_id = p_organization_id
735: AND zone_code = NVL(p_sub_code,zone_code)
736: AND Decode(p_locator_id,NULL,-999,locator_id) = Nvl(p_locator_id,-999)

Line 772: FROM mtl_material_status_history

768: mdebug('p_inventory_item_id is:'||p_inventory_item_id);
769: mdebug('p_organization_id is:'||p_organization_id);
770: mdebug('p_sub_code is:'||p_sub_code);
771: SELECT Count(1) INTO l_pending_eres_chk
772: FROM mtl_material_status_history
773: WHERE organization_id = p_organization_id
774: AND zone_code = p_sub_code
775: AND locator_id is null
776: AND inventory_item_id is null

Line 826: FROM mtl_material_status_history

822: mdebug('p_inventory_item_id is:'||p_inventory_item_id);
823: mdebug('p_organization_id is:'||p_organization_id);
824: mdebug('p_sub_code is:'||p_sub_code);
825: SELECT Count(1) INTO l_pending_eres_chk
826: FROM mtl_material_status_history
827: WHERE organization_id = p_organization_id
828: AND locator_id = p_locator_id
829: AND inventory_item_id is null
830: AND lot_number is null AND serial_number is null

Line 881: FROM mtl_material_status_history

877: mdebug('p_inventory_item_id is:'||p_inventory_item_id);
878: mdebug('p_organization_id is:'||p_organization_id);
879: mdebug('p_sub_code is:'||p_sub_code);
880: SELECT Count(1) INTO l_pending_eres_chk
881: FROM mtl_material_status_history
882: WHERE inventory_item_id = p_inventory_item_id
883: AND organization_id = p_organization_id
884: AND lot_number BETWEEN p_from_lot_number and p_to_lot_number
885: AND zone_code is null

Line 950: FROM mtl_material_status_history

946: mdebug('p_inventory_item_id is:'||p_inventory_item_id);
947: mdebug('p_organization_id is:'||p_organization_id);
948: mdebug('p_sub_code is:'||p_sub_code);
949: SELECT Count(1) INTO l_pending_eres_chk
950: FROM mtl_material_status_history
951: WHERE inventory_item_id = p_inventory_item_id
952: AND organization_id = p_organization_id
953: AND serial_number BETWEEN p_from_SN AND p_to_SN
954: AND zone_code is null

Line 1143: FROM mtl_material_status_history

1139: mdebug('p_from_lot_number is:'||p_from_lot_number);
1140: mdebug('p_to_lot_number is:'||p_to_lot_number);
1141: mdebug('p_lpn_id is:'||p_lpn_id);
1142: SELECT Count(1) INTO l_pending_eres_chk
1143: FROM mtl_material_status_history
1144: WHERE inventory_item_id = NVL(p_inventory_item_id,inventory_item_id)
1145: AND organization_id = p_organization_id
1146: AND zone_code = NVL(p_sub_code,zone_code)
1147: AND nvl(locator_id, -9999) = nvl(p_locator_id, Nvl(locator_id, -9999))