 		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>
<!---
	now assemble part_ids in the order we want to see them
---->

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

 START WITH derived_from_cat_item=#one.collection_object_id#
 CONNECT BY PRIOR collection_object_id = SAMPLED_FROM_OBJ_ID
</cfquery>
<cfdump var=#orderedparts#>



<cfquery name="ploan" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
	SELECT
		loan.loan_number,
