91: UPDATE rcv_transactions
92: SET receipt_confirmation_extracted = l_RC_Extracted
93: WHERE transaction_id IN
94: (SELECT transaction_id
95: FROM rcv_receipt_confirmation_v
96: WHERE creation_date BETWEEN l_from_date AND l_to_date
97: AND category = nvl(l_category, category)
98: AND warehouse = l_warehouse
99: AND item = nvl(l_inventory_item, item)