Index: openacs-4/packages/acs-service-contract/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-service-contract/www/index-oracle.xql	31 Jan 2002 03:04:32 -0000	1.1
+++ openacs-4/packages/acs-service-contract/www/index-oracle.xql	17 May 2003 09:56:59 -0000	1.2
@@ -6,12 +6,16 @@
 <fullquery name="valid_installed_binding">      
       <querytext>
         select 
-            contract_id,
-            impl_id,
+            b.contract_id,
+            b.impl_id,
             acs_sc_contract.get_name(contract_id) as contract_name,
-            acs_sc_impl.get_name(impl_id) as impl_name
+            acs_sc_impl.get_name(b.impl_id) as impl_name,
+            impl.impl_owner_name
         from
-            acs_sc_bindings
+            acs_sc_bindings b, 
+            acs_sc_impls impl
+        where
+            impl.impl_id = b.impl_id
       </querytext>
 </fullquery>