Where Is The Workflow Notification Mailer Smtp And Imap Hostname Stored In DB

Where Is The Workflow Notification Mailer Smtp And Imap Hostname Stored In DB

#This query tells you where the Workflow notification mailer is running:

select target_node from apps.fnd_concurrent_queues where concurrent_queue_name like 'WFMLRSVC%';

#This query tells you the IMAP inbound server name, SMTP outbound server name, value of reply to email address:

SELECT b.component_name, c.parameter_name, a.parameter_value FROM apps.fnd_svc_comp_param_vals a, apps.fnd_svc_components b, apps.fnd_svc_comp_params_b c WHERE b.component_id = a.component_id AND b.component_type = c.component_type AND c.parameter_id = a.parameter_id AND c.encrypted_flag = 'N' AND b.component_name like '%Mailer%' AND c.parameter_name in ('INBOUND_SERVER','OUTBOUND_SERVER', 'REPLYTO') ORDER BY c.parameter_name;