Finding conveyed elements for information flows is messy - this clearly was added after the EA data model ossified. Here is a search that will tell you the source, target and flows conveying an element identified by its GUID:
SELECT Distinct o.ea_guid as CLASSGUID, o.Object_Type as CLASSTYPE, o.name As Source, c.name as Flow, trg.name as Destination
FROM t_object o, t_object trg, t_xref x, t_connector c
WHERE
'<Search Term>' IN (
#DB=SQLSVR#s substring(x.description,0,39), substring(x.description,39,39), substring(x.description,78,39), substring(x.description,117,39), substring(x.description,156,39), substring(x.description,195,39), substring(x.description,234,39),
substring(x.description,273,39), substring(x.description,312,39),substring(x.description,351,39)
#DB=SQLSVR#
#DB=Other#
left(x.description,38), mid(x.description,40,38), mid(x.description,79,38), mid(x.description,118,38), mid(x.description,157,38), mid(x.description,196,38), mid(x.description,235,38), mid(x.description,274,38), mid(x.description,313,38), mid(x.description,352,38)
#DB=Other#
)
AND x.Behavior = 'conveyed'
AND c.ea_guid = x.Client
AND o.object_id = c.Start_Object_ID
AND trg.object_id = c.End_Object_ID
order by o.name
You can write a simple script to get the element GUID from the project browser or a diagram, then call the search, or just copy/paste the GUID into the search parameter.
