select 
    c.Connector_id,
	c.Stereotype as "Connector_Stereotype",
	c.Connector_Type,
	osrc.stereotype as "Src_Stereotype",
    osrc.object_type as "Src_Type",
	odest.stereotype as "Dest_Stereotype",
    odest.object_type as "Dest_Type"
from 
    t_connector c, 
    t_object osrc, 
    t_object odest 
where 
        osrc.object_id = c.start_object_id 
    and odest.object_id = c.end_object_id 
    and NOT c.stereotype is null
    and NOT osrc.stereotype is null
    and NOT odest.stereotype is null
	and osrc.Package_ID = 318
	and odest.Package_ID = 318
order by
     c.Stereotype, osrc.stereotype, odest.stereotype