select distinct itemCode mfr_item_code, itemDescription, 0 skuId, '' sku, '' skuDesc from tbl_TPM_ProofOfDelivery epod with (nolock) where skuId is null and ownerId = 288 and ownerType = 'MFR' and exists ( select * from tbl_TPM_Claims c where c.claimId = epod.claimId and c.ownerId = epod.ownerId and c.ownerType = epod.ownerType ) and nullif( itemCode, '' ) is not null select skuId, sku, skuDesc from tbl_PRD_Skus with (nolock) where ownerId = and fsl_tablecode = and sku like select skuId, sku, skuDesc from tbl_PRD_Skus with (nolock) where ownerId = and fsl_tablecode = and sku like select * from qmd_skusToFind where skuId > 0

#lsnumberformat( qmd_matchedSkus.recordCount )#

epod item code	epod description	sku	description	apply?
#htmleditformat( mfr_item_code )#	#htmleditformat( itemDescription )#	#replace( sku, mfr_item_code, '#mfr_item_code#', "ALL" )#	#htmleditformat( skuDesc )#

select distinct itemCode mfr_item_code, itemDescription from tbl_TPM_ProofOfDelivery epod with (nolock) where skuId is null and ownerId = 288 and ownerType = 'MFR' and exists ( select * from tbl_TPM_Claims c where c.claimId = epod.claimId and c.ownerId = epod.ownerId and c.ownerType = epod.ownerType ) and nullif( itemCode, '' ) is not null