 		related_cat_item.collection_id = related_coll.collection_id (+) and
 		cataloged_item.collection_object_id = specimen_part.derived_from_cat_item (+) and
 		specimen_part.collection_object_id = part_object.collection_object_id (+) and
-		cataloged_item.collection_object_id = #collection_object_id# AND
-		parts_coll_object_remark.collection_object_id = s_part.collection_object_id AND
-		parts_coll_object.collection_object_id = s_part.collection_object_id AND
-		s_part.derived_from_cat_item = cataloged_item.collection_object_id
+	cataloged_item.collection_object_id = #collection_object_id#
 	">
 
 <cfquery name="detail" datasource = "#Application.web_user#">

		cataloged_item related_cat_item,
		collection related_coll,
		specimen_part,
		coll_object part_object,
		coll_object_remark parts_coll_object_remark,
	 	coll_object parts_coll_object,
		specimen_part s_part
	WHERE 
		cataloged_item.collection_id = collection.collection_id AND
		cataloged_item.collection_object_id = identification.collection_object_id AND

		is_tissue,
		part_disposition,
		part_condition,
		lot_count
	order by
		part_name
</cfquery>
