SQL to get configuration of Workflow Notification Mailer

--------------------------SQL---------------------------

select a.component_id,
       c.component_class_name,
       b.component_name,
       c.component_status,
       a.component_parameter_id,
       d.display_name,
       a.parameter_value,
       d.description
from fnd_svc_comp_param_vals a,
       fnd_svc_components      b,
       fnd_svc_components_v    c,
       fnd_svc_comp_params_tl d
where a.component_id = b.component_id
   and a.component_id = c.component_id
   and c.component_name like '%Workflow%Notification%Mailer%'
   and d.parameter_id = a.parameter_id
order by component_parameter_id

-EOF-