SQL Queries - CAST Central Base - How to get the list of missing technological objects

SELECT DISTINCT doi.OBJECT_ID                      ,
                doi.OBJECT_TYPE_ID                 ,
                dot.OBJECT_TYPE_NAME AS OBJECT_NAME,
                'Technologic '
                                || dot.OBJECT_TYPE_NAME
                                || ' object' AS OBJECT_DESCRIPTION,
                dot.OBJECT_TYPE_NAME         AS OBJECT_FULL_NAME
FROM            DSS_LINK_INFO dli
                JOIN DSS_OBJECT_INFO doi
                ON              doi.SNAPSHOT_ID = dli.SNAPSHOT_ID
                AND             doi.OBJECT_ID   = dli.NEXT_OBJECT_ID
                JOIN DSS_OBJECT_TYPES dot
                ON              dot.OBJECT_TYPE_ID = doi.OBJECT_TYPE_ID
                LEFT JOIN DSS_OBJECTS dos
                ON              dos.OBJECT_ID = dli.NEXT_OBJECT_ID
WHERE           dli.LINK_TYPE_ID              = 2
AND             dos.OBJECT_ID           IS NULL

Enter the SQL query

Enter the SQL query