Dimension lookup / update properties for all transformations

Sometimes it might be useful to get different information about kettle transformations in a list format. Here is an example selecting update type of step Dimension lookup/update:

select
   t.NAME as TRANSFORMATION_NAME
,  s.NAME as STEP_NAME
,  fn.FIELD_NAME
,  tab.TABLE_NAME
,  fu.FIELD_UPDATE
from
(
   select
      ID_STEP
   ,  NR
   ,  CAST(VALUE_STR as varchar) as FIELD_NAME
   from
      R_STEP_ATTRIBUTE
   where
      CODE = 'field_lookup'
) fn
inner join
(
   select
      ID_STEP,
      NR,
      CAST(VALUE_STR as varchar) as FIELD_UPDATE
   from
      R_STEP_ATTRIBUTE
   where
      CODE = 'field_update'
) fu
on
   fn.ID_STEP = fu.ID_STEP
and
   fn.NR = fu.NR
inner join
   R_STEP s
on
   s.ID_STEP = fn.ID_STEP
inner join
(
   select
      ID_STEP
   from
      R_STEP_ATTRIBUTE
   where
      CODE = 'update'
   and
      CAST(VALUE_STR as varchar)='Y'
) u
on u.ID_STEP = s.ID_STEP
inner join
(
   select
      ID_STEP
   ,  CAST(VALUE_STR as varchar) as TABLE_NAME
   from
      R_STEP_ATTRIBUTE
   where
      CODE = 'table'
) tab
on
   tab.ID_STEP = s.ID_STEP
inner join
   R_TRANSFORMATION t
on
   t.ID_TRANSFORMATION = s.ID_TRANSFORMATION
order by
   TRANSFORMATION_NAME
,  STEP_NAME
,  FIELD_NAME