SQL Queries - CAST Central Base - Queries on applications - How to get the List of Technologies used in an Application

SELECT DISTINCT OBJECT_NAME AS TECHNOLOGY
FROM            DSS_OBJECTS
WHERE           OBJECT_ID IN
                (SELECT         M1.OBJECT_ID
                FROM            DSS_METRIC_RESULTS M1
                                LEFT OUTER JOIN DSS_METRIC_RESULTS M2
                                ON              (
                                                                M1.METRIC_ID          = M2.METRIC_ID
                                                AND             M1.OBJECT_ID          = M2.OBJECT_ID
                                                AND             M2.SNAPSHOT_ID        = -1
                                                AND             M2.METRIC_VALUE_INDEX = M1.METRIC_VALUE_INDEX
                                                )
                                JOIN DSS_LINKS T
                                ON              (
                                                                T.NEXT_OBJECT_ID = M1.OBJECT_ID
                                                )
                                JOIN DSS_OBJECTS DSSO
                                ON              DSSO.OBJECT_ID=T.PREVIOUS_OBJECT_ID
                WHERE           M1.METRIC_ID                  = 60017
                AND             T.LINK_TYPE_ID                = 2
                AND             DSSO.OBJECT_NAME              = <APPLICATION_NAME> -- here 'App1'
                AND             M1.METRIC_VALUE_INDEX         = 0
                )

SELECT DISTINCT OBJECT_NAME AS TECHNOLOGY
FROM            DSS_OBJECTS
WHERE           OBJECT_ID IN
                (SELECT         M1.OBJECT_ID
                FROM            DSS_METRIC_RESULTS M1
                                LEFT OUTER JOIN DSS_METRIC_RESULTS M2
                                ON              (
                                                                M1.METRIC_ID          = M2.METRIC_ID
                                                AND             M1.OBJECT_ID          = M2.OBJECT_ID
                                                AND             M2.SNAPSHOT_ID        = -1
                                                AND             M2.METRIC_VALUE_INDEX = M1.METRIC_VALUE_INDEX
                                                )
                                JOIN DSS_LINKS T
                                ON              (
                                                                T.NEXT_OBJECT_ID = M1.OBJECT_ID
                                                )
                                JOIN DSS_OBJECTS DSSO
                                ON              DSSO.OBJECT_ID=T.PREVIOUS_OBJECT_ID
                WHERE           M1.METRIC_ID                  = 60017
                AND             T.LINK_TYPE_ID                = 2
                AND             DSSO.OBJECT_NAME              = <APPLICATION_NAME> -- here 'App2'
                AND             M1.METRIC_VALUE_INDEX         = 0
                )