APPS.WMS_UT_PKG dependencies on MTL_SERIAL_NUMBERS

Line 522: serrec mtl_serial_numbers%ROWTYPE;

518: -- ,,,,_{,,,,,,
519:
520: moqdrec mtl_onhand_quantities_detail%ROWTYPE;
521: lotrec mtl_lot_numbers%ROWTYPE;
522: serrec mtl_serial_numbers%ROWTYPE;
523:
524: l_last_item VARCHAR2(30);
525: l_item VARCHAR2(30);
526: l_sub_code VARCHAR2(30);}

Line 840: INSERT INTO mtl_serial_numbers

836:
837: print_debug('Inserting Serial : ' || serrec.serial_number || ' - item : ' || serrec.inventory_item_id);
838:
839:
840: INSERT INTO mtl_serial_numbers
841: ( INVENTORY_ITEM_ID
842: ,SERIAL_NUMBER
843: , LAST_UPDATE_DATE
844: , LAST_UPDATED_BY

Line 2238: FROM mtl_serial_numbers;

2234: AND mil.inventory_location_id (+) = mr.locator_id;
2235:
2236: CURSOR c_get_ser_rsvs(p_rsid NUMBER) IS
2237: SELECT serial_number
2238: FROM mtl_serial_numbers;
2239: --WHERE reservation_id = p_rsid;
2240:
2241: l_ix NUMBER;
2242: l_mo_line_id NUMBER;

Line 2252: --SELECT count(*) INTO l_ser_cnt FROM mtl_serial_numbers where reservation_id = l_rsv.reservation_id;

2248: FOR i in 1..g_demand_tbl.count LOOP
2249: FOR l_rsv in c_get_rsvs_lines(i) LOOP
2250:
2251: write_to_output(p_test_id, 'RSVS', l_rsv.p_text, p_run_id);
2252: --SELECT count(*) INTO l_ser_cnt FROM mtl_serial_numbers where reservation_id = l_rsv.reservation_id;
2253: IF l_ser_cnt > 0 THEN
2254: l_ser_txt := '';
2255: write_to_output(p_test_id, 'INFO',' ' || l_ser_cnt || ' serial numbers reserved.', p_run_id);
2256: FOR l_ser in c_get_ser_rsvs(l_rsv.reservation_id) LOOP

Line 2322: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt

2318: AND mil2.inventory_location_id (+) = mmtt.transfer_to_location;
2319:
2320: CURSOR c_get_msnt_lines(p_tid NUMBER) IS
2321: SELECT msnt.fm_serial_number || ',' || msnt.to_serial_number as stext
2322: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt
2323: WHERE mmtt.transaction_temp_id = p_tid
2324: AND msnt.transaction_temp_id = mmtt.transaction_temp_id
2325: AND msn.serial_number = msnt.fm_serial_number
2326: AND msn.inventory_item_id = mmtt.inventory_item_id;

Line 2330: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt

2326: AND msn.inventory_item_id = mmtt.inventory_item_id;
2327:
2328: CURSOR c_get_msnt_lines_wlot(p_tid NUMBER, p_lot_number VARCHAR2) IS
2329: SELECT msnt.fm_serial_number || ',' || msnt.to_serial_number as stext
2330: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt
2331: WHERE mmtt.transaction_temp_id = p_tid
2332: AND msnt.transaction_temp_id = mmtt.transaction_temp_id
2333: AND msn.serial_number = msnt.fm_serial_number
2334: AND msn.lot_number (+) = nvl(p_lot_number,'###')

Line 2569: UPDATE mtl_serial_numbers

2565: WHERE organization_id = p_org_id
2566: AND secondary_inventory_name = l_obj;
2567: ELSIF l_obj_type = 'SER' THEN
2568: print_debug('Setting status of SUB ' || l_obj || ' to ' || p_params(3));
2569: UPDATE mtl_serial_numbers
2570: SET status_id = l_status_id
2571: WHERE current_organization_id = p_org_id
2572: AND serial_number = l_obj
2573: AND inventory_item_id = l_item_id;

Line 2658: DELETE FROM mtl_serial_numbers_temp

2654: WHERE organization_id = p_org_id
2655: AND inventory_item_id = l_item_id;
2656: print_debug('Deleted All MOLs');
2657: FOR c_rec in c_mmtt(l_item_id) LOOP
2658: DELETE FROM mtl_serial_numbers_temp
2659: WHERE transaction_temp_id = c_rec.transaction_temp_id;
2660:
2661: DELETE FROM mtl_transaction_lots_temp
2662: WHERE transaction_temp_id = c_rec.transaction_temp_id;

Line 2673: DELETE FROM mtl_serial_numbers

2669: DELETE FROM mtl_reservations
2670: WHERE organization_id = p_org_id
2671: AND inventory_item_id = l_item_id;
2672:
2673: DELETE FROM mtl_serial_numbers
2674: WHERE current_organization_id = p_org_id
2675: AND inventory_item_id = l_item_id;
2676:
2677: DELETE FROM mtl_lot_numbers