Index: openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-views-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-views-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-views-create.sql 21 Oct 2001 18:16:34 -0000 1.2 +++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-views-create.sql 15 Feb 2002 14:55:19 -0000 1.3 @@ -1,6 +1,6 @@ -- $Id$ -create or replace view valid_uninstalled_binding as +create or replace view valid_uninstalled_bindings as select c.contract_id, c.contract_name, i.impl_id, i.impl_name from acs_sc_contracts c, acs_sc_impls i where c.contract_name = i.impl_contract_name @@ -19,7 +19,7 @@ -create or replace view invalid_uninstalled_binding as +create or replace view invalid_uninstalled_bindings as select c.contract_id, c.contract_name, i.impl_id, i.impl_name from acs_sc_contracts c, acs_sc_impls i where c.contract_name = i.impl_contract_name @@ -37,7 +37,7 @@ and a.impl_operation_name = o.operation_name)); -create or replace view orphan_implementation as +create or replace view orphan_implementations as select i.impl_id, i.impl_name, i.impl_contract_name from acs_sc_impls i where not exists (select 1