SELECT
bill.GMT_CREATE AS bill_start_time,
barcodeH.CHECK_TIME ,
bill.src_code,
barcodeH.CHECK_STATUS  ,
barcodeH.CONTAINER_CODE ,
barcodeH.LCL_NO ,
barcodeH.BARCODE ,
barcodeH.MERGED_CODE barcode_merged_code ,
omsbill.SALESPERSON_NAME ,
omsbill.SALE_BRANCHNAME
FROM UPCLOUD_BIZ_OUTBOUND.WMS_BARCODE_H barcodeH
INNER  JOIN UPCLOUD_BIZ_OUTBOUND.WMS_WAVE_BILL  bill ON bill.BILL_GROUP_ID = barcodeH.BILL_GROUP_ID
LEFT JOIN UPCLOUD_BIZ_OUTBOUND.OMS_DO_BILL_H omsbill ON omsbill.BILLID = bill.src_id
WHERE barcodeH.CHECK_STATUS = 5  and bill.warehouse_id = #{name:warehouseId,value:""}