Nach Filter in ODI Repo suchen mit Ausgabe Mapping und Ordnerstruktur (CONNECT BY LEVEL)

SELECT f.PATH AS PFAD, m.name AS MAPPING, e.txt AS FILTER FROM FZDB_WR_ODI.SNP_MAP_EXPR e
join FZDB_WR_ODI.SNP_MAP_PROP p
on p.I_MAP_PROP = e.I_OWNER_MAP_PROP
join FZDB_WR_ODI.SNP_MAPPING m
on m.I_MAPPING = p.I_OWNER_MAPPING
join (
SELECT LEVEL,
       SYS_CONNECT_BY_PATH(FOLDER_NAME, '\') AS PATH, 
       I_FOLDER
FROM   FZDB_WR_ODI.SNP_FOLDER
START WITH PAR_I_FOLDER IS NULL
CONNECT BY PRIOR I_FOLDER = PAR_I_FOLDER
) f
on f.I_FOLDER = m.I_FOLDER
where upper(e.txt) like '%.BAUREIHE%'
and e.txt like '%''%'
ORDER BY f.PATH, m.name
;