APPS.WMS_UNLOAD_UTILS_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

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 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 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 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 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: