How to link between shipment and Shipment ship unit Agents

How to link between shipment and Shipment ship unit Agents

I have 2 Agents one for Shipment and Other for Shipment Ship unit

Unfortunately, there is no Data Type Association in agent action between Shipment to S Ship Unit, So I can't make raise event action for shipment agent to run shipment ship unit agent.

FYI the Direct SQL in S Ship Unit Agent is as follows

UPDATE S_SHIP_UNIT SET UNIT_NET_WEIGHT = (SELECT ATTRIBUTE15 FROM SHIPMENT WHERE SHIPMENT_GID IN (SELECT SHIPMENT_GID FROM order_movement WHERE order_movement_GID IN (SELECT order_movement_GID FROM order_movement_D WHERE S_SHIP_UNIT_GID = $GID)))