Showing posts with label Query to find the workflow overrider address in test instances. Show all posts
Showing posts with label Query to find the workflow overrider address in test instances. Show all posts

Monday, July 13, 2009

Query to find the workflow override address in test instances

SELECT fsc.component_name, fsc.component_status, fsc.startup_mode,
fscpv.parameter_value
FROM fnd_svc_comp_params_tl fscpt,
fnd_svc_comp_param_vals fscpv,
fnd_svc_components fsc
WHERE fscpt.display_name = 'Test Address'
AND fscpt.parameter_id = fscpv.parameter_id
AND fscpv.component_id = fsc.component_id;