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_MATERIAL_ALLOCATIONS_GRP dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 402: UPDATE mtl_serial_numbers_temp

398:
399: --API start
400: if (p_new_transaction_temp_id is not null) then
401: --replace the transaction_temp_id for msnt row with this one.
402: UPDATE mtl_serial_numbers_temp
403: SET transaction_temp_id = p_new_transaction_temp_id
404: WHERE transaction_temp_id = p_transaction_temp_id
405: AND fm_serial_number = p_serial;
406: --restamp the group mark id in msn. needed for bug 2798128 (expects temp id)

Line 413: DELETE FROM mtl_serial_numbers_temp

409: WHERE group_mark_id = p_transaction_temp_id
410: AND serial_number = p_serial;
411: else
412: --delete current msnt row and then unmark serial
413: DELETE FROM mtl_serial_numbers_temp
414: WHERE transaction_temp_id = p_transaction_temp_id
415: and fm_serial_number = p_serial;
416: --Can also use serial_check.inv_unmark_serial
417: UPDATE mtl_serial_numbers