Biztalk SQL Queries: Get List of send port details by APPLICATION NAME

select
   app.nvcName as ApplicationName,
   sp.nvcName as SendPortName,
   sptp.nvcAddress as SPUri,
   sp.nvcFilter
from bts_sendport as  sp
inner join bts_sendport_transform as spt on  spt.nSendPortID =sp.nID
left join bts_sendport_transport  as sptp on sptp.nSendPortID = sp.nID
inner join bts_application as app on app.nID = sp.nApplicationID

where
 app.nvcName like '%Application Name%'
and
sptp.nvcAddress <> ''