The query gives the name of the project and the type of the project for a given link

Release
Yes/No
8.2..x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
SELECT ac.idacc as "ID OF THE LINK",
       k1.keynam as "NAME OF THE CALLER",
       k2.keynam as "NAME OF THE CALLEE",
       kt.keynam as "NAME OF THE PROJECT",
       t.typdsc as "NAME OF THE TYPE OF PROJECT"
FROM   acc ac 
       JOIN keys k1 
         ON k1.idkey = ac.idclr
       JOIN keys k2
         ON k2.idkey = ac.idcle
       JOIN Keys kt
         ON kt.idkey = ac.idpro
       JOIN typ t 
         ON t.idtyp = kt.objtyp 
WHERE k1.keynam like '%<NAME OF THE CALLER OBJECT>%'
AND k2.keynam like '%<NAME OF THE CALLEE OBJECT>%'