APPS.WMS_UNLOAD_UTILS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 75: FROM mtl_serial_numbers_temp

71:
72: CURSOR c_fm_to_serial_number IS
73: SELECT fm_serial_number
74: , to_serial_number
75: FROM mtl_serial_numbers_temp
76: WHERE transaction_temp_id = p_temp_id;
77:
78: CURSOR c_fm_to_lot_serial_number (p_sn_temp_id IN NUMBER) IS
79: SELECT fm_serial_number

Line 81: FROM mtl_serial_numbers_temp msnt

77:
78: CURSOR c_fm_to_lot_serial_number (p_sn_temp_id IN NUMBER) IS
79: SELECT fm_serial_number
80: , to_serial_number
81: FROM mtl_serial_numbers_temp msnt
82: WHERE msnt.transaction_temp_id = p_sn_temp_id;
83:
84: CURSOR c_lot_allocations IS
85: SELECT serial_transaction_temp_id

Line 316: UPDATE mtl_serial_numbers

312: LOOP
313: FETCH c_fm_to_serial_number INTO l_fm_serial_number, l_to_serial_number;
314: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
315:
316: UPDATE mtl_serial_numbers
317: SET group_mark_id = NULL
318: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
319: --Bug 2940878 fix added org and item restriction
320: AND current_organization_id = l_org_id

Line 327: DELETE mtl_serial_numbers_temp

323:
324: CLOSE c_fm_to_serial_number;
325:
326: /**Serial Controlled only ****/
327: DELETE mtl_serial_numbers_temp
328: WHERE transaction_temp_id = p_temp_id;
329: ELSIF(v_lot_control_code = 2
330: AND v_serial_control_code NOT IN(1, 6)) THEN
331: /** Both lot and serial controlled **/

Line 352: UPDATE mtl_serial_numbers

348: LOOP
349: FETCH c_fm_to_lot_serial_number INTO l_fm_serial_number, l_to_serial_number;
350: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
351:
352: UPDATE mtl_serial_numbers
353: SET group_mark_id = NULL
354: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
355: --Bug 2940878 fix added org and item restriction
356: AND current_organization_id = l_org_id

Line 362: DELETE FROM mtl_serial_numbers_temp

358: END LOOP;
359:
360: CLOSE c_fm_to_lot_serial_number;
361:
362: DELETE FROM mtl_serial_numbers_temp
363: WHERE transaction_temp_id = l_serial_transaction_temp_id;
364: END LOOP;
365:
366: CLOSE c_lot_allocations;

Line 368: DELETE mtl_serial_numbers_temp

364: END LOOP;
365:
366: CLOSE c_lot_allocations;
367:
368: DELETE mtl_serial_numbers_temp
369: WHERE transaction_temp_id IN(SELECT mtlt.serial_transaction_temp_id
370: FROM mtl_transaction_lots_temp mtlt
371: WHERE mtlt.transaction_temp_id = p_temp_id);
372:

Line 627: FROM mtl_serial_numbers_temp

623:
624: CURSOR c_fm_to_serial_number (p_temp_id IN NUMBER) IS
625: SELECT fm_serial_number
626: , to_serial_number
627: FROM mtl_serial_numbers_temp
628: WHERE transaction_temp_id = p_temp_id;
629:
630:
631: CURSOR c_fm_to_lot_serial_number (p_sn_temp_id IN NUMBER) IS

Line 634: FROM mtl_serial_numbers_temp msnt

630:
631: CURSOR c_fm_to_lot_serial_number (p_sn_temp_id IN NUMBER) IS
632: SELECT fm_serial_number
633: , to_serial_number
634: FROM mtl_serial_numbers_temp msnt
635: WHERE msnt.transaction_temp_id = p_sn_temp_id;
636:
637:
638: CURSOR c_lot_allocations (p_temp_id IN NUMBER) IS

Line 965: UPDATE mtl_serial_numbers

961: LOOP
962: FETCH c_fm_to_serial_number INTO l_fm_serial_number, l_to_serial_number;
963: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
964:
965: UPDATE mtl_serial_numbers
966: SET group_mark_id = NULL
967: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
968: AND current_organization_id = l_org_id
969: AND inventory_item_id = l_item_id;

Line 981: DELETE mtl_serial_numbers_temp

977: END LOOP;
978:
979: CLOSE c_fm_to_serial_number;
980:
981: DELETE mtl_serial_numbers_temp
982: WHERE transaction_temp_id = p_txn_temp_id;
983:
984: ELSIF(v_lot_control_code = 2
985: AND v_serial_control_code NOT IN(1, 6))

Line 1005: UPDATE mtl_serial_numbers

1001: LOOP
1002: FETCH c_fm_to_lot_serial_number INTO l_fm_serial_number, l_to_serial_number;
1003: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
1004:
1005: UPDATE mtl_serial_numbers
1006: SET group_mark_id = NULL
1007: WHERE serial_number BETWEEN l_fm_serial_number AND l_to_serial_number
1008: AND current_organization_id = l_org_id
1009: AND inventory_item_id = l_item_id;

Line 1021: DELETE FROM mtl_serial_numbers_temp

1017: '. Now deleting MSNT ' || to_char(l_serial_transaction_temp_id)
1018: );
1019: END IF;
1020:
1021: DELETE FROM mtl_serial_numbers_temp
1022: WHERE transaction_temp_id = l_serial_transaction_temp_id;
1023: END LOOP;
1024: CLOSE c_lot_allocations;
1025: