Index: openacs-4/packages/acs-service-contract/www/contract-display-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/contract-display-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/contract-display-oracle.xql	22 Apr 2003 12:52:07 -0000	1.1.2.1
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="valid_installed_binding">      
+      <querytext>
+        select 
+            b.contract_id,
+            b.impl_id,
+            acs_sc_impl.get_name(b.impl_id) as impl_name,
+            impl.impl_owner_name
+        from
+            acs_sc_bindings b, 
+            acs_sc_impls impl
+        where
+            b.contract_id = :id
+        and impl.impl_id = b.impl_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/acs-service-contract/www/contract-display-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/contract-display-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/contract-display-postgresql.xql	22 Apr 2003 12:52:07 -0000	1.1.2.1
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="valid_installed_binding">      
+      <querytext>
+        select 
+            b.contract_id,
+            b.impl_id,
+            acs_sc_impl__get_name(b.impl_id) as impl_name,
+            impl.impl_owner_name
+        from
+            acs_sc_bindings b, 
+            acs_sc_impls impl
+        where
+            b.contract_id = :id
+        and impl.impl_id = b.impl_id
+      </querytext>
+</fullquery>
+ 
+</queryset>
+
Index: openacs-4/packages/acs-service-contract/www/contract-display.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/contract-display.adp,v
diff -u -N -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-service-contract/www/contract-display.adp	16 Oct 2002 15:06:23 -0000	1.1.2.1
+++ openacs-4/packages/acs-service-contract/www/contract-display.adp	22 Apr 2003 12:52:07 -0000	1.1.2.2
@@ -13,4 +13,21 @@
             </group>
           </ul>
       </multiple>
-    </ul>
\ No newline at end of file
+    </ul>
+
+    <h3>Valid Installed Bindings</h3>
+
+    <ul>
+      <if @valid_installed_binding:rowcount@ eq 0>
+        <li><i>None</i></li>
+      </if>
+      <else>
+        <multiple name=valid_installed_binding>
+          <li>@valid_installed_binding.impl_id@
+          @valid_installed_binding.impl_name@
+          (@valid_installed_binding.impl_owner_name@)
+          [<a href="binding-uninstall?contract_id=@valid_installed_binding.contract_id@&impl_id=@valid_installed_binding.impl_id@">Uninstall</a>]</li>
+        </multiple>
+      </else>
+    </ul>
+
Index: openacs-4/packages/acs-service-contract/www/contract-display.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/contract-display.tcl,v
diff -u -N -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-service-contract/www/contract-display.tcl	16 Oct 2002 15:06:23 -0000	1.1.2.1
+++ openacs-4/packages/acs-service-contract/www/contract-display.tcl	22 Apr 2003 12:52:07 -0000	1.1.2.2
@@ -17,3 +17,6 @@
     and e.msg_type_id = t.msg_type_id
     and et.msg_type_id = e.element_msg_type_id
     order by o.contract_name, o.operation_name, t.msg_type_name, e.element_pos }
+
+
+db_multirow valid_installed_binding valid_installed_binding ""
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 -N -r1.1 -r1.1.4.1
--- 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	22 Apr 2003 12:52:07 -0000	1.1.4.1
@@ -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>
 
Index: openacs-4/packages/acs-service-contract/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index-postgresql.xql,v
diff -u -N -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-service-contract/www/index-postgresql.xql	31 Jan 2002 03:04:32 -0000	1.1
+++ openacs-4/packages/acs-service-contract/www/index-postgresql.xql	22 Apr 2003 12:52:07 -0000	1.1.4.1
@@ -5,13 +5,17 @@
 
 <fullquery name="valid_installed_binding">      
       <querytext>
-        select 
-            contract_id,
-            impl_id,
+         select 
+            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>
  
Index: openacs-4/packages/acs-service-contract/www/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index.adp,v
diff -u -N -r1.3.2.1 -r1.3.2.2
--- openacs-4/packages/acs-service-contract/www/index.adp	16 Oct 2002 15:01:01 -0000	1.3.2.1
+++ openacs-4/packages/acs-service-contract/www/index.adp	22 Apr 2003 12:52:07 -0000	1.3.2.2
@@ -24,6 +24,7 @@
 @valid_installed_binding.contract_name@,
 @valid_installed_binding.impl_id@
 @valid_installed_binding.impl_name@
+(@valid_installed_binding.impl_owner_name@)
 [<a href="binding-uninstall?contract_id=@valid_installed_binding.contract_id@&impl_id=@valid_installed_binding.impl_id@">Uninstall</a>]</li>
 </multiple>
 </else>
@@ -76,4 +77,4 @@
 @orphan_implementation.impl_contract_name@
 </multiple>
 </else>
-</ul>
\ No newline at end of file
+</ul>