Monday, July 13, 2009

Query to find the workflow overrider address in test instances

SELECT fscpv.parameter_value override_email_address
FROM fnd_svc_comp_params_tl fscpt, fnd_svc_comp_param_vals fscpv
WHERE 1 = 1
AND fscpt.display_name = 'Test Address'
AND fscpt.parameter_id = fscpv.parameter_id;

0 comments: