delete from tbl_prd_skuRequest where skuRequestid = delete from tbl_prd_skuRequestLink where skuRequestid = select sr.*, srl.skuid as MySkuId, COALESCE(s.sku, sr.requestorMfrSku) sku, COALESCE(s.skudesc, sr.requestorSkuDesc) skudesc, m.mfr_name, coalesce(cdr.cdr_dstName, byg.name) requestorName from tbl_PRD_SkuRequest sr with (nolock) left outer join tbl_PRD_SkuRequestLink srl on sr.skuRequestId = srl.skuRequestId left outer join tbl_PRD_SKus s with (nolock) on s.skuid = srl.skuid left outer join tblManufacturers m with (nolock) on m.mfr_id = sr.mfrid left outer join tbl_CDR_Distributors cdr on sr.requestorid = cdr.cdr_recordId and sr.requestorType = 'CDR' left outer join tbl_BYG_BuyingGroups byg on sr.requestorid = byg.uniqueid and sr.requestorType = 'BYG' where sr.ownerType = 'BRO' and sr.ownerid = 2661 and sr.skuRequestId = and sr.status IN () and s.mfrid = order by sr.createDate desc, mfr_name, requestorName select DISTINCT m.mfr_id, m.mfr_name from tbl_PRD_SkuRequest sr with (nolock) inner join tbl_PRD_SkuRequestLink srl on sr.skuRequestId = srl.skuRequestId inner join tbl_PRD_SKus s with (nolock) on s.skuid = srl.skuid inner join tblManufacturers m with (nolock) on m.mfr_id = s.mfrid where s.fsl_tableCode = 'BRO' and s.ownerid = 2661 order by Mfr_name
Datasource:
Manufacturer:
Status:
checked="checked" >Unsent checked="checked" >Waiting on Supplier checked="checked" >Supplier Ready checked="checked" >Inactive checked="checked" >Complete
Sku RequestId:

Production Data - Requests Found: #numberformat(qry_SkuRequests.recordCount)#

Development Data - Requests Found: #numberformat(qry_SkuRequests.recordCount)#
Results Capped at #numberformat(variables.MaxRows)# rows.
SKU INFO REQUEST INFO
MFR SkuId MFR Sku Sku Desc skuRequestId status statusResult Requestor createDate initialStatus dateRequested dateCompleted Del.
#qry_SkuRequests.mfr_name# #qry_SkuRequests.MySkuId# #qry_SkuRequests.sku# #qry_SkuRequests.skudesc# #qry_SkuRequests.skurequestid# #qry_SkuRequests.status# #qry_SkuRequests.statusResult# #qry_SkuRequests.requestorName# #dateformat(qry_SkuRequests.createDate,'mm/dd/yyyy')# #qry_SkuRequests.initialStatus# #dateformat(qry_SkuRequests.dateRequested,'mm/dd/yyyy')# #dateformat(qry_SkuRequests.dateCompleted,'mm/dd/yyyy')#