APPS.WMS_UNLOAD_UTILS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 104: FROM mtl_serial_numbers_temp

100:
101: CURSOR c_fm_to_serial_number IS
102: SELECT fm_serial_number
103: , to_serial_number
104: FROM mtl_serial_numbers_temp
105: WHERE transaction_temp_id = p_temp_id;
106:
107: CURSOR c_fm_to_lot_serial_number (p_sn_temp_id IN NUMBER) IS
108: SELECT fm_serial_number

Line 110: FROM mtl_serial_numbers_temp msnt

106:
107: CURSOR c_fm_to_lot_serial_number (p_sn_temp_id IN NUMBER) IS
108: SELECT fm_serial_number
109: , to_serial_number
110: FROM mtl_serial_numbers_temp msnt
111: WHERE msnt.transaction_temp_id = p_sn_temp_id;
112:
113: CURSOR c_lot_allocations IS
114: SELECT serial_transaction_temp_id

Line 455: UPDATE mtl_serial_numbers

451: LOOP
452: FETCH c_fm_to_serial_number INTO l_fm_serial_number, l_to_serial_number;
453: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
454:
455: UPDATE mtl_serial_numbers
456: SET group_mark_id = NULL
457: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
458: --Bug 2940878 fix added org and item restriction
459: AND current_organization_id = l_org_id

Line 466: DELETE mtl_serial_numbers_temp

462:
463: CLOSE c_fm_to_serial_number;
464:
465: /**Serial Controlled only ****/
466: DELETE mtl_serial_numbers_temp
467: WHERE transaction_temp_id = p_temp_id;
468: ELSIF(v_lot_control_code = 2
469: AND v_serial_control_code NOT IN(1, 6)) THEN
470: /** Both lot and serial controlled **/

Line 491: UPDATE mtl_serial_numbers

487: LOOP
488: FETCH c_fm_to_lot_serial_number INTO l_fm_serial_number, l_to_serial_number;
489: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
490:
491: UPDATE mtl_serial_numbers
492: SET group_mark_id = NULL
493: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
494: --Bug 2940878 fix added org and item restriction
495: AND current_organization_id = l_org_id

Line 501: DELETE FROM mtl_serial_numbers_temp

497: END LOOP;
498:
499: CLOSE c_fm_to_lot_serial_number;
500:
501: DELETE FROM mtl_serial_numbers_temp
502: WHERE transaction_temp_id = l_serial_transaction_temp_id;
503: END LOOP;
504:
505: CLOSE c_lot_allocations;

Line 507: DELETE mtl_serial_numbers_temp

503: END LOOP;
504:
505: CLOSE c_lot_allocations;
506:
507: DELETE mtl_serial_numbers_temp
508: WHERE transaction_temp_id IN(SELECT mtlt.serial_transaction_temp_id
509: FROM mtl_transaction_lots_temp mtlt
510: WHERE mtlt.transaction_temp_id = p_temp_id);
511:

Line 822: FROM mtl_serial_numbers_temp

818:
819: CURSOR c_fm_to_serial_number (p_temp_id IN NUMBER) IS
820: SELECT fm_serial_number
821: , to_serial_number
822: FROM mtl_serial_numbers_temp
823: WHERE transaction_temp_id = p_temp_id;
824:
825:
826: CURSOR c_fm_to_lot_serial_number (p_sn_temp_id IN NUMBER) IS

Line 829: FROM mtl_serial_numbers_temp msnt

825:
826: CURSOR c_fm_to_lot_serial_number (p_sn_temp_id IN NUMBER) IS
827: SELECT fm_serial_number
828: , to_serial_number
829: FROM mtl_serial_numbers_temp msnt
830: WHERE msnt.transaction_temp_id = p_sn_temp_id;
831:
832:
833: CURSOR c_lot_allocations (p_temp_id IN NUMBER) IS

Line 1286: UPDATE mtl_serial_numbers

1282: LOOP
1283: FETCH c_fm_to_serial_number INTO l_fm_serial_number, l_to_serial_number;
1284: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
1285:
1286: UPDATE mtl_serial_numbers
1287: SET group_mark_id = NULL
1288: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
1289: AND current_organization_id = l_org_id
1290: AND inventory_item_id = l_item_id;

Line 1302: DELETE mtl_serial_numbers_temp

1298: END LOOP;
1299:
1300: CLOSE c_fm_to_serial_number;
1301:
1302: DELETE mtl_serial_numbers_temp
1303: WHERE transaction_temp_id = p_txn_temp_id;
1304:
1305: ELSIF(v_lot_control_code = 2
1306: AND v_serial_control_code NOT IN(1, 6))

Line 1326: UPDATE mtl_serial_numbers

1322: LOOP
1323: FETCH c_fm_to_lot_serial_number INTO l_fm_serial_number, l_to_serial_number;
1324: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
1325:
1326: UPDATE mtl_serial_numbers
1327: SET group_mark_id = NULL
1328: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
1329: AND current_organization_id = l_org_id
1330: AND inventory_item_id = l_item_id;

Line 1342: DELETE FROM mtl_serial_numbers_temp

1338: '. Now deleting MSNT ' || to_char(l_serial_transaction_temp_id)
1339: );
1340: END IF;
1341:
1342: DELETE FROM mtl_serial_numbers_temp
1343: WHERE transaction_temp_id = l_serial_transaction_temp_id;
1344: END LOOP;
1345: CLOSE c_lot_allocations;
1346: