APPS.INV_MO_LINE_DETAIL_UTIL dependencies on MTL_SERIAL_NUMBERS

Line 2598: FROM mtl_serial_numbers_temp

2594: CURSOR c_serial_allocations IS
2595: SELECT fm_serial_number
2596: , NVL(to_serial_number, fm_serial_number)
2597: , ROWID
2598: FROM mtl_serial_numbers_temp
2599: WHERE transaction_temp_id = l_serial_transaction_temp_id;
2600:
2601: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2602: BEGIN

Line 2680: UPDATE mtl_serial_numbers

2676: l_last_deleted_serial_number := l_from_prefix || l_new_num;
2677: l_new_num := l_new_num + 1;
2678: l_new_from_serial_number := l_from_prefix || l_new_num;
2679:
2680: UPDATE mtl_serial_numbers
2681: SET group_mark_id = NULL
2682: WHERE serial_number BETWEEN l_from_serial_number AND l_last_deleted_serial_number;
2683:
2684: UPDATE mtl_serial_numbers_temp

Line 2684: UPDATE mtl_serial_numbers_temp

2680: UPDATE mtl_serial_numbers
2681: SET group_mark_id = NULL
2682: WHERE serial_number BETWEEN l_from_serial_number AND l_last_deleted_serial_number;
2683:
2684: UPDATE mtl_serial_numbers_temp
2685: SET fm_serial_number = l_new_from_serial_number
2686: WHERE ROWID = l_serial_rowid;
2687:
2688: l_serial_qty_to_delete := 0;

Line 2692: UPDATE mtl_serial_numbers

2688: l_serial_qty_to_delete := 0;
2689: ELSE --delete the row
2690:
2691: --unmark in serial number table
2692: UPDATE mtl_serial_numbers
2693: SET group_mark_id = NULL
2694: WHERE inventory_item_id = l_inventory_item_id
2695: AND serial_number BETWEEN l_from_serial_number AND l_to_serial_number;
2696:

Line 2698: DELETE FROM mtl_serial_numbers_temp

2694: WHERE inventory_item_id = l_inventory_item_id
2695: AND serial_number BETWEEN l_from_serial_number AND l_to_serial_number;
2696:
2697: --delete records
2698: DELETE FROM mtl_serial_numbers_temp
2699: WHERE ROWID = l_serial_rowid;
2700:
2701: --decrement
2702: l_serial_qty_to_delete := l_serial_qty_to_delete - l_serial_quantity;

Line 2808: FROM mtl_serial_numbers_temp msnt

2804: l_procedure_name VARCHAR2(30) := 'GET_SERIAL_QUANTITY';
2805:
2806: CURSOR serial_records IS
2807: SELECT SUM(inv_serial_number_pub.get_serial_diff(msnt.fm_serial_number, msnt.to_serial_number))
2808: FROM mtl_serial_numbers_temp msnt
2809: WHERE msnt.transaction_temp_id = p_transaction_temp_id;
2810:
2811: l_serial_quantity NUMBER := 0;
2812: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);