select bidName from tbl_OFS_Bids where bidId = SELECT distinct listNum, listName FROM tbl_ORD_myLists WHERE orderAppID = AND FSPro_UserID = AND pDataSet = AND ofsBidId = AND isNull( ofsAwarded, 'N' ) = SELECT max(listNum) AS lastListNum FROM tbl_ORD_myLists WHERE orderAppID = AND FSPro_UserID = AND pDataSet = select c.cdr_recordid, c.cdr_dstname from tbl_CDR_Distributors c left outer join tbl_TER_Territories t on t.territoryId = c.cdr_territoryid left outer join tbl_DST_Distributors d on d.dstid = c.FSL_dstid where c.ownerID = and c.fsl_tablecode = select s.skuId, s.sku, s.skuDesc, s.packsizedesc, s.fsl_tablecode, s.ownerId from tbl_PRD_Skus s where s.skuId = select f.sku, f.skuownerType, f.skuownerId from tbl_OFS_FlatSearch f where f.skuownerType = 'CHO' and f.skuownerId = and f.skuId = insert into tbl_OFS_BidLineProducts ( ownerId, ownerType, bidLineId, bidSkuId, dateCreated, createdBy ) values ( , , , , , )

#qmd_sku.sku#

select mem.firstName + ' ' + mem.lastName as fullname, blp.dateCreated from tbl_OFS_BidLineProducts blp inner join tbl_FSPro_Members mem on blp.createdBy = mem.fspro_userId where blp.bidLineProductId =

href="#request.urlPrefix#product-detail.cfm?skuId=#_skuId#" title="Added by #qmd_user.fullname# #dateFormat( qmd_user.dateCreated, 'mm/dd/yy' )#">#qmd_sku.skuDesc#

#qmd_sku.packSizeDesc#

Awarded Distributor:

Direct from MFR

Price: