Electronic Component Lot Traceability SQL Query Generator

SELECT DISTINCT o.serial_no, i.wo_no, i.part_no, i.lot_no
FROM wo_material_issue i
JOIN wo_serial_output o ON o.wo_no = i.wo_no
WHERE i.part_no = 'IC-FPGA-1042'
  AND i.lot_no = '2419-B7'
ORDER BY i.wo_no, o.serial_no;

SELECT i.part_no, i.lot_no, i.wo_no
FROM wo_serial_output o
JOIN wo_material_issue i ON i.wo_no = o.wo_no
WHERE o.serial_no = 'SN-000123'
ORDER BY i.part_no, i.lot_no;

SELECT r.part_no, r.lot_no
FROM inv_lot_receipt r
WHERE r.part_no = 'IC-FPGA-1042'
  AND r.lot_no = '2419-B7';

SELECT r.part_no, r.lot_no
FROM inv_lot_receipt r
WHERE r.part_no = 'IC-FPGA-1042'
  AND r.lot_no <> '2419-B7'
  AND r.receipt_date >= '2026-01-01'
ORDER BY r.receipt_date;