06 January 2015

SQL to fetch the SMTP server details from Workflow Setup

SQL to fetch the SMTP server details from Workflow Setup

select fscpv.parameter_value smtp_server_name,fscpt.display_name
from   fnd_svc_comp_params_tl fscpt
,      fnd_svc_comp_param_vals fscpv
,      fnd_svc_components fsc
where  fscpt.parameter_id = fscpv.parameter_id
and    fscpv.component_id = fsc.component_id
and    fscpt.display_name = 'Outbound Server Name'
and    fsc.component_name = 'Workflow Notification Mailer'

2 comments:

oracle fusion hcm online coaching institutes said...

good blog nice information about oracle fusion online training
This listing is actually very beneficial.
Thank you for sharing the ones maximum crucial weblog submission internet websites.
For more about information please check the internet site
on line training

oracle financials Training said...

Hi,
I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article. Oracle EBS training
Thank you.