Preview Mode

Apply Mode

 select operatorId from tbl_OPR_CLientOperators where companyName = and ownerId = 288 and fsltablecode = 'MFR' and fsl_choId > 0 select operatorId, cleanItemCode, count( distinct skuId ) skuCount from qmd_mapping where cleanItemCode <> '' group by operatorId, cleanItemCode having count( distinct skuId ) > 1 select * from qmd_badItemCodes where operatorId = and cleanItemCode = select operatorId, cleanItemCode, itemDescription, skuId, badItemCode from qmd_Mapping where badItemCode = 'Y' select skuId from tbl_PRD_Skus with (nolock) where ownerId = 288 and fsl_tablecode = 'MFR' and sku = '99999' select operatorId, GTIN, cleanItemCode2 cleanItemCode, skuId, sku, skuDesc, claimId, claimId2, itemDescription, badItemCode from qmd_mapping where skuId > 0 and operatorId > 0 select operatorId, cleanItemCode2 cleanItemCode, claimId, claimId2, itemDescription, itemNbr, badItemCode from qmd_mapping where operatorId > 0 and itemNbr = 'Remove' and 1 = 2 order by operatorId select distinct epod.claimId from tbl_TPM_ProofOfDelivery epod with (nolock) inner join tbl_TPM_Claims c with (nolock) on c.ownerId = epod.ownerId and c.ownerType = epod.ownerType and c.claimId = epod.claimId where epod.ownerId = 288 and epod.ownerType = 'MFR' and coalesce( epod.itemCode, '' ) = and epod.itemDescription = and c.partnerType = 'OPR' and c.partnerId = and coalesce( epod.skuId, 0 ) != update tbl_TPM_ProofOfDelivery set skuId = where ownerId = 288 and ownerType = 'MFR' and coalesce( itemCode, '' ) = and itemDescription = and claimId in ( ) and coalesce( skuId, 0 ) != select distinct epod.claimId from tbl_TPM_ProofOfDelivery epod with (nolock) inner join tbl_TPM_Claims c with (nolock) on c.ownerId = epod.ownerId and c.ownerType = epod.ownerType and c.claimId = epod.claimId where epod.ownerId = 288 and epod.ownerType = 'MFR' and coalesce( epod.itemCode, '' ) = and c.partnerType = 'OPR' and c.partnerId = and coalesce( epod.skuId, 0 ) != update tbl_TPM_ProofOfDelivery set skuId = where ownerId = 288 and ownerType = 'MFR' and itemDescription = and claimId in ( ) and coalesce( skuId, 0 ) != select distinct epod.claimId from tbl_TPM_ProofOfDelivery epod with (nolock) inner join tbl_TPM_Claims c with (nolock) on c.ownerId = epod.ownerId and c.ownerType = epod.ownerType and c.claimId = epod.claimId where epod.ownerId = 288 and epod.ownerType = 'MFR' and coalesce( epod.itemCode, '' ) = and epod.itemDescription = and epod.skuId is null and c.partnerType = 'OPR' and c.partnerId = update tbl_TPM_ProofOfDelivery set skuId = where ownerId = 288 and ownerType = 'MFR' and claimId in ( ) and coalesce( itemCode, '' ) = and itemDescription = and skuId is null select distinct epod.claimId from tbl_TPM_ProofOfDelivery epod with (nolock) inner join tbl_TPM_Claims c with (nolock) on c.ownerId = epod.ownerId and c.ownerType = epod.ownerType and c.claimId = epod.claimId where epod.ownerId = 288 and epod.ownerType = 'MFR' and coalesce( epod.itemCode, '' ) = and epod.skuId is null and c.partnerType = 'OPR' and c.partnerId = update tbl_TPM_ProofOfDelivery set skuId = where ownerId = 288 and ownerType = 'MFR' and claimId in ( ) and coalesce( itemCode, '' ) = and skuId is null select c.claimId, c.readyToAudit, c.readyTOClear, c.claimStatus from tbl_TPM_Claims c with (nolock) where c.ownerId = 288 and c.ownerType = 'MFR' and not exists ( select * from tbl_TPM_ProofOfDelivery epod with (nolock) where epod.ownerId = c.ownerId and epod.ownerType = c.ownerType and epod.claimId = c.claimId and epod.skuId is null ) and c.claimId in ( ) select * from qmd_mapping where skuId = 0