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.WMS_PUTAWAY_UTILS dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 9426: FROM mtl_serial_numbers_interface msni

9422: SELECT msn.serial_number
9423: , 'N'
9424: , msn.inspection_status
9425: , msn.lot_number
9426: FROM mtl_serial_numbers_interface msni
9427: , mtl_serial_numbers msn
9428: , rcv_serials_supply rss
9429: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
9430: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number, msni.fm_serial_number)

Line 9906: FROM mtl_serial_numbers_interface msni, mtl_serial_numbers msn

9902: --R12: Find out the serials entered by the user in the UI,
9903: --grouping by their inspection_status and lot_number
9904: SELECT count(1), Nvl(msn.inspection_status,-1), Nvl(msn.lot_number,'&*_')
9905: bulk collect INTO l_msni_qty_tbl, l_msni_inspect_status_tbl, l_msni_lot_tbl
9906: FROM mtl_serial_numbers_interface msni, mtl_serial_numbers msn
9907: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
9908: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number,msni.fm_serial_number)
9909: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
9910: GROUP BY msn.inspection_status, msn.lot_number;

Line 10300: DELETE FROM mtl_serial_numbers_interface

10296: OPEN rcv_serials_csr;
10297: FETCH rcv_serials_csr
10298: BULK COLLECT INTO l_ser_num_tbl, l_ser_mark_tbl,l_ser_inspect_status_tbl,l_ser_lot_num_tbl;
10299:
10300: DELETE FROM mtl_serial_numbers_interface
10301: WHERE transaction_interface_id = p_msni_txn_interface_id;
10302:
10303: IF (l_debug = 1) THEN
10304: debug('Number of MSNI deleted: '||SQL%rowcount,l_proc_name,9);