APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 443: FROM mtl_serial_numbers_temp

439: CURSOR serial_temp_csr IS
440: SELECT fm_serial_number
441: , to_serial_number
442: , group_header_id
443: FROM mtl_serial_numbers_temp
444: WHERE transaction_temp_id = p_trx_temp_id
445: ORDER BY fm_serial_number DESC
446: FOR UPDATE OF transaction_temp_id;
447: BEGIN

Line 452: DELETE FROM mtl_serial_numbers_temp

448: -- Initialize API return status to success
449: x_return_status := fnd_api.g_ret_sts_success;
450:
451: IF p_operation = 'DELETE' THEN -- when cancel qty >sum(mmtt trx qty)
452: DELETE FROM mtl_serial_numbers_temp
453: WHERE transaction_temp_id = p_trx_temp_id;
454: ELSIF p_operation = 'UPDATE' THEN -- when cancel qty < sum(mmtt trx qty)
455: SELECT transaction_header_id
456: INTO l_transaction_header_id

Line 462: FROM mtl_serial_numbers_temp

458: WHERE transaction_temp_id = p_trx_temp_id;
459:
460: SELECT COUNT(*)
461: INTO l_serial_count
462: FROM mtl_serial_numbers_temp
463: WHERE transaction_temp_id = p_trx_temp_id;
464:
465: IF (l_serial_count > 0) THEN
466: -- dbms_output.put_line('inside serial count> 0');

Line 474: DELETE FROM mtl_serial_numbers_temp

470:
471: IF l_to_serial_number IS NOT NULL THEN
472: IF l_to_serial_number = l_fm_serial_number THEN
473: --ranges individually assigned ranges
474: DELETE FROM mtl_serial_numbers_temp
475: WHERE CURRENT OF serial_temp_csr;
476:
477: /*** {{ R12 Enhanced reservations code changes,
478: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

Line 2609: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

2605:
2606: CURSOR serial_csr(l_trx_temp_id NUMBER, l_lot_control_code NUMBER, l_ser_trx_temp_id NUMBER,
2607: l_org_id NUMBER, l_item_id NUMBER) IS
2608: SELECT msn.serial_number
2609: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
2610: WHERE msnt.transaction_temp_id = DECODE(l_lot_control_code, 1, l_trx_temp_id, l_ser_trx_temp_id)
2611: AND msn.current_organization_id = l_org_id
2612: AND msn.inventory_item_id = l_item_id
2613: AND msn.serial_number BETWEEN msnt.fm_serial_number AND NVL(msnt.to_serial_number, msnt.fm_serial_number)

Line 2637: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

2633:
2634: /*** {{ R12 Enhanced reservations code changes ***/
2635: CURSOR serial_reserved_csr(l_trx_temp_id NUMBER, l_reservation_id NUMBER) IS
2636: SELECT msn.serial_number
2637: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
2638: WHERE msnt.transaction_temp_id = l_trx_temp_id
2639: AND msn.serial_number BETWEEN msnt.fm_serial_number AND NVL(msnt.to_serial_number, msnt.fm_serial_number)
2640: AND length(msn.serial_number) = length(msnt.fm_serial_number)
2641: AND msn.reservation_id = l_reservation_id;

Line 5096: DELETE FROM mtl_serial_numbers_temp

5092: CLOSE serial_csr;
5093:
5094: IF ( l_lot_primary_quantity <> 1 ) THEN
5095: -- MSNT records need to be deleted since TM does not
5096: DELETE FROM mtl_serial_numbers_temp
5097: WHERE transaction_temp_id = l_serial_trx_temp_id;
5098: END IF;
5099: END IF;
5100: END LOOP;

Line 5325: DELETE FROM mtl_serial_numbers_temp

5321: CLOSE serial_csr;
5322:
5323: IF ( l_primary_shipping_quantity <> 1 ) THEN
5324: -- MSNT records need to be deleted since TM does not
5325: DELETE FROM mtl_serial_numbers_temp
5326: WHERE transaction_temp_id = p_transaction_temp_id;
5327: END IF;
5328: END IF;
5329: ELSIF ( l_lot_control_code > 1 AND l_serial_control_code IN (1, 6)) THEN

Line 6813: FROM mtl_Serial_numbers_temp a, mtl_material_transactions_temp b

6809: ,a.FM_SERIAL_NUMBER
6810: ,a.TO_SERIAL_NUMBER
6811: ,b.organization_id
6812: ,b.inventory_item_id
6813: FROM mtl_Serial_numbers_temp a, mtl_material_transactions_temp b
6814: where a.transaction_temp_id= p_transaction_temp_id
6815: and a.transaction_temp_id = b.transaction_temp_id;
6816:
6817: l_Serial_cursor serial_cursor%ROWTYPE;

Line 6877: delete from mtl_Serial_numbers_temp

6873: IF (l_debug = 1) THEN
6874: DEBUG('Inside if p_qty= '||p_qty||' diff_qty= '||diff_qty||' qty_count= '||qty_count||' fm_Serial='||l_Serial_cursor.fm_serial_number||' to_ser='||l_serial_cursor.to_serial_number,'INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6875: END IF;
6876:
6877: delete from mtl_Serial_numbers_temp
6878: where transaction_temp_id = p_transaction_temp_id
6879: and fm_Serial_number = l_Serial_cursor.fm_serial_number
6880: and to_Serial_number = l_Serial_cursor.to_serial_number;
6881:

Line 6938: update mtl_serial_numbers_temp

6934: DEBUG('l_new_num_Str= '||l_new_num_str||' l_new_num_Str_update='||l_new_num_str_update,'INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6935: END IF;
6936:
6937:
6938: update mtl_serial_numbers_temp
6939: set fm_Serial_number = l_Serial_cursor.fm_serial_number
6940: ,to_Serial_number = x_prefix||l_new_num_str
6941: where fm_Serial_number = l_Serial_cursor.fm_serial_number
6942: and to_Serial_number = l_Serial_cursor.to_serial_number

Line 6978: delete from mtl_serial_numbers_temp

6974: IF (l_debug = 1) THEN
6975: DEBUG('after update fm_Serial_num= '||l_Serial_cursor.fm_serial_number||' to_Ser_num= '||l_serial_cursor.to_serial_number,'INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6976: END IF;
6977:
6978: delete from mtl_serial_numbers_temp
6979: where fm_Serial_number = l_Serial_cursor.fm_serial_number
6980: and to_serial_number = l_serial_cursor.to_serial_number
6981: and transaction_temp_id = p_transaction_Temp_id;
6982:

Line 7013: delete from mtl_serial_numbers_temp

7009: IF (l_debug = 1) THEN
7010: DEBUG('After update fm_Serial_num= '||l_Serial_cursor.fm_serial_number||' to_Ser_num= '||l_serial_cursor.to_serial_number,'INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
7011: END IF;
7012:
7013: delete from mtl_serial_numbers_temp
7014: where fm_Serial_number = l_Serial_cursor.fm_serial_number
7015: and to_serial_number = l_serial_cursor.to_serial_number
7016: and transaction_temp_id = p_transaction_Temp_id;
7017: