SELECT d.CustomerID,
       a.SKU,
       a.ClientSKU,
       a.ImageUrl AS ProductImageUrl,
       a.IsGroup,
       e.OrderSourceSKU AS MNSKU,
       ISNULL(pos.ASINorItemID, '') ASIN,
       ISNULL(e.OrderSourceSKUID, 0) OrderSourceSKUID,
       a.ProductName,
       a.ProductNameCN,
       ISNULL(d.ProductNum, 0) PlanOrderQuantity,
       ISNULL(d.ProductNum, 0) FinalDeliverOrderQuantity,
       ISNULL(a.Carton_PcsNum, 0) Carton_PcsNum,
       ISNULL(a.GrossWeight, 0) GrossWeight,
       ISNULL(a.Pack_Length, 0) Pack_Length,
       ISNULL(a.Pack_Width, 0) Pack_Width,
       ISNULL(a.Pack_Height, 0) Pack_Height,
       a.Length,
       a.Width,
       a.Height,
       ISNULL(a.TaxPoint, 0) TaxPoint,
       ISNULL(a.TaxRate, 0) TaxRate,
       ISNULL(a.IsCheckDeclarationCode, 0) IsCheckDeclarationCode,
       ISNULL(a.IsCheckTransport, 0) IsCheckTransport,
       ISNULL(e.RecommendedOrderQuantity, 0) RecommendedOrderQuantity,
       ISNULL(e.cgzNum, 0) ProcessingNum,
       a.SKU AS GroupSKU,
       a.WithBattery,
       ISNULL(pa.BuyerName, '') BuyerName,
       ISNULL(dwh.WareHouseName, '') DefaultLocalWarehouseName,
       ISNULL(a.IsFBABarCode, 0) AS IsFBABarCode,
       ISNULL(ps.IsFBABarCode, 0) AS PIsFBABarCode,
       a.ProductState,
       a.ProdutcArrivalDate,
       ISNULL(d.CartOrderRemarks, '') AS CartOrderRemarks,
       d.TransferType,
       d.ID
FROM RB_CartOrderDetail d WITH (NOLOCK)
    LEFT JOIN RB_Amazon_Product_Base e WITH (NOLOCK)
        ON d.[CustomerID] = e.[CustomerID]
           AND d.ListingID = e.OrderSourceSKUID
           AND e.IsDelete = 0
    LEFT JOIN RB_Product a WITH (NOLOCK)
        ON a.CustomerID = e.CustomerID
           AND a.SKU = e.SKU
    LEFT JOIN dbo.RB_Product_Admin (NOLOCK) pa
        ON pa.SKU = a.SKU
           AND pa.CustomerID = a.CustomerID
    LEFT JOIN dbo.RB_WareHouse (NOLOCK) dwh
        ON dwh.CustomerID = a.CustomerID
           AND a.DefaultLocalWarehouse = dwh.ID
    LEFT JOIN dbo.RB_Product_OrderSourceSKU (NOLOCK) pos
        ON pos.CustomerID = e.CustomerID
           AND pos.ID = e.OrderSourceSKUID
    LEFT JOIN RB_Product_SupplierPrice psp WITH (NOLOCK)
        ON a.CustomerID = psp.CustomerID
           AND a.SKU = psp.SKU
           AND psp.IsDefault = 1
    LEFT JOIN RB_Product_Supplier ps WITH (NOLOCK)
        ON psp.SupplierID = ps.ID
           AND psp.CustomerID = ps.CustomerID
WHERE d.CustomerID = 1
      AND d.AdminID = 7374
      AND d.CartOrderID = 613819;

listingV2 购物车创建货件数据表中ListingID 字段没有值导致关联不到亚马逊产品数据表RB_Amazon_Product_Base 
同时表RB_Amazon_Product_Base  listing 那边在慢慢启用  需要调研发起需求调整