Informatica PC Repository Query - Search Expressions

In below query, you can modify filters as needed to search the expressions in a mapping/project.
(tested on Informatica 9.5 repository setup on Oracle)

SELECT
a.subject_area
,a.mapping_name
,d.instance_name as Expression_Name
,c.field_name
,c.expression as Expression_Value
FROM
REP_ALL_MAPPINGS a
INNER JOIN (select distinct mapping_id, widget_id, instance_id, instance_name from OPB_SWIDGET_INST) b
ON
a.mapping_id = b.mapping_id
INNER JOIN REP_WIDGET_FIELD c
ON
b.widget_id = c.widget_id
INNER JOIN REP_WIDGET_INST d
ON
  b.widget_id = d.widget_id
WHERE
a.subject_area = 'f_XXXXX'
AND a.mapping_name = 'm_XXXXX'
AND d.widget_type = 5
AND c.expression like '%TRIM%'
--AND b.instance_name in ('exp_XXXXX')
--AND c.field_name in ('exp_field_XXXXX')
order by a.subject_area, a.mapping_name, d.instance_name