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 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 qryPurchProfileAB where updateid <> select osd.subjectDetailId as skuid, opp.availabledate, opp.stageid, QuantityAmt, QuantityUnit, DurationAmt, DurationUnit, UpdateDate, caseAmt 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#

Item Status
checked> checked> checked> checked> checked> checked> checked> checked> checked>
Est Order Date
test

Ord Dt
checked value="INC" class="required" title="sale type required" data-mini="true" type="radio" name="typecode_#qryItem.salesubjectid#_#qryItem.interactiondetailid#" id="typecode_1_#qryItem.salesubjectid#_#qryItem.interactiondetailid#"> checked value="PRO" data-mini="true" type="radio" name="typecode_#qryItem.salesubjectid#_#qryItem.interactiondetailid#" id="typecode_2_#qryItem.salesubjectid#_#qryItem.interactiondetailid#">
select skuid, sampleStatus, sampleDate from tbl_OPR_ProductStatus where ownerId = and ownerType = and operatorid = and skuid = and updateid <>
Submit
Delete
Cancel