Informatica PC Repository Query - Get Joiner Type

Below query returns joiner type of all joiner transformations used in a project folder.
(tested on Informatica 9.5 repository setup on Oracle)

select distinct
a.mapping_name
,b.instance_name as Joiner_Name
,case c.ATTR_VALUE
 when '1' then 'Normal Join'
 when '2' then 'Master Outer Join'
 when '3' then 'Detail Outer Join'
 when '4' then 'Full Outer Join'
 else c.attr_value
end as Join_Type
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 OPB_WIDGET_ATTR c
ON
  b.widget_id = c.WIDGET_ID
INNER JOIN OPB_WIDGET d
ON
  b.widget_id = d.widget_id
WHERE
 a.SUBJECT_AREA = 'f_XXXXX'
 AND c.WIDGET_TYPE = 12
 AND c.ATTR_ID = 4
 AND d.IS_VISIBLE = 1
order by a.mapping_name, b.instance_name;