Should I be alarmed by this NO JOIN PREDICATE warning?
Because we know that l.id = '732820' and ls.id = l.id then SQL Server derives that ls.id = '732820'

i.e.

FROM   db2.dbo.VIEW ls
       JOIN db1.dbo.table l
         ON ls.id = l.id
WHERE  l.id = '732820' 


is the same as 

  ( /*...*/ FROM   db2.dbo.VIEW ls WHERE id = '732820'  )
   CROSS JOIN 
  ( /*...*/  FROM   db1.dbo.table l WHERE id = '732820'  )


This rewrite is not bad for performance .


  This derivation is a good thing.  It allows SQL Server to filter out
  rows ... earlier than would otherwise be possible.