FROM oe_line o
INNER JOIN INSERTED i
ON o.line_no = i.line_no
I doubt the PK of oe_line is line_no. It it likely to be something like order_no, line_no.
Your JOIN should probably be:
FROM oe_line o
INNER JOIN inserted i
ON o.order_no = i.order_no
AND o.line_no = i.line_no
You might be onto something, since I'm seeing 2 PK's
......
order_no
and
line_no
I'll look into that..
thx,
Rich