Join Validated Date to Invoice Details in OTBI Data Model

Summary:

We are trying to write a query in OTBI to create a data model that joins Validated Date and Validated By to Invoice Details. In running the query below, we noticed validated dates are being joined to incorrect invoices. We also receive a time out error (the memory guard settings are locked)

Content (please ensure you mask any confidential information):

Two questions - is there a different way we need to join tables so we don't see incorrect dates? Also, is there a better way to write the query to increase performance?

SELECT DISTINCT XE.EVENT_ID,
XE.EVENT_TYPE_CODE,