Index: openacs-4/packages/lorsm/www/delivery/view/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/delivery/view/index.xql,v
diff -u -r1.1.2.1 -r1.1.2.1.2.1
--- openacs-4/packages/lorsm/www/delivery/view/index.xql	30 May 2006 18:05:04 -0000	1.1.2.1
+++ openacs-4/packages/lorsm/www/delivery/view/index.xql	20 Dec 2006 12:25:44 -0000	1.1.2.1.2.1
@@ -7,11 +7,21 @@
 <!-- @cvs-id $Id$ -->
 
 <queryset>
-  <fullquery name="manifest_info">
+
+<fullquery name="manifest_info">
     <querytext>
       select fs_package_id, folder_id
       from ims_cp_manifests
       where man_id = :man_id
     </querytext>
-  </fullquery>
+</fullquery>
+
+<fullquery name="check_file_to_imsitem">
+      <querytext>
+	select i.ims_item_id as imsitem_id 
+	from ims_cp_items_to_resources i, ims_cp_files f 
+	where f.file_id=:file_id and i.res_id=f.res_id;
+      </querytext>
+</fullquery>
+
 </queryset>
\ No newline at end of file