Hi
You need the ie_shipmentstatus table - though you will need to join in the i_transaction table to relate it to your shipment..
select t.object_gid, s.*
from ie_shipmentstatus s, i_transaction t
where s.I_TRANSACTION_NO=t.I_TRANSACTION_NO
and t.object_gid = <SHIPMENT_GID>
Gary
