APPS.WMS_TASK_UTILS_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 131: FROM mtl_serial_numbers_temp

127:
128: CURSOR c_fm_to_serial_number IS
129: SELECT fm_serial_number
130: , to_serial_number
131: FROM mtl_serial_numbers_temp
132: WHERE transaction_temp_id = p_temp_id;
133:
134: CURSOR c_fm_to_lot_serial_number IS
135: SELECT fm_serial_number

Line 137: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

133:
134: CURSOR c_fm_to_lot_serial_number IS
135: SELECT fm_serial_number
136: , to_serial_number
137: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
138: WHERE mtlt.transaction_temp_id = p_temp_id
139: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
140:
141: CURSOR c_lot_allocations IS

Line 398: DELETE mtl_serial_numbers_temp

394:
395: CLOSE c_fm_to_serial_number;
396:
397: /**Serial Controlled only ****/
398: DELETE mtl_serial_numbers_temp
399: WHERE transaction_temp_id = p_temp_id;
400: ELSIF(v_lot_control_code = 2
401: AND v_serial_control_code NOT IN(1, 6)) THEN
402: /** Both lot and serial controlled **/

Line 433: DELETE FROM mtl_serial_numbers_temp

429: END LOOP;
430:
431: CLOSE c_fm_to_lot_serial_number;
432:
433: DELETE FROM mtl_serial_numbers_temp
434: WHERE transaction_temp_id = l_serial_transaction_temp_id;
435: END LOOP;
436:
437: CLOSE c_lot_allocations;

Line 439: DELETE mtl_serial_numbers_temp

435: END LOOP;
436:
437: CLOSE c_lot_allocations;
438:
439: DELETE mtl_serial_numbers_temp
440: WHERE transaction_temp_id IN(SELECT mtlt.serial_transaction_temp_id
441: FROM mtl_transaction_lots_temp mtlt
442: WHERE mtlt.transaction_temp_id = p_temp_id);
443:

Line 1478: FROM mtl_serial_numbers_temp

1474: WHERE transaction_temp_id = txn_tmp_id;
1475:
1476: CURSOR msnt(txn_tmp_id NUMBER) IS
1477: SELECT *
1478: FROM mtl_serial_numbers_temp
1479: WHERE transaction_temp_id = txn_tmp_id;
1480:
1481: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1482: BEGIN