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