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 440: FROM mtl_serial_numbers_temp

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

Line 449: DELETE FROM mtl_serial_numbers_temp

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

Line 459: FROM mtl_serial_numbers_temp

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

Line 471: DELETE FROM mtl_serial_numbers_temp

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

Line 476: UPDATE mtl_serial_numbers

472: WHERE CURRENT OF serial_temp_csr;
473:
474: /*** {{ R12 Enhanced reservations code changes,
475: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
476: UPDATE mtl_serial_numbers
477: SET line_mark_id = unmarked_value
478: , group_mark_id = unmarked_value
479: , lot_line_mark_id = unmarked_value
480: WHERE group_mark_id IN (p_trx_temp_id, l_transaction_header_id)

Line 2585: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

2581:
2582: CURSOR serial_csr(l_trx_temp_id NUMBER, l_lot_control_code NUMBER, l_ser_trx_temp_id NUMBER,
2583: l_org_id NUMBER, l_item_id NUMBER) IS
2584: SELECT msn.serial_number
2585: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
2586: WHERE msnt.transaction_temp_id = DECODE(l_lot_control_code, 1, l_trx_temp_id, l_ser_trx_temp_id)
2587: AND msn.current_organization_id = l_org_id
2588: AND msn.inventory_item_id = l_item_id
2589: AND msn.serial_number BETWEEN msnt.fm_serial_number AND NVL(msnt.to_serial_number, msnt.fm_serial_number)

Line 2613: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

2609:
2610: /*** {{ R12 Enhanced reservations code changes ***/
2611: CURSOR serial_reserved_csr(l_trx_temp_id NUMBER, l_reservation_id NUMBER) IS
2612: SELECT msn.serial_number
2613: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
2614: WHERE msnt.transaction_temp_id = l_trx_temp_id
2615: AND msn.serial_number BETWEEN msnt.fm_serial_number AND NVL(msnt.to_serial_number, msnt.fm_serial_number)
2616: AND length(msn.serial_number) = length(msnt.fm_serial_number)
2617: AND msn.reservation_id = l_reservation_id;

Line 3285: UPDATE mtl_serial_numbers

3281: END IF;
3282:
3283: /*** {{ R12 Enhanced reservations code changes,
3284: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
3285: UPDATE mtl_serial_numbers
3286: SET group_mark_id = NULL
3287: WHERE serial_number = l_serial_number
3288: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
3289: *** End R12 }} ***/

Line 3321: UPDATE mtl_serial_numbers

3317: END IF;
3318:
3319: /*** {{ R12 Enhanced reservations code changes,
3320: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
3321: UPDATE mtl_serial_numbers
3322: SET group_mark_id = NULL
3323: WHERE serial_number = l_serial_number
3324: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
3325: *** End R12 }} ***/

Line 3579: UPDATE mtl_serial_numbers

3575: IF (l_debug = 1) THEN
3576: DEBUG('serial number:'|| l_serial_number, 'Finalize_Pick_Confirm');
3577: END IF;
3578:
3579: UPDATE mtl_serial_numbers
3580: SET reservation_id = null
3581: WHERE reservation_id = l_mtl_reservation_tbl(1).reservation_id
3582: AND serial_number = l_serial_number;
3583:

Line 3616: UPDATE mtl_serial_numbers

3612: IF (l_debug = 1) THEN
3613: DEBUG('serial number:'|| l_serial_number, 'Finalize_Pick_Confirm');
3614: END IF;
3615:
3616: UPDATE mtl_serial_numbers
3617: SET reservation_id = null
3618: WHERE reservation_id = l_mtl_reservation_tbl(1).reservation_id
3619: AND serial_number = l_serial_number;
3620:

Line 4739: UPDATE mtl_serial_numbers

4735: ELSE
4736: -- Unmark the remaining serials
4737: /*** {{ R12 Enhanced reservations code changes,
4738: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
4739: UPDATE mtl_serial_numbers
4740: SET group_mark_id = NULL
4741: WHERE serial_number = l_serial_number
4742: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
4743: *** End R12 }} ***/

Line 4760: DELETE FROM mtl_serial_numbers_temp

4756: CLOSE serial_csr;
4757:
4758: IF ( l_lot_primary_quantity <> 1 ) THEN
4759: -- MSNT records need to be deleted since TM does not
4760: DELETE FROM mtl_serial_numbers_temp
4761: WHERE transaction_temp_id = l_serial_trx_temp_id;
4762: END IF;
4763: END IF;
4764: END LOOP;

Line 4960: UPDATE mtl_serial_numbers

4956: ELSE
4957: -- Unmark the remaining serials
4958: /*** {{ R12 Enhanced reservations code changes,
4959: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
4960: UPDATE mtl_serial_numbers
4961: SET group_mark_id = NULL
4962: WHERE serial_number = l_serial_number
4963: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
4964: *** End R12 }} ***/

Line 4981: DELETE FROM mtl_serial_numbers_temp

4977: CLOSE serial_csr;
4978:
4979: IF ( l_primary_shipping_quantity <> 1 ) THEN
4980: -- MSNT records need to be deleted since TM does not
4981: DELETE FROM mtl_serial_numbers_temp
4982: WHERE transaction_temp_id = p_transaction_temp_id;
4983: END IF;
4984: END IF;
4985: ELSIF ( l_lot_control_code > 1 AND l_serial_control_code IN (1, 6)) THEN

Line 6379: FROM mtl_Serial_numbers_temp a, mtl_material_transactions_temp b

6375: ,a.FM_SERIAL_NUMBER
6376: ,a.TO_SERIAL_NUMBER
6377: ,b.organization_id
6378: ,b.inventory_item_id
6379: FROM mtl_Serial_numbers_temp a, mtl_material_transactions_temp b
6380: where a.transaction_temp_id= p_transaction_temp_id
6381: and a.transaction_temp_id = b.transaction_temp_id;
6382:
6383: l_Serial_cursor serial_cursor%ROWTYPE;

Line 6443: delete from mtl_Serial_numbers_temp

6439: IF (l_debug = 1) THEN
6440: 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');
6441: END IF;
6442:
6443: delete from mtl_Serial_numbers_temp
6444: where transaction_temp_id = p_transaction_temp_id
6445: and fm_Serial_number = l_Serial_cursor.fm_serial_number
6446: and to_Serial_number = l_Serial_cursor.to_serial_number;
6447:

Line 6450: update mtl_Serial_numbers

6446: and to_Serial_number = l_Serial_cursor.to_serial_number;
6447:
6448: /*** {{ R12 Enhanced reservations code changes,
6449: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6450: update mtl_Serial_numbers
6451: set group_mark_id = null
6452: where current_organization_id = l_serial_cursor.organization_id
6453: and inventory_item_id = l_Serial_cursor.inventory_item_id
6454: and serial_number between l_Serial_cursor.fm_Serial_number and l_serial_cursor.to_Serial_number;

Line 6504: update mtl_serial_numbers_temp

6500: 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');
6501: END IF;
6502:
6503:
6504: update mtl_serial_numbers_temp
6505: set fm_Serial_number = l_Serial_cursor.fm_serial_number
6506: ,to_Serial_number = x_prefix||l_new_num_str
6507: where fm_Serial_number = l_Serial_cursor.fm_serial_number
6508: and to_Serial_number = l_Serial_cursor.to_serial_number

Line 6519: update mtl_serial_numbers

6515:
6516: --unmark these serial numbers in MSN
6517: /*** {{ R12 Enhanced reservations code changes,
6518: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6519: update mtl_serial_numbers
6520: set group_mark_id = null
6521: where current_organization_id = l_serial_cursor.organization_id
6522: and inventory_item_id = l_serial_cursor.inventory_item_id
6523: and serial_number between x_prefix||l_new_num_str_update and l_Serial_cursor.to_serial_number;

Line 6544: delete from mtl_serial_numbers_temp

6540: IF (l_debug = 1) THEN
6541: 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');
6542: END IF;
6543:
6544: delete from mtl_serial_numbers_temp
6545: where fm_Serial_number = l_Serial_cursor.fm_serial_number
6546: and to_serial_number = l_serial_cursor.to_serial_number
6547: and transaction_temp_id = p_transaction_Temp_id;
6548:

Line 6551: update mtl_serial_numbers

6547: and transaction_temp_id = p_transaction_Temp_id;
6548:
6549: /*** {{ R12 Enhanced reservations code changes,
6550: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6551: update mtl_serial_numbers
6552: set group_mark_id = null
6553: where current_organization_id = l_serial_cursor.organization_id
6554: and inventory_item_id = l_serial_cursor.inventory_item_id
6555: and serial_number = l_Serial_cursor.fm_serial_number;

Line 6579: delete from mtl_serial_numbers_temp

6575: IF (l_debug = 1) THEN
6576: 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');
6577: END IF;
6578:
6579: delete from mtl_serial_numbers_temp
6580: where fm_Serial_number = l_Serial_cursor.fm_serial_number
6581: and to_serial_number = l_serial_cursor.to_serial_number
6582: and transaction_temp_id = p_transaction_Temp_id;
6583:

Line 6587: update mtl_serial_numbers

6583:
6584:
6585: /*** {{ R12 Enhanced reservations code changes,
6586: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6587: update mtl_serial_numbers
6588: set group_mark_id = null
6589: where current_organization_id = l_serial_cursor.organization_id
6590: and inventory_item_id = l_serial_cursor.inventory_item_id
6591: and serial_number = l_Serial_cursor.to_serial_number;