How to create a data model that links Sales Orders with Work Orders using the Supply and Demand view

We are trying to create a reporting or analytical model that links Sales Orders (SO) to Work Orders (WO) through the underlying Supply and Demand data model in Oracle Fusion Cloud. The goal is to understand what work orders are fulfilling specific customer orders.

Despite exploring standard views such as MSC_ANALYTIC_END_DEMANDS, we are unable to find a reliable way to relate a demand (Sales Order) to its supply (Work Order), specifically through the demand_id field or other relevant keys.