Index: openacs-4/packages/lorsm/www/tracking-rte/drill-student-2-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/tracking-rte/Attic/drill-student-2-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/lorsm/www/tracking-rte/drill-student-2-oracle.xql	5 Dec 2006 10:53:19 -0000	1.1.2.1
@@ -0,0 +1,35 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="organizations">
+  <querytext>
+       	select org.org_id, org.org_title as org_title, org.hasmetadata,
+        	(select level
+	        from acs_objects
+	        connect by prior object_id = context_id
+	        start with object_id = org.org_id) as indent
+	from ims_cp_organizations org
+	where man_id = :man_id
+	order by org_id
+  </querytext>
+</fullquery>
+
+<fullquery name="organization_item">
+  <querytext>
+	select i.ims_item_id as object_id,
+		((select level
+	                from acs_objects connect by prior object_id = context_id
+        	        start with object_id = i.org_id) - :indent
+	                ) * 2 as indent,
+	                i.ims_item_id, i.item_title as item_title,
+	                i.hasmetadata, i.ims_item_id as identifierref,
+		        i.type, i.org_id, m.fs_package_id,
+		        m.folder_id, m.course_name
+        from ims_cp_items i, ims_cp_manifests m
+        where i.org_id = :org_id and m.man_id = :man_id
+        order by indent, ims_item_id;
+  </querytext>
+</fullquery>
+
+</queryset>
\ No newline at end of file