SELECT tbl_DetailCalls_Rated.ratedcallsseq,
	tbl_Transactions.transactionfromdate, tbl_Transactions.transactiontodate,
		tbl_Transactions.description1, 
	tbl_Departments.DeptId, tbl_UserInfo.UserId, 
	tbl_InvoiceSummary.InvoiceStatus, tbl_Transactions.TransactionDate, 
	tbl_Departments.Description, tbl_Transactions.TotalAmount, 
	tbl_DirectoryNumbers.DirectoryNbr, tbl_UserInfo.FirstName, 
	tbl_UserInfo.LastName, tbl_DetailCalls_Rated.DateOfCall, 
	tbl_DetailCalls_Rated.TermCity, tbl_DetailCalls_Rated.TermState, 
	tbl_DetailCalls_Rated.TermAreaExchange, 
	tbl_DetailCalls_Rated.TermPhoneNumber, 
	tbl_DetailCalls_Rated.RatedAmount1, tbl_UserInfo.UserSeq, 
	tbl_InvoiceSummary.InvoiceSummarySeq, 
	tbl_Transactions.CallDuration, 
	tbl_DetailCalls_Rated.RoundedDuration1, 
	tbl_Transactions.CallCount, tbl_UserNumbers.UserNumber, 
	tbl_Branches.DeptId as BranchDeptID, tbl_Departments.DeptSeq, 
	tbl_TransactionCode.DebitCreditPayment, 
	tbl_UserNumbers.UserNumberType, 
	tbl_DetailCalls_Rated.OrigAreaExchange, 
	tbl_DetailCalls_Rated.OrigPhoneNumber, 
	tbl_DetailCalls_Rated.OrigCity, 
	tbl_DetailCalls_Rated.OrigState, tbl_UserInfo.AccountSeq, 
	tbl_CycleHistory.CallToDate, tbl_DetailCalls_Rated.SwitchSeq, 
	tbl_CycleHistory.InvoiceDate, tbl_CycleHistory.InvoiceFromDate, 
	tbl_CycleHistory.InvoiceToDate
FROM ((((((((tbl_CycleHistory tbl_CycleHistory 
INNER JOIN tbl_InvoiceSummary tbl_InvoiceSummary 
	ON tbl_CycleHistory.CycleHistorySeq=tbl_InvoiceSummary.CycleHistorySeq)
LEFT OUTER JOIN tbl_Transactions tbl_Transactions 
	ON tbl_InvoiceSummary.InvoiceSummarySeq=tbl_Transactions.InvoiceSummarySeq) 
LEFT OUTER JOIN tbl_TransactionCode tbl_TransactionCode 
	ON tbl_Transactions.TranCodeSeq=tbl_TransactionCode.TranCodeSeq) 
LEFT OUTER JOIN tbl_DetailCalls_Rated tbl_DetailCalls_Rated 
	ON tbl_Transactions.TransactionSeq=tbl_DetailCalls_Rated.TransactionSeq) 
INNER JOIN tbl_UserInfo tbl_UserInfo 
	ON tbl_Transactions.UserSeq=tbl_UserInfo.UserSeq) 
LEFT OUTER JOIN tbl_Departments tbl_Departments 
	ON tbl_UserInfo.DeptSeq=tbl_Departments.DeptSeq) 
LEFT OUTER JOIN tbl_DirectoryNumbers tbl_DirectoryNumbers 
	ON tbl_UserInfo.DirectoryNbrSeq=tbl_DirectoryNumbers.DirectoryNbrSeq) 
INNER JOIN tbl_Departments tbl_Branches 
	ON tbl_Departments.ParentSeq=tbl_Branches.DeptSeq) 
LEFT OUTER JOIN tbl_UserNumbers tbl_UserNumbers 
	ON tbl_DetailCalls_Rated.UserNumberSeq=tbl_UserNumbers.UserNumberSeq			
WHERE  
	tbl_InvoiceSummary.InvoiceStatus='L' 
	AND tbl_UserInfo.AccountSeq=1
	AND left(tbl_Departments.DEPTID,6)='123456'
ORDER BY tbl_Branches.DeptId, tbl_Departments.DeptId, 
	tbl_UserInfo.UserId, tbl_UserNumbers.UserNumber, 
	tbl_DetailCalls_Rated.DateOfCall