SELECT * FROM t_amz_fba_shipment aa LEFT JOIN t_amz_fba_shipment_item bb on aa.shipment_id =bb.shipment_id
where bb.asin='B09KNNN535' and aa.is_completed=0 and bb.msku='1Q-MHEE-AYBR'

SELECT source_id,msku,p_asin,asin,transit_quantity FROM t_amz_product_performance_inventory WHERE asin ='B09KNNN535' and country_code='US' ORDER BY transit_quantity desc
