Index: openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql,v
diff -u -N -r1.1.10.1 -r1.1.10.2
--- openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql	3 Dec 2003 22:19:05 -0000	1.1.10.1
+++ openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql	4 Dec 2003 09:23:27 -0000	1.1.10.2
@@ -12,14 +12,11 @@
 
 <fullquery name="acs_sc_get_alias.get_alias">
 <querytext>
-	select 
-	    element_name, 
-	    acs_sc_msg_type.get_name(element_msg_type_id) as element_msg_type_name,
-	    element_msg_type_isset_p,
-	    element_pos
-	from acs_sc_msg_type_elements
-	where msg_type_id = :operation_outputtype_id
-	order by element_pos asc
+   select impl_alias, impl_pl 	 
+         from   acs_sc_impl_aliases 	 
+         where  impl_contract_name = :contract 	 
+         and    impl_operation_name = :operation 	 
+         and    impl_name = :impl
 </querytext>
 </fullquery>