SQL Queries - CAST Knowledge Base - Queries on PeopleSoft technology - Module size for ADDED objects

select T4.object_type,t.typdsc, count(1)
from keys T1 join setroot T2 on (T2.idset = T1.idkey) join keys T3 on (T3.idkey = T2.idroot)
join ctt_object_applications T4 on (T4.application_id = T2.idroot)
join typ t 
on t.idtyp = object_type
where T1.objtyp = 20000 and T1.keynam = 'REPOSITORY_ADDED'
and T3.keynam not like '%PeopleSoft(Objects list)' and T4.properties = 0
group by T4.object_type ,t.typdsc
union all
select T4.object_type,t.typdsc, count(1)
from keys T1 join setroot T2 on (T2.idset = T1.idkey)join keys T3 on (T3.idkey = T2.idroot)
join ctt_object_applications T4 on (T4.application_id = T2.idroot)
join typ t 
on t.idtyp = object_type
where T1.objtyp = 20000 and T1.keynam = 'REPOSITORY_ADDED'
and T3.keynam like '%PeopleSoft(Objects list)' and T4.properties = 0 and T4.object_type in (1600673,1600999)
group by T4.object_type ,t.typdsc order by 3 desc