For traceability how I can list Lot/Serial Number for a MO in odoo view ?

ex: Product A serial = 00001 was made with Product B serial 00002 and Product C lot 00003

I found this sql query to check information exist in database:

select stock_move_lots.lot_id, stock_move_lots.product_id, l1.name, l2.name from stock_move_lots
left join stock_production_lot l1 on stock_move_lots.lot_id = l1.id left join stock_production_lot l2 on stock_move_lots.lot_produced_id = l2.id where production_id = 10 ;