The query below shows how to join the BizTalk Receive Port and Receive Location, along with the Application Name.

<pre>
select app.nvcName,
       rp.nvcName as ReceivePort, 
       bTwoWay, 
       rl.Name as ReceiveLocation,
       InboundTransportURL, 
       ReceivePipelineData
  from bts_receiveport rp 
inner join adm_ReceiveLocation rl on rl.ReceivePortId = rp.nID 
inner join bts_application app on rp.nApplicationID = app.nID 
--where InboundTransportURL like '%test%'
order by rl.Name 
</pre>

Remember that in BizTalk, one receive port can have many receive locations.
Reasons for doing that is that each receive location can have a different disk directory, file mask, and/or different pipeline.

Mapping is done at the Receive Port level, so all Receive Locations will have the same mapping.

A SendPort is often subscribed to a ReceivePort. It is not possible to filter or subscribe to a ReceiveLocation.