Saturday, August 13, 2011

How to get confirmed is there any conflicts in Workflow Mailer accounts of TEST/DEV/PROD


Query to get confirmed is there any conflicts in Workflow Mailer accounts of TEST/DEV/PROD

set pagesize 100
set linesize 132
set feedback off
set verify off

col value format a35
col component_name format a30

select c.component_id, c.component_name, p.parameter_id, p.parameter_name, v.parameter_value value
from fnd_svc_comp_param_vals_v v, fnd_svc_comp_params_b p, fnd_svc_components c
where c.component_type = 'WF_MAILER'
and v.component_id = c.component_id
and v.parameter_id = p.parameter_id
and p.parameter_name in ( 'INBOUND_SERVER','ACCOUNT', 'REPLYTO')
order by c.component_id, c.component_name,p.parameter_name;


UR's Key Run ;-) 

No comments:

Post a Comment