Biztalk SQL Queries: Get List of receive locations and receive ports details by receive location name

select
 
   app.nvcName as ApplicationName,
   rp.nvcName AS ReceivePortName,
   rl.Name as ReceiveLocationName,
   rl.InboundTransportURL

from bts_application as app

left join dbo.bts_receiveport as rp on rp.nApplicationID = app.nID
left join dbo.adm_ReceiveLocation as rl on rl.ReceivePortId = rp.nID
left join dbo.bts_receiveport_transform as rpt on rpt.nReceivePortID = rp.nID

where

rl.Name like '%invoice%'