USE [RADIOLOGY]
GO
/****** Object:  StoredProcedure [dbo].[spRadio_PrintCreditMemo]    Script Date: 6/6/2024 4:53:47 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[spRadio_PrintCreditMemo]
@strRequestNum as varchar(10),
@strRevenueID as varchar(2)

AS

	select X.HospNum, X.IdNUm, x.RequestNum, M.XrayNum,
		M.LastName + ', ' + M.Firstname + ' ' + M.MiddleName as PatientName,
		X.RefNum, X.RevenueID, X.ItemID as Code, 
		case isnull(X.RevenueID,'')
			when @strRevenueID then E.Description
			else I.ItemName
		end as Exam, X.Amount, X.TransDate, 
		X.Receptionist as UserName
	from RADIOLOGY..tbRadiologyRequests X
		Left outer join PATIENT_DATA..tbMaster M
			On X.HospNum = M.HospNum
		left outer join INVENTORY..tbInvMaster I
			On X.ItemID = I.ItemID
		left outer join tbBillExamListing E
			On X.ItemID = E.ItemID and X.RevenueID = @strRevenueID
	where requestNum = @strRequestNum and X.RevenueID = @strRevenueID