 			upper(username)='#ucase(session.username)#'
 	</cfquery>
 
+	<cfquery name="collObj" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
+		update cf_temp_collector set COLLECTION_OBJECT_ID = (
+			select
+				cataloged_item.collection_object_id
+			from
+				cataloged_item,
+				collection
+			WHERE
+				cataloged_item.collection_id = collection.collection_id and
+				collection.guid_prefix || ':' || cataloged_item.cat_num = cf_temp_collector.guid
+		) where
+			status is null and
+			guid is not null and
+			upper(username)='#ucase(session.username)#'
+	</cfquery>
 
 	<cfquery name="collObj" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
 		update cf_temp_collector set COLLECTION_OBJECT_ID = (

	</cfquery>


	<cfquery name="ctcitation_TYPE_STATUS" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
		update
			cf_temp_collector

				display_value = cf_temp_collector.other_id_number
		) where
			status is null and
			collection_object_id is null and
			other_id_type != 'catalog number' and
			upper(username)='#ucase(session.username)#'
	</cfquery>
