select r.ownerId, r.ownerType, r.requestId, r.assignedContractNbr from tbl_TPM_Requests r where r.ownerId = and r.ownerType = and r.status = 'APPROVED' and nullif( r.sourceRequestId, 0 ) is null and ( select count(*) from tbl_TPM_requests rr where rr.ownerId= r.ownerId and rr.ownerType = r.ownerType and rr.sourceRequestId = r.requestId ) = 1 select sourceRequestId, count(*) branches from qmd_contractChain group by sourceRequestId having count(*) > 1 displayContractChain(qmd_contractChain,"Bad Contract Chain #_baseRequestId#"); select distinct #_sanityCheckColumns# from qmd_contractChain displayContractChain(qmd_contractChain,"Multiple Contracts #_baserequestId#"); select distinct assignedContractNbr from qmd_contractChain displayContractChain(qmd_contractChain,"Multiple Assigned Contract Nbrs #_baseRequestId#"); displayContractChain(qmd_contractChain,"Legitimate #_baseRequestId#", true); select count( distinct assignedContractNbr ) assignedContractNbr, count( distinct requestType ) requestType, count( distinct volumeGenerator ) volumeGenerator, count( distinct salesImpact ) salesImpact, count( distinct payableTo ) payableTo, count( distinct partnerId ) partnerId, count( distinct partnerType ) partnerType from qmd_chain select * from qmd_chain order by requestId desc

select count(*) itemCount from tbl_TPM_RequestProducts where requestId =

#arguments.label#

Status	Contract Nbr	Partner	Type	Payable To	Total Trade	Items	Term	T Start	T End	D Override	D Start	D End	Vol. Gen	Sls. Imp	rid	srid	cid	Claims	CntrctRefs#	Delete
#qmd_request.status#		#htmleditformat( qmd_request.primaryPartnerName )#	#htmleditformat( qmd_request.requestType )#	#qmd_request.payableTo#	#lscurrencyformat( totalEstimatedTrade )#	#lsnumberformat( qmd_requestProductSummary.itemCount )#	#termUnit##termLength#	#lsdateformat( qmd_request.termStart, "MM/DD/YYYY" )#	#lsdateformat( qmd_request.termEnd, "MM/DD/YYYY" )#	#deliveryTermOverride#	#lsdateformat( qmd_request.startDate, "MM/DD/YYYY" )#	#lsdateformat( qmd_request.endDate, "MM/DD/YYYY" )#	#volumeGenerator#	#salesImpact#	#qmd_request.requestId#			select count(*) claimCount from tbl_TPM_ClaimContracts where ownerId = and ownerType = and requestId = #qmd_claimSummary.claimCount#	select count(*) refCount from tbl_TPM_ContractReferences where ownerId = and ownerType = and requestId = #qmd_contractRefs.refCount#

select r.requestId, r.assignedContractNbr, r.sourceRequestId, r.status from tbl_TPM_Requests r where r.requestId not in ( ) and r.assignedContractNbr = order by requestId desc