SQL Queries - CAST Knowledge Base - Queries on objects - How to retrieve information about objects involved in the strongly connected component

delete from SYS_SITE_OPTIONS where OPTION_NAME = 'GRAPH_SAVE_LARGEST_SCC_GROUP';
Insert into SYS_SITE_OPTIONS(OPTION_NAME, OPTION_VALUE) values ('GRAPH_SAVE_LARGEST_SCC_GROUP', '1');

  SELECT *
FROM   (SELECT 'FAN-OUT MORE'       ,
               S.object_id OBJECT_ID,
               A.count_
       FROM    fp_largestscc S
               JOIN
                       (SELECT  A.caller_id                 OBJECT_ID,
                                COUNT(DISTINCT A.called_id) COUNT_
                       FROM     ctv_links A
                       WHERE    A.called_id IN
                                                (SELECT DISTINCT S.object_id
                                                FROM             fp_largestscc S
                                                )
                       GROUP BY A.caller_id
                       )
                       A
               ON      S.object_id = A.object_id
       
       UNION ALL
       
       SELECT   'FAN-IN MORE',
                S.object_id  ,
                A.count_
       FROM     fp_largestscc S
                JOIN
                         (SELECT  A.called_id                 OBJECT_ID,
                                  COUNT(DISTINCT A.caller_id) COUNT_
                         FROM     ctv_links A
                         WHERE    A.caller_id IN
                                                  (SELECT DISTINCT S.object_id
                                                  FROM             fp_largestscc S
                                                  )
                         GROUP BY A.called_id
                         )
                         A
                ON       S.object_id = A.object_id
       ORDER BY 3 DESC
       )
       F
       JOIN cdt_objects O
       ON     F.object_id = O.object_id