실제 입출고 데이터를 재계산하여 warehouse_stock 재고를 검증합니다
출고창고(warehouse_stock.ware_code=1) = + Σ 입고등록(inbound_detail.inbound_qty WHERE inbound_master.ware_code='1') - Σ 출고등록(outbound_detail.outbound_qty WHERE outbound_master.ware_code=1) + Σ 큐빙입고(curing_history.curing_qty WHERE to_ware_code=1) 양성실(warehouse_stock.ware_code=2) = + Σ 생산양품입고(production_input_detail.production_qty WHERE production_input.ware_code='2') - Σ 큐빙수량(curing_history.curing_qty WHERE from_ware_code=2) - Σ 양생후불량(production_defect.defect_qty WHERE defect_type='양생후불량') 양생후불량 검증(production_defect.defect_qty) = Σ production_defect.defect_qty (WHERE defect_type='양생후불량') vs. Σ (production_input_detail.production_qty - curing_history.curing_qty) 각 production_detail_id별