query to join CSE_FAILURE_EVENTS with WIE_WORK_ORDERS_B

Hello Oracle Community,

I need help finding a table or view to join the CSE_FAILURE_EVENTS table with the WIE_WORK_ORDERS_B table, rather than using WIE_WO_ASSETS. When I join CSE_FAILURE_EVENTS with WIE_WO_ASSETS by ASSET_ID, it displays incorrect output that differs from what I see on the screen. I need the join to be related to the work order.

Currently, the join displays failures and causes of other work orders that have the same ASSET_ID.

This is the query

select aah.ASSET_NUMBER,
aah.ASSET_id,
esib.Item_number,
wwob.WORK_ORDER_NUMBER ,