oracle8.1.6 select s.node_id, site_node.url(node_id) as node_url, instance_name from site_nodes s, apm_packages p where s.object_id = p.package_id and p.package_key = 'acs-subsite'