APPS.WMS_UNLOAD_UTILS_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

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