APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_SERIAL_NUMBERS_TEMP

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