  START WITH derived_from_cat_item=#one.collection_object_id#
  CONNECT BY PRIOR collection_object_id = SAMPLED_FROM_OBJ_ID
 </cfquery>
-
-
-
-
-<cfset opidlist="">
-<!---- first non-samples --->
-
-<cfquery name="mPart" dbtype="query">
-	select part_id from parts where sampled_from_obj_id is null order by part_name
-</cfquery>
-<cfloop query="mPart">
-	<cfset opidlist=listappend(opidlist,part_id)>
-	<!---- children? ---->
-	<cfquery name="c" dbtype="query">
-		select part_id from parts where sampled_from_obj_id = #part_id#
-	</cfquery>
-
-</cfloop>
-
-
-<cfdump var=#mPart#>
+<cfdump var=#orderedparts#>
+
+
+
 <cfquery name="ploan" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
 	SELECT
 		loan.loan_number,

		oc.parent_container_id=pc.container_id (+) and
		specimen_part.derived_from_cat_item=#one.collection_object_id#
</cfquery>
<cfquery name="parts" dbtype="query">
	select
		part_id,

	order by
		part_name
</cfquery>
---->
<cfquery name="orderedparts" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
 SELECT
 collection_object_id part_id,
