Event Triggering with DSU Updates shipment on Tracking Event object

INSERT INTO SHIPMENT_REFNUM (
SHIPMENT_GID,
SHIPMENT_REFNUM_QUAL_GID,
SHIPMENT_REFNUM_VALUE,
DOMAIN_NAME
)
SELECT DISTINCT SR.SHIPMENT_GID,
CASE
WHEN IES.ATTRIBUTE2 = 'APPROVE_DATE' THEN 'APPROVE_DATE'

END REFNUM_QUAL,
IES.ATTRIBUTE4,
SR.DOMAIN_NAME
FROM IE_SHIPMENTSTATUS IES
INNER JOIN ORDER_RELEASE ORR ON IES.ATTRIBUTE1 = GLOG_UTIL.REMOVE_DOMAIN(ORR.ORDER_BASE_GID)
INNER JOIN ORDER_MOVEMENT OM ON ORR.ORDER_RELEASE_GID = OM.ORDER_RELEASE_GID
AND OM.PERSPECTIVE = 'B'
AND OM.SHIPMENT_GID IS NOT NULL
INNER JOIN SHIPMENT_REFNUM SR ON OM.SHIPMENT_GID = SR.SHIPMENT_GID
AND GLOG_UTIL.REMOVE_DOMAIN(SR.SHIPMENT_REFNUM_QUAL_GID) = 'CONTAINER_NUMBER'