Query to get the Details of the WF Service Components

Query to get the Details of the WF Service Components

1. Go To responsibility Workflow Administrator

2. Navigation 

           Workflow Administrator --> Oracle Application Manager --> Workflow Manager --> Service Components --> Edit

   

SELECT para_values.parameter_value

  FROM fnd_svc_components fsc

     , fnd_svc_comp_params_b para

     , fnd_svc_comp_param_vals para_values

WHERE para.parameter_name = 'REPLYTO'

   AND para.parameter_id = para_values.parameter_id

  AND fsc.component_id = para_values.component_id

   AND fsc.component_name = 'Workflow Notification Mailer';