SELECT * FROM t_amz_fba_virtual_inventory where id=1846158;
SELECT * FROM t_amz_fba_virtual_inventory where transit_quantity>0  and msku='B003122Z1884712Y';

找出库存对应的souceid和msku

SELECT * FROM t_amz_fba_virtual_inventory where id=1846158;
SELECT * FROM t_amz_fba_virtual_inventory_country WHERE virtual_id = 1846158;

二、erp没有对应的包裹信息

SELECT
*
FROM
t_amz_fba_shipment_item
WHERE
( customer_id, seller_id, source_id, msku, fnsku) 
IN ((1,'A2G1X0QTH4RMPX',5125,'B003122Z1884712Y','X002E114UJ'));




三、msku没有对应的货件信息，没法计算在途。

SELECT
*
FROM
t_amz_fba_shipment_item
WHERE
( customer_id, seller_id, source_id, msku, fnsku) 
IN ((1,'A2G1X0QTH4RMPX',6407,'B003122Z1884712Y','X002E114UJ'))