SELECT * FROM t_amz_fba_shipment_item where msku='O111EB22408EFPM5SRFAKJ'
SELECT track_number FROM rb_package where amazon_shipment_id in ('FBA1763Z4MGK','FBA1776FV4HQ')
SELECT * FROM rb_package_track where track_number in (SELECT track_number FROM rb_package where amazon_shipment_id in ('FBA1763Z4MGK','FBA1776FV4HQ')
)

测试步骤:
1.准备测试数据,t_amz_fba_virtual_inventory msku:O111EB22408EFPM5SRFAKJ,预计下一票到货时间和首次到货时间为空
2.t_amz_fba_shipment_item receiving_time 为空
3.rb_package_track,rb_package 对应货件FBA1776FV4HQ
4.执行MQ货件增量同步/queue_application_fba_shipment_full_deal_queue
数据结果:预计下一票到货时间跑出来了,但是首次到货时间无值,首次到货时间取item第一次签收时间,item第一次签收时间取自包裹轨迹表rb_package_track