select ter.territoryId from tbl_TER_TErritories ter inner join tbl_OPR_CLientOperators opr on opr.territoryId = ter.territoryId and opr.ownerId = ter.ownerId and opr.fsltablecode = ter.fsl_tablecode and opr.operatorId = inner join tbl_CDR_Distributors cdr on cdr.cdr_territoryId = ter.territoryId and cdr.ownerId = ter.ownerId and cdr.fsl_tablecode = ter.fsl_tablecode and cdr.cdr_recordId = where ter.ownerId = and ter.fsl_tablecode = select distinct mfrId from qmd_principals lookupAttrs = StructNew(); if( url.detailType eq "SKU" ) { lookupAttrs.SlctFields = "s.skuid, s.sku, s.skuDesc, s.prodId, s.discontinued, s.foodService_Rewards"; if( url.skuPattern neq "" ) { lookupAttrs.Keyword = url.skuPattern; lookupAttrs.SkuKeywordSrch = "YES"; } else { lookupAttrs.sku = "THIS WILL MATCH NOTHING"; } } else if ( url.detailType eq "PRODUCT" ) { lookupAttrs.AddFields = ", p.product"; if( url.skuPattern neq "" ) { lookupAttrs.Keyword = url.skuPattern; } else { lookupAttrs.prodid = -1; // this will match nothing } } lookupAttrs.ownerId = attributes.ownerId; lookupAttrs.fsl_Tablecode = attributes.ownerType; lookupAttrs.datasource = attributes.datasource; lookupAttrs.getCategoryName="NO"; select * from qmd_detailData where discontinued = 'N' select c.categoryId, l.productcode + '-' + l.productLine + ' / ' + c.catnum + '-' + c.category category, coalesce( m.mfr_Id, 0 ) categoryId, coalesce( m.mfr_name, 'Unknown' ) category, p.prodId subCategoryId, p.product + ' - ' + p.shortDesc subCategory, p.prodId subjectId from tbl_PRD_Products p inner join tbl_PRD_Categories c on c.categoryId = p.categoryId inner join tbl_MFR_ProductLines l on l.prodline_id = c.ProdLineId inner join tblManufacturers m on m.mfr_id = p.mfrId and m.mfr_id in ( ) where p.prodId in ( select s.prodId from tbl_PRD_Skus s where s.ownerId = and s.fsl_tablecode = and ( s.sku like or s.skuDesc like ) and s.inactive = '0' and s.crmactive = 'Y' and s.discontinued = 'N' -- and ( { fn now() } between s.publishdate and s.unpublishdate ) 0 ) and p.ownerId = and p.fsl_tablecode = order by l.sortRank, l.productline, c.sortRank, c.categorym.mfr_name, subCategory

Type the first three characters of the SKU you are looking for. The matching SKUs will be displayed below.

Type the first three characters of the PRODUCT you are looking for. The matching PRODUCTs will be displayed below.

SKUPRODUCT:

Select a SKU and then click OK.

#category#

#subCategory#

select * from qmd_detailData where prodId =

#sku# - #htmleditformat( skuDesc )#

#product# - #htmleditformat( shortDesc )#

To search, enter a SKU in the input box below and then click the Search button.

No SKUs were found. Please try again, or if you are not finding a known SKU please contact your administrator.

To search, enter a PRODUCT in the input box below and then click the Search button.

No PRODUCTs were found. Please try again, or if you are not finding a known PRODUCT please contact your administrator.

select mfrId from tbl_PRD_Products where ownerId = and fsl_tablecode = and prodId = select categoryId from tbl_PRD_Products where prodId = and ownerid = and fsl_tablecode =