oracle8.1.6 select package_id from apm_packages where package_key = 'acs-developer-support' and rownum=1 select acs_object.name(:object_id) from dual select site_node.url(node_id) from site_nodes s, apm_packages p where p.package_id = s.object_id and p.package_key ='acs-developer-support' and rownum = 1 select u.user_id as user_id_from_db, acs_object.name(user_id) as name, p.email from users u, parties p where u.user_id = p.party_id