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.CSE_PO_RECEIPT_INTO_PROJECT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 75: DELETE FROM mtl_serial_numbers_temp

71: INTO l_interface_transaction_id
72: FROM rcv_transactions
73: WHERE transaction_id = p_rcv_transaction_id;
74:
75: DELETE FROM mtl_serial_numbers_temp
76: WHERE transaction_temp_id = l_interface_transaction_id;
77:
78: DELETE FROM mtl_transaction_lots_temp
79: WHERE transaction_temp_id = l_interface_transaction_id;

Line 601: SELECT 'x' FROM mtl_serial_numbers_temp msnt

597: CURSOR srl_cur(p_interface_transaction_id in number) IS
598: SELECT msn.serial_number serial_number
599: FROM mtl_serial_numbers msn
600: WHERE EXISTS (
601: SELECT 'x' FROM mtl_serial_numbers_temp msnt
602: WHERE msnt.transaction_temp_id = p_interface_transaction_id
603: AND msnt.transaction_temp_id = msn.line_mark_id) ;
604:
605: BEGIN