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_RCV_COMMON_APIS dependencies on MTL_SERIAL_NUMBERS

Line 428: PROCEDURE insert_msnt(p_msnt_rec mtl_serial_numbers_temp%ROWTYPE) IS

424: inv_mobile_helper_functions.sql_error('check_lot_serial_codes', l_progress, SQLCODE);
425: END IF;
426: END check_lot_serial_codes;
427:
428: PROCEDURE insert_msnt(p_msnt_rec mtl_serial_numbers_temp%ROWTYPE) IS
429: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
430: BEGIN
431: INSERT INTO mtl_serial_numbers_temp
432: (

Line 431: INSERT INTO mtl_serial_numbers_temp

427:
428: PROCEDURE insert_msnt(p_msnt_rec mtl_serial_numbers_temp%ROWTYPE) IS
429: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
430: BEGIN
431: INSERT INTO mtl_serial_numbers_temp
432: (
433: transaction_temp_id
434: , last_update_date
435: , last_updated_by

Line 588: FUNCTION break_serials_only(p_original_tid IN mtl_serial_numbers_temp.transaction_temp_id%TYPE, p_new_transactions_tb IN trans_rec_tb_tp)

584: , p_msnt_rec.number_of_repairs
585: );
586: END insert_msnt;
587:
588: FUNCTION break_serials_only(p_original_tid IN mtl_serial_numbers_temp.transaction_temp_id%TYPE, p_new_transactions_tb IN trans_rec_tb_tp)
589: RETURN BOOLEAN IS
590: CURSOR c_serials IS
591: SELECT *
592: FROM mtl_serial_numbers_temp

Line 592: FROM mtl_serial_numbers_temp

588: FUNCTION break_serials_only(p_original_tid IN mtl_serial_numbers_temp.transaction_temp_id%TYPE, p_new_transactions_tb IN trans_rec_tb_tp)
589: RETURN BOOLEAN IS
590: CURSOR c_serials IS
591: SELECT *
592: FROM mtl_serial_numbers_temp
593: WHERE transaction_temp_id = p_original_tid;
594:
595: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
596: l_new_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;

Line 595: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;

591: SELECT *
592: FROM mtl_serial_numbers_temp
593: WHERE transaction_temp_id = p_original_tid;
594:
595: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
596: l_new_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;
597: l_new_primary_quantity NUMBER; -- the quanity user wants to split
598: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
599: l_from_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;

Line 596: l_new_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;

592: FROM mtl_serial_numbers_temp
593: WHERE transaction_temp_id = p_original_tid;
594:
595: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
596: l_new_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;
597: l_new_primary_quantity NUMBER; -- the quanity user wants to split
598: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
599: l_from_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
600: l_to_ser mtl_serial_numbers_temp.to_serial_number%TYPE;

Line 599: l_from_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;

595: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
596: l_new_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;
597: l_new_primary_quantity NUMBER; -- the quanity user wants to split
598: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
599: l_from_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
600: l_to_ser mtl_serial_numbers_temp.to_serial_number%TYPE;
601: l_new_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
602: l_from_ser_num NUMBER; -- number part of from serial
603: l_to_ser_num NUMBER; -- number part of to serial

Line 600: l_to_ser mtl_serial_numbers_temp.to_serial_number%TYPE;

596: l_new_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;
597: l_new_primary_quantity NUMBER; -- the quanity user wants to split
598: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
599: l_from_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
600: l_to_ser mtl_serial_numbers_temp.to_serial_number%TYPE;
601: l_new_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
602: l_from_ser_num NUMBER; -- number part of from serial
603: l_to_ser_num NUMBER; -- number part of to serial
604: l_primary_quantity NUMBER; -- the quantity within this serial record

Line 601: l_new_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;

597: l_new_primary_quantity NUMBER; -- the quanity user wants to split
598: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
599: l_from_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
600: l_to_ser mtl_serial_numbers_temp.to_serial_number%TYPE;
601: l_new_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
602: l_from_ser_num NUMBER; -- number part of from serial
603: l_to_ser_num NUMBER; -- number part of to serial
604: l_primary_quantity NUMBER; -- the quantity within this serial record
605: l_prefix_temp VARCHAR2(30);

Line 634: UPDATE mtl_serial_numbers_temp

630: insert_msnt(l_msnt_rec); -- insert one line with new to-ser-number and new txn_id
631: -- Update the existing ser rec with start serial number ??
632: l_new_ser := get_to_serial_number(l_from_ser, l_new_primary_quantity + 1);
633:
634: UPDATE mtl_serial_numbers_temp
635: SET fm_serial_number = l_new_ser
636: WHERE transaction_temp_id = l_transaction_temp_id
637: AND fm_serial_number = l_from_ser
638: AND to_serial_number = l_to_ser;

Line 647: UPDATE mtl_serial_numbers_temp

643: -- ser rec qty is exhausted
644: -- need to continue ser loop in this case
645:
646: -- Update the ser rec with new transaction interface ID
647: UPDATE mtl_serial_numbers_temp
648: SET transaction_temp_id = l_new_transaction_temp_id
649: WHERE transaction_temp_id = l_transaction_temp_id
650: AND fm_serial_number = l_from_ser
651: AND to_serial_number = l_to_ser;

Line 659: UPDATE mtl_serial_numbers_temp

655: ELSIF(l_primary_quantity = l_new_primary_quantity) THEN
656: -- exact match
657:
658: -- Update the lot rec with new transaction interface ID
659: UPDATE mtl_serial_numbers_temp
660: SET transaction_temp_id = l_new_transaction_temp_id
661: WHERE transaction_temp_id = l_transaction_temp_id
662: AND fm_serial_number = l_from_ser
663: AND to_serial_number = l_to_ser;

Line 1092: l_serial_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;

1088: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
1089: l_primary_quantity NUMBER; -- the transaction qty for lot
1090: l_transaction_quantity NUMBER;
1091: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;
1092: l_serial_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;
1093: l_tran_rec_tb trans_rec_tb_tp;
1094: l_sec_transaction_quantity NUMBER; --invconv kkillams
1095: l_new_secondary_quantity NUMBER; -- the quanity user wants to split
1096: --BUG 2673970

Line 3382: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

3378:
3379: BEGIN
3380: SELECT 1
3381: INTO l_count
3382: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
3383: WHERE (
3384: (p_from_serial BETWEEN msnt.fm_serial_number AND msnt.to_serial_number
3385: AND get_serial_Length(p_from_serial) = get_serial_Length(msnt.fm_serial_number)
3386: AND get_serial_Length(msnt.fm_serial_number) = get_serial_Length(Nvl(msnt.to_serial_number,msnt.fm_serial_number)))

Line 3432: UPDATE mtl_serial_numbers

3428: );
3429: l_progress := '70';
3430:
3431: BEGIN
3432: UPDATE mtl_serial_numbers
3433: SET group_mark_id = p_serial_transaction_temp_id
3434: WHERE inventory_item_id = p_item_id
3435: AND serial_number BETWEEN p_from_serial AND p_to_serial
3436: AND LENGTH(serial_number) = LENGTH(p_from_serial);

Line 4911: FROM mtl_serial_numbers msn

4907: -- for two diff items.
4908: /* FP-J Lot/Serial Support Enhancement - Check for status of Resides in Receiving (7) also */
4909: SELECT COUNT(1)
4910: INTO l_serial_packed_in_other_lpn
4911: FROM mtl_serial_numbers msn
4912: WHERE msn.current_status IN (5, 7)
4913: AND EXISTS(SELECT 'x'
4914: FROM wms_license_plate_numbers wlpn
4915: WHERE wlpn.lpn_context NOT IN(5, 6, 7)

Line 5222: FROM mtl_serial_numbers

5218: INTO l_txn_cnt
5219: FROM DUAL
5220: WHERE EXISTS(
5221: SELECT '1'
5222: FROM mtl_serial_numbers
5223: WHERE inventory_item_id = p_inventory_item_id
5224: AND current_organization_id = p_organization_id
5225: AND current_status = 1
5226: AND serial_number BETWEEN p_from_serial_number AND p_to_serial_number

Line 5253: -- total number of serials inserted into mtl_serial_numbers

5249: l_progress := '30';
5250: -- get the number part of the from serial
5251: inv_validate.number_from_sequence(p_from_serial_number, l_temp_prefix, l_from_ser_number);
5252: l_progress := '40';
5253: -- total number of serials inserted into mtl_serial_numbers
5254: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
5255: l_serial_num_length := LENGTH(p_from_serial_number);
5256: l_prefix_length := LENGTH(l_temp_prefix);
5257:

Line 5270: UPDATE mtl_serial_numbers

5266: * from UI since it would be handled by the receiving TM.
5267: */
5268: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5269: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5270: UPDATE mtl_serial_numbers
5271: SET previous_status = current_status
5272: , current_status = p_current_status
5273: , inspection_status = p_inspection_required
5274: , lot_number = p_lot_number

Line 5282: UPDATE mtl_serial_numbers

5278: AND inventory_item_id = p_inventory_item_id;
5279: ELSE
5280: print_debug('update_serial_status: INV and PO patchset levels are J or higher.', 4);
5281: print_debug('update_serial_status: Updating revision lot_number if serial code of the item is predefined and current status is defined but not used', 4);
5282: UPDATE mtl_serial_numbers
5283: SET lot_number = p_lot_number
5284: , revision = p_revision
5285: WHERE serial_number = l_cur_serial_number
5286: AND inventory_item_id = p_inventory_item_id