Index: openacs-4/packages/cms/www/modules/items/publish-status-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/publish-status-oracle.xql,v diff -u -N -r1.2 -r1.2.14.1 --- openacs-4/packages/cms/www/modules/items/publish-status-oracle.xql 27 Aug 2001 03:59:17 -0000 1.2 +++ openacs-4/packages/cms/www/modules/items/publish-status-oracle.xql 31 May 2005 04:59:44 -0000 1.2.14.1 @@ -7,11 +7,7 @@ select - NVL(initcap(publish_status), 'Production') publish_status, - NVL(to_char(start_when, 'MM/DD/YY HH:MI AM'), 'Immediate') start_when, - NVL(to_char(end_when, 'MM/DD/YY HH:MI AM'), 'Indefinite') end_when, - content_item.is_publishable(:item_id) is_publishable, - live_revision + publish_status, start_when, end_when from cr_items i, cr_release_periods r where @@ -22,21 +18,6 @@ - - - - select - content_item.is_publishable( item_id ) is_publishable, - live_revision - from - cr_items - where - item_id = :item_id - - - - -