 		project,
 		permit_trans,
 		permit,
-		collection">
+		collection,
+		loan_item">
 	<cfset sql = "where
 		loan.transaction_id = trans.transaction_id AND
+		trans.transaction_id=loan_item.transaction_id (+) and
 		trans.collection_id = collection.collection_id AND
 		trans.transaction_id = project_trans.transaction_id (+) AND
 		project_trans.project_id = project.project_id (+) AND

		trans_date,
		project_name,
		project.project_id pid,
		collection.guid_prefix">
	<cfset frm = " from
		loan,
		trans,

						<td colspan="3">
							<strong>#guid_prefix# #loan_number#</strong>
							<cfif c.c gt 0>(#c.c# items)</cfif>
							<br>#numberItems#
						</td>
					</tr>
					<tr>
