解决方法:
UPDATE mtl_material_transactions_temp
SET cost_group_id = (SELECT cost_group_id FROM mtl_onhand_quantities_detail WHERE inventory_item_id = 571 AND subinventory_code = 'XB01' AND organization_id = 361 AND lot_number = '131206LY131125')
WHERE inventory_item_id = 571;