APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_SERIAL_NUMBERS

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

1884: DESCRIPTION : Call Inventory's serial number mark API.
1885: - frontport bug 5028993 : change from here
1886: - before fix : Uses the delivery
1887: detail id as the group mark id, temp lot id and temp id to
1888: identify the serial numbers in mtl serial numbers.
1889: - after fix : When serial_number is
1890: not null, use the transaction_temp_id created by using the
1891: sequence mtl_material_transactions_s as group_mark_id.
1892: - frontport bug 5028993 : change to here

Line 1914: FROM MTL_SERIAL_NUMBERS_TEMP

1910:
1911: CURSOR Fetch_Serial_Ranges IS
1912: SELECT Fm_Serial_Number, To_Serial_Number,
1913: Serial_Prefix
1914: FROM MTL_SERIAL_NUMBERS_TEMP
1915: WHERE transaction_temp_id = p_transaction_temp_id;
1916:
1917: -- Bug 5028993: needs to pass transaction_temp_id
1918: CURSOR c_temp_id IS

Line 2173: FROM MTL_SERIAL_NUMBERS_TEMP

2169:
2170: CURSOR Fetch_Serial_Ranges IS
2171: SELECT Fm_Serial_Number, To_Serial_Number,
2172: Serial_Prefix
2173: FROM MTL_SERIAL_NUMBERS_TEMP
2174: WHERE transaction_temp_id = p_transaction_temp_id
2175: FOR UPDATE OF fm_serial_number NOWAIT;
2176:
2177: CURSOR Fetch_Item IS

Line 2310: DELETE FROM MTL_SERIAL_NUMBERS_TEMP

2306: l_inventory_item_id);
2307:
2308: END LOOP;
2309:
2310: DELETE FROM MTL_SERIAL_NUMBERS_TEMP
2311: WHERE transaction_temp_id = p_transaction_temp_id;
2312:
2313: IF SQLCODE <> 0 THEN
2314: FND_MESSAGE.SET_NAME('WSH','WSH_SER_TEMP_CLEAR_ERROR');

Line 3552: FROM MTL_SERIAL_NUMBERS_TEMP

3548: p_delivery_detail_id IN NUMBER) RETURN NUMBER IS
3549:
3550: CURSOR Get_Ser_Qty (v_trx_temp_id NUMBER) IS
3551: SELECT sum (serial_prefix)
3552: FROM MTL_SERIAL_NUMBERS_TEMP
3553: WHERE transaction_temp_id = nvl(v_trx_temp_id,transaction_temp_id);
3554:
3555: CURSOR Get_Detail_Info IS
3556: SELECT transaction_temp_id, inventory_item_id, shipped_quantity,