I am concerned about the row estimates
tableName_MOT are memberoy optimzed tables durbability = schema and data
i have changed the pk nonclustered on the temp tables and it seems to have helped. It removed some sorting before any nested/merge joins. i think there is more to gain, but i think i am missing something. Whether it is code related or schema related. I can post the schema is this process if that helps.