APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_SERIAL_NUMBERS

Line 2114: identify the serial numbers in mtl serial numbers.

2110: DESCRIPTION : Call Inventory's serial number mark API.
2111: - frontport bug 5028993 : change from here
2112: - before fix : Uses the delivery
2113: detail id as the group mark id, temp lot id and temp id to
2114: identify the serial numbers in mtl serial numbers.
2115: - after fix : When serial_number is
2116: not null, use the transaction_temp_id created by using the
2117: sequence mtl_material_transactions_s as group_mark_id.
2118: - frontport bug 5028993 : change to here

Line 2140: FROM MTL_SERIAL_NUMBERS_TEMP

2136:
2137: CURSOR Fetch_Serial_Ranges IS
2138: SELECT Fm_Serial_Number, To_Serial_Number,
2139: Serial_Prefix
2140: FROM MTL_SERIAL_NUMBERS_TEMP
2141: WHERE transaction_temp_id = p_transaction_temp_id;
2142:
2143: -- Bug 5028993: needs to pass transaction_temp_id
2144: CURSOR c_temp_id IS

Line 2430: FROM MTL_SERIAL_NUMBERS_TEMP

2426:
2427: CURSOR Fetch_Serial_Ranges IS
2428: SELECT Fm_Serial_Number, To_Serial_Number,
2429: Serial_Prefix
2430: FROM MTL_SERIAL_NUMBERS_TEMP
2431: WHERE transaction_temp_id = p_transaction_temp_id
2432: FOR UPDATE OF fm_serial_number NOWAIT;
2433:
2434: --RTV changes

Line 2573: DELETE FROM mtl_serial_numbers

2569: l_inventory_item_id);
2570:
2571: --Bugfix 8517694 Start - Deleting the unmarked serial numbers of "Sales Order issue" types so as make them available for different Items.
2572: IF p_serial_number_code = 6 AND NVL(l_efc_serial_control,1) = 1 THEN --RTV changes
2573: DELETE FROM mtl_serial_numbers
2574: WHERE inventory_item_id = l_inventory_item_id
2575: AND current_status = 6
2576: AND (group_mark_id IS NULL or group_mark_id = -1);
2577: END IF;

Line 2623: DELETE FROM MTL_SERIAL_NUMBERS_TEMP

2619: l_inventory_item_id);
2620:
2621: END LOOP;
2622:
2623: DELETE FROM MTL_SERIAL_NUMBERS_TEMP
2624: WHERE transaction_temp_id = p_transaction_temp_id;
2625:
2626: IF SQLCODE <> 0 THEN
2627: FND_MESSAGE.SET_NAME('WSH','WSH_SER_TEMP_CLEAR_ERROR');

Line 2642: DELETE FROM mtl_serial_numbers

2638: END IF;
2639:
2640: --Bugfix 8517694 Start - Deleting the unmarked serial numbers of "Sales Order issue" types so as make them available for different Items.
2641: IF p_serial_number_code = 6 AND NVL(l_efc_serial_control,1) = 1 THEN --RTV changes
2642: DELETE FROM mtl_serial_numbers
2643: WHERE inventory_item_id = l_inventory_item_id
2644: AND current_status = 6
2645: AND (group_mark_id IS NULL or group_mark_id = -1);
2646: END IF;

Line 3882: FROM MTL_SERIAL_NUMBERS_TEMP

3878: p_delivery_detail_id IN NUMBER) RETURN NUMBER IS
3879:
3880: CURSOR Get_Ser_Qty (v_trx_temp_id NUMBER) IS
3881: SELECT sum (serial_prefix)
3882: FROM MTL_SERIAL_NUMBERS_TEMP
3883: WHERE transaction_temp_id = nvl(v_trx_temp_id,transaction_temp_id);
3884:
3885: CURSOR Get_Detail_Info IS
3886: SELECT transaction_temp_id, inventory_item_id, shipped_quantity,