SQL Queries - CAST Management Base - How to check for analysis units created more than once for different paths

Purpose of Query

This query when ran on the CAST management base will provide the list of analysis units created more than once having different project file paths.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
CSS4(tick)
CSS3(tick)
Query for JAVA (CSS, Oracle, SQL Server)
How to check for overlapping analysis units (here it is JAVA case)
with DuplicateNames as
(
select mau.Object_Name
  from CMS_PORTF_Module cpm
  join CMS_PORTF_ObjectFilter cpof
    on cpof.Module_Id = cpm.Object_Id
  join MAINT_AnalysisUnits mau
    on mau.Object_Name = cpm.Object_Name
 group by mau.Object_Name
 having count(1) > 1
)
select *
  from DuplicateNames dn
  join MAINT_AnalysisUnits mau
    on mau.Object_Name = dn.Object_Name;
Query result example
'DataGridFilterLibrary',95656,'DataGridFilterLibrary',69617,'.NET',74709,,1
'DataGridFilterLibrary',95729,'DataGridFilterLibrary',69617,'.NET',74709,,1
'DataGridFilterLibrary',95749,'DataGridFilterLibrary',69617,'.NET',74709,,1
'EQD',95298,'EQD',69617,'.NET',74709,,1
'EQD',95681,'EQD',69617,'.NET',74709,,1

Query result interpretation
 There are 2 analysis units found that are created more than once. 
Notes/comments

Ticket # 33484