The Application Engine program PSU_PROC_ORD uses values from PS_PSU_ORDER_DTL and PS_PSU_STOCK_TBL to update PS_PSU_STOCK_TBL.
You tested the following SQL Select statement in your database query tool and it returned the expected results.
(Line numbers have been added for clarity.)
A.
B.
C.
D.