Query to find Workflow Inbound and Outbound Server Details.

SELECT fscpv.*

              FROM fnd_svc_comp_params_b   fscpb

                  ,fnd_svc_comp_param_vals fscpv

             WHERE fscpv.parameter_id = fscpb.parameter_id

               AND fscpb.component_type = 'WF_MAILER'

               AND fscpb.parameter_name = 'OUTBOUND_SERVER'

               AND EXISTS ( SELECT 1

                              FROM fnd_svc_comp_params_b   fscpb

                                  ,fnd_svc_comp_param_vals fscpv

                             WHERE UPPER(fscpv.parameter_value) = 'SMTP'

                               AND fscpv.parameter_id   = fscpb.parameter_id

                               AND fscpb.component_type = 'WF_MAILER'

                               AND fscpb.parameter_name = 'OUTBOUND_PROTOCOL' );