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.INV_TRANSFER_ORDER_PVT dependencies on MTL_SERIAL_NUMBERS

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 479: UPDATE mtl_serial_numbers

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
479: UPDATE mtl_serial_numbers
480: SET line_mark_id = unmarked_value
481: , group_mark_id = unmarked_value
482: , lot_line_mark_id = unmarked_value
483: WHERE group_mark_id IN (p_trx_temp_id, l_transaction_header_id)

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 3512: UPDATE mtl_serial_numbers

3508: END IF;
3509:
3510: /*** {{ R12 Enhanced reservations code changes,
3511: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
3512: UPDATE mtl_serial_numbers
3513: SET group_mark_id = NULL
3514: WHERE serial_number = l_serial_number
3515: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
3516: *** End R12 }} ***/

Line 3548: UPDATE mtl_serial_numbers

3544: END IF;
3545:
3546: /*** {{ R12 Enhanced reservations code changes,
3547: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
3548: UPDATE mtl_serial_numbers
3549: SET group_mark_id = NULL
3550: WHERE serial_number = l_serial_number
3551: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
3552: *** End R12 }} ***/

Line 3823: UPDATE mtl_serial_numbers

3819: IF (l_debug = 1) THEN
3820: DEBUG('serial number:'|| l_serial_number, 'Finalize_Pick_Confirm');
3821: END IF;
3822:
3823: UPDATE mtl_serial_numbers
3824: SET reservation_id = null
3825: WHERE reservation_id = l_mtl_reservation_tbl(1).reservation_id
3826: AND serial_number = l_serial_number;
3827:

Line 3866: UPDATE mtl_serial_numbers

3862: IF (l_debug = 1) THEN
3863: DEBUG('serial number:'|| l_serial_number, 'Finalize_Pick_Confirm');
3864: END IF;
3865:
3866: UPDATE mtl_serial_numbers
3867: SET reservation_id = null
3868: WHERE reservation_id = l_mtl_reservation_tbl(1).reservation_id
3869: AND serial_number = l_serial_number;
3870:

Line 5075: UPDATE mtl_serial_numbers

5071: ELSE
5072: -- Unmark the remaining serials
5073: /*** {{ R12 Enhanced reservations code changes,
5074: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
5075: UPDATE mtl_serial_numbers
5076: SET group_mark_id = NULL
5077: WHERE serial_number = l_serial_number
5078: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
5079: *** End R12 }} ***/

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 5304: UPDATE mtl_serial_numbers

5300: ELSE
5301: -- Unmark the remaining serials
5302: /*** {{ R12 Enhanced reservations code changes,
5303: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
5304: UPDATE mtl_serial_numbers
5305: SET group_mark_id = NULL
5306: WHERE serial_number = l_serial_number
5307: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
5308: *** End R12 }} ***/

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 6884: update mtl_Serial_numbers

6880: and to_Serial_number = l_Serial_cursor.to_serial_number;
6881:
6882: /*** {{ R12 Enhanced reservations code changes,
6883: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6884: update mtl_Serial_numbers
6885: set group_mark_id = null
6886: where current_organization_id = l_serial_cursor.organization_id
6887: and inventory_item_id = l_Serial_cursor.inventory_item_id
6888: and serial_number between l_Serial_cursor.fm_Serial_number and l_serial_cursor.to_Serial_number;

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 6953: update mtl_serial_numbers

6949:
6950: --unmark these serial numbers in MSN
6951: /*** {{ R12 Enhanced reservations code changes,
6952: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6953: update mtl_serial_numbers
6954: set group_mark_id = null
6955: where current_organization_id = l_serial_cursor.organization_id
6956: and inventory_item_id = l_serial_cursor.inventory_item_id
6957: and serial_number between x_prefix||l_new_num_str_update and 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 6985: update mtl_serial_numbers

6981: and transaction_temp_id = p_transaction_Temp_id;
6982:
6983: /*** {{ R12 Enhanced reservations code changes,
6984: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6985: update mtl_serial_numbers
6986: set group_mark_id = null
6987: where current_organization_id = l_serial_cursor.organization_id
6988: and inventory_item_id = l_serial_cursor.inventory_item_id
6989: and serial_number = l_Serial_cursor.fm_serial_number;

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:

Line 7021: update mtl_serial_numbers

7017:
7018:
7019: /*** {{ R12 Enhanced reservations code changes,
7020: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
7021: update mtl_serial_numbers
7022: set group_mark_id = null
7023: where current_organization_id = l_serial_cursor.organization_id
7024: and inventory_item_id = l_serial_cursor.inventory_item_id
7025: and serial_number = l_Serial_cursor.to_serial_number;