SQL Queries - CAST Central Base - Queries on snapshots - How to identify all the objects invoved in AFP modification for specific snapshot and for all applications

select distinct dost.OBJECT_ID as "Modified Transaction ID",
 dost.OBJECT_NAME as "Modified Transaction Name",
 dos.OBJECT_ID as "Modified Object ID",
 dos.OBJECT_NAME as "Modified Object Name",
 dos.OBJECT_FULL_NAME as "Modified Object Full Name",
 dot.OBJECT_TYPE_ID as "Modified Object Type ID",
 dot.OBJECT_TYPE_NAME as "Modified Object Type Name"
 from (select dlic.SNAPSHOT_ID,
 dlic.PREVIOUS_OBJECT_ID as TRANSACTION_ID,
 dlic.NEXT_OBJECT_ID as OBJECT_ID,
 dlic.LINK_TYPE_ID
 from [CB Schema].DSS_LINK_INFO dlic
 where dlic.LINK_TYPE_ID in (11000, 11001, 11002, 11003, 11004)
 ) dlic
 join [CB Schema].DSS_OBJECTS dos
 on dos.OBJECT_ID = dlic.OBJECT_ID
 join [CB Schema].DSS_OBJECT_TYPES dot
 on dot.OBJECT_TYPE_ID = dos.OBJECT_TYPE_ID
 join [CB Schema].DSS_OBJECTS dost
 on dost.OBJECT_ID = dlic.TRANSACTION_ID
 join [CB Schema].DSS_OBJECT_INFO doic
 on doic.SNAPSHOT_ID = dlic.SNAPSHOT_ID
 and doic.OBJECT_ID = dlic.OBJECT_ID
 join [CB Schema].DSS_APP_STATUSES das
 on das.SNAPSHOT_ID = dlic.SNAPSHOT_ID
 join [CB Schema].DSS_OBJECT_INFO doip
 on doip.SNAPSHOT_ID = das.PREVIOUS_SNAPSHOT_ID
 and doip.OBJECT_ID = doic.OBJECT_ID
 and doip.OBJECT_CHECKSUM != doic.OBJECT_CHECKSUM
 join [CB Schema].DSS_LINK_INFO dlip
 on dlip.SNAPSHOT_ID = doip.SNAPSHOT_ID
 and dlip.PREVIOUS_OBJECT_ID = dlic.TRANSACTION_ID
 and dlip.NEXT_OBJECT_ID = dlic.OBJECT_ID
 and dlip.LINK_TYPE_ID = dlic.LINK_TYPE_ID
 where dlic.SNAPSHOT_ID = [Snapshot ID]