Total Pageviews

Saturday, March 9, 2013


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';



No comments:

Post a Comment