APPS.WMS_UT_PKG dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2322: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt

2318: AND mil2.inventory_location_id (+) = mmtt.transfer_to_location;
2319:
2320: CURSOR c_get_msnt_lines(p_tid NUMBER) IS
2321: SELECT msnt.fm_serial_number || ',' || msnt.to_serial_number as stext
2322: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt
2323: WHERE mmtt.transaction_temp_id = p_tid
2324: AND msnt.transaction_temp_id = mmtt.transaction_temp_id
2325: AND msn.serial_number = msnt.fm_serial_number
2326: AND msn.inventory_item_id = mmtt.inventory_item_id;

Line 2330: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt

2326: AND msn.inventory_item_id = mmtt.inventory_item_id;
2327:
2328: CURSOR c_get_msnt_lines_wlot(p_tid NUMBER, p_lot_number VARCHAR2) IS
2329: SELECT msnt.fm_serial_number || ',' || msnt.to_serial_number as stext
2330: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt
2331: WHERE mmtt.transaction_temp_id = p_tid
2332: AND msnt.transaction_temp_id = mmtt.transaction_temp_id
2333: AND msn.serial_number = msnt.fm_serial_number
2334: AND msn.lot_number (+) = nvl(p_lot_number,'###')

Line 2658: DELETE FROM mtl_serial_numbers_temp

2654: WHERE organization_id = p_org_id
2655: AND inventory_item_id = l_item_id;
2656: print_debug('Deleted All MOLs');
2657: FOR c_rec in c_mmtt(l_item_id) LOOP
2658: DELETE FROM mtl_serial_numbers_temp
2659: WHERE transaction_temp_id = c_rec.transaction_temp_id;
2660:
2661: DELETE FROM mtl_transaction_lots_temp
2662: WHERE transaction_temp_id = c_rec.transaction_temp_id;