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	17 May 2003 09:56:59 -0000	1.2
@@ -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>