select interactiondate, contactid, notes, dispositionuserid, cdrdistributorid, mileage, AdditionalResourceUserId, partnerid, partnertype, coalesce(dispositionDate, CAST( '01/01/1960' as datetime )) dispositionDate from tbl_crm_interactions where interactionid = and ownerid = and ownertype = select InteractionDetailID, disposition, saleqty, saledurationunit, salesubjectid, salesubjecttype, nosalereasonid, salereasonid, competitorid, sourcetype, availabledate, comment, otherreasonid, stageid, samplestatus, typeCode, updateDate, competitorSku, competitorPrice, typeCode, presented from tbl_crm_interactionsaledetails where InteractionDetailID = and ownerid = and ownertype = select sku, skuDesc, mfrid from tbl_prd_skus where ownerid = and fsl_tablecode = and skuid = select reasonid from qcf_getNoSaleReasonsForItem where requireCompetitor = 'Y' select reasonid from qcf_getNoSaleReasonsForItem where requireComment = 'Y' select * from qmd_stages where statusCode = 'I' select * from qmd_stages where statusCode != 'I' select * from qryPurchProfileAB where updateid <> select osd.subjectDetailId as skuid, opp.availabledate, opp.stageid, QuantityAmt, QuantityUnit, DurationAmt, DurationUnit, UpdateDate, caseAmt, opp.typeCode from tbl_spl_opportunities opp inner join tbl_SPL_OpportunitySubjectDetails osd on osd.opportunityid = opp.opportunityid where opp.ownerid = and opp.ownertype = and opp.partnertype = and opp.partnerid = and opp.stageid in () and osd.SubjectDetailType = 'sku' and osd.subjectDetailId =

#_itemDescription#

Ord Dt

select skuid, sampleStatus, sampleDate from tbl_OPR_ProductStatus where ownerId = and ownerType = and operatorid = and skuid = and updateid <>

Submit

Delete

Cancel