how to find the delivery_id of an order with canceled_flag status in oe_order_headers_all

In operational need, I need to list all delivery_ids of orders that were canceled in oe_order_headers_all, I did not find a connection between the tables, for example, in wsh_deliverables_v, after the order was cancelled, the field referring to delivery_id becomes null

{screenshot removed by admin}

and also in additional information from the order organizer