APPS.WMS_PUTAWAY_UTILS dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 10298: FROM mtl_serial_numbers_interface msni

10294: SELECT msn.serial_number
10295: , 'N'
10296: , msn.inspection_status
10297: , msn.lot_number
10298: FROM mtl_serial_numbers_interface msni
10299: , mtl_serial_numbers msn
10300: , rcv_serials_supply rss
10301: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
10302: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number, msni.fm_serial_number)

Line 10785: FROM mtl_serial_numbers_interface msni, mtl_serial_numbers msn

10781: --R12: Find out the serials entered by the user in the UI,
10782: --grouping by their inspection_status and lot_number
10783: SELECT count(1), Nvl(msn.inspection_status,-1), Nvl(msn.lot_number,'&*_')
10784: bulk collect INTO l_msni_qty_tbl, l_msni_inspect_status_tbl, l_msni_lot_tbl
10785: FROM mtl_serial_numbers_interface msni, mtl_serial_numbers msn
10786: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
10787: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number,msni.fm_serial_number)
10788: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
10789: GROUP BY msn.inspection_status, msn.lot_number;

Line 11194: DELETE FROM mtl_serial_numbers_interface

11190: OPEN rcv_serials_csr;
11191: FETCH rcv_serials_csr
11192: BULK COLLECT INTO l_ser_num_tbl, l_ser_mark_tbl,l_ser_inspect_status_tbl,l_ser_lot_num_tbl;
11193:
11194: DELETE FROM mtl_serial_numbers_interface
11195: WHERE transaction_interface_id = p_msni_txn_interface_id;
11196:
11197: IF (l_debug = 1) THEN
11198: debug('Number of MSNI deleted: '||SQL%rowcount,l_proc_name,9);

Line 13893: mtl_serial_numbers_interface

13889:
13890: --Delete MSNI
13891: DELETE
13892: FROM
13893: mtl_serial_numbers_interface
13894: WHERE
13895: product_transaction_id IN
13896: (
13897: SELECT