APPS.WMS_TASK_UTILS_PVT dependencies on MTL_SERIAL_NUMBERS

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

383: LOOP
384: FETCH c_fm_to_serial_number INTO l_fm_serial_number, l_to_serial_number;
385: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
386:
387: UPDATE mtl_serial_numbers
388: SET group_mark_id = NULL
389: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
390: --Bug 2940878 fix added org and item restriction
391: AND current_organization_id = l_org_id

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

419: LOOP
420: FETCH c_fm_to_lot_serial_number INTO l_fm_serial_number, l_to_serial_number;
421: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
422:
423: UPDATE mtl_serial_numbers
424: SET group_mark_id = NULL
425: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
426: --Bug 2940878 fix added org and item restriction
427: AND current_organization_id = l_org_id

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

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

Line 1949: FROM mtl_serial_numbers

1945: l_already_used := 'N';
1946: BEGIN
1947: SELECT 'Y' INTO l_already_used FROM dual WHERE exists
1948: (SELECT 1
1949: FROM mtl_serial_numbers
1950: WHERE
1951: --Bug 2940878 fix added current_organization_id ,
1952: --inventory_item_id in the query
1953: -- also changed the condition on group_mark_id

Line 2062: FROM mtl_serial_numbers

2058: l_already_used := 'N';
2059: BEGIN
2060: SELECT 'Y' INTO l_already_used FROM dual WHERE exists
2061: (SELECT 1
2062: FROM mtl_serial_numbers
2063: WHERE
2064: --Bug 2940878 fix added current_organization_id ,
2065: --inventory_item_id in the query
2066: -- also changed the condition on group_mark_id