DBA Data[Home] [Help]

APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 158: DELETE FROM mtl_serial_numbers_temp

154: WHEN OTHERS THEN NULL;
155: END;
156: --
157: BEGIN
158: DELETE FROM mtl_serial_numbers_temp
159: WHERE product_transaction_id = p_bkup_rti_id;
160:
161: IF (g_asn_debug = 'Y') THEN
162: asn_debug.put_line('DELETED MSNT');

Line 1563: FROM mtl_serial_numbers_temp

1559: p_delivery_id IN NUMBER) IS
1560:
1561: CURSOR msnt_cursor IS
1562: SELECT *
1563: FROM mtl_serial_numbers_temp
1564: WHERE transaction_temp_id = p_wdd_rec.transaction_temp_id;
1565:
1566: l_temp_id NUMBER; -- Bug 11831232
1567: l_deliver_subinv rcv_transactions.subinventory%TYPE := NULL;