This part is probably the obvious one, but: TFOrdDtl is a Transfer Order Line. It’s the table for that.
My point is that TFOrdDtl is notorious for dragging down queries. I don’t have a clue why.
It used to hang up MRP for us - there is a SQL query (not BAQ) that MRP runs against TFOrdDtl that typically runs in seconds (or less) but would go over an hour at random and even exceed server timeouts (thus killing MRP).
So I’m just saying, I can see how that particular table is inexplicably causing issues.
Been there - with ‘TFOrdDtl’ specifically.
You can try forcing a better plan, once you find your query that is bombing out.