SQL – Find BusinessObject with certain Property

Find all BusinessObjects in database which has certain property:

SELECT cla.pname
,attr.[pname]
,[pinitial_value]
,[pupper_bound]
,[plower_bound]
,[pdbname]
,[rdefining_classu]
,[rdefining_classc]
,[plength]
,[pnull_offset]
,[pempty_offset]
,[rreferenced_classu]
,[rreferenced_classc]
,[ptype]
,[pptype]
,[papid]
,[pmax_string_length]
,[pnumber_of_columns]
,[phas_table]
,[pnulls_allowed]
,[punique]
FROM [TCDatabaseName].[dbo].[PPOM_ATTRIBUTE] attr
inner join [TCDatabaseName].[dbo].[PPOM_CLASS] cla on cla.puid = attr.rdefining_classu
WHERE attr.pname ='xyz4Property'