how we can fetch cancel or reject reason for procurement requisition in oracle sql ?

If there is 1 requisition having 3 lines with header status rejected but line 1 is canceled and line 2 and 3 are rejected.

Then how can we find the reason behind it and who has canceled or rejected it?