| 123456789101112131415 |
- 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:""}
|
