SQL Queries - CAST Knowledge Base - Queries on Transactions - How to list Transactions reaching a given end point

SELECT t51.object_id, 
       t51.object_name txn_obj_name, 
       t31.object_name end_point_name 
FROM   dss_objects t11, 
       dss_links t21, 
       cdt_objects t31, 
       dss_transaction t41, 
       cdt_objects t51 
WHERE  t11.object_type_id = 30002 
       AND t11.object_id = t21.previous_object_id 
       AND t21.next_object_id = t31.object_id 
       AND t31.object_name = 'END_of_Transaction' ---END POINT OBJECT_NAME 
       AND t41.object_id = t11.object_id 
       AND t41.form_id = t51.object_id 
       AND t51.object_id IN (SELECT t51.object_id 
                             FROM   dss_objects t11, 
                                    dss_links t21, 
                                    cdt_objects t31, 
                                    dss_transaction t41, 
                                    cdt_objects t51 
                             WHERE  t11.object_type_id = 30002 
                                    AND t11.object_id = t21.previous_object_id 
                                    AND t21.next_object_id = t31.object_id 
                                    AND t21.link_type_id = 11004 
                                    AND t41.object_id = t11.object_id 
                                    AND t41.form_id = t51.object_id 
                             GROUP  BY t51.object_id 
                             HAVING Count(t51.object_id) = 1);