按以下语句写接口
SELECT *
FROM (SELECT AmazonShipmentId,A.OrderSourceID, A.WareHouseID,D.WareHouseName, B.TransportName,B.TransportType,
ROW_NUMBER() OVER(partition by AmazonShipmentId,A.OrderSourceID, A.WareHouseID, B.TransportName,B.TransportType ORDER BY A.ID DESC) AS RowIndex
FROM RB_OrderInfo A(NOLOCK) LEFT JOIN RB_Transport B(NOLOCK) ON A.TransportID=B.ID
INNER JOIN RB_OrderSource C(NOLOCK) ON A.OrderSourceID=C.ID
INNER JOIN RB_WareHouse D(NOLOCK) ON A.WareHouseID=D.ID
WHERE IsStockOrder=1 AND AmazonShipmentId in('FBA16V0S48H7') and C.CustomerID=1
AND C.OrderSourceType=1 AND D.WareHouseType<>1
) T
WHERE RowIndex=1
1.地址：erp/platforms/listings/getWareHouseTransportNames
入参：
"AmazonShipmentId": " FBA15DVFFYBD",
"TransportType": null
2.测试记录：