How to get sales order number associated with a work order after the work order completion?

Hi,

I have a requirement to write a query to get the sales order number associated with the work order. I am able to get the details before the work order is completed using the below query. But once the work order is completed the association is lost. Is there any table in Oracle R12.2.9 which stores the association of the sales order and work order after the work order completion? Or do I need to do any customization?

SELECT ooh.header_id

,ooh.order_number

,wdj.wip_entity_id

, we.wip_entity_name wip_job_name

FROM oe_order_headers_all ooh