Get Connector URL Data

SELECT
	/* SR Number */
	orchestration_application_id
  , service_name
  , protocol || '://' || host || ':' || port || '/' || context_root
FROM
	fusion.doo_web_service_details   web
  , fusion.ask_deployed_applications app
  , fusion.ask_modules               module
WHERE
	module.module_short_name          like '%' || web.service_name
	AND app.name                      like '%' || web.service_name
	AND module.enterprise_application_id = app.enterprise_application_id
ORDER BY
	service_name
;