 		cataloged_item related_cat_item,
 		collection related_coll,
 		specimen_part,
-		coll_object part_object
+		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

		concatencumbrances(cataloged_item.collection_object_id) concatenatedEncumbrances,
		concatEncumbranceDetails(cataloged_item.collection_object_id) encumbranceDetail,
		locality.locality_remarks,
		verbatim_locality	
	FROM 
		cataloged_item,
		collection,

		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
	">

<cfquery name="detail" datasource = "#Application.web_user#">
