select sku.sku, pkg.scc14, isd.AnnualCaseAmt, 0 as mfrSkuId from tbl_crm_interactionsaledetails isd with (nolock) inner join tbl_prd_skus sku with (nolock) on sku.skuid = isd.salesubjectid and sku.mfrid = inner join tbl_prd_packaging pkg with (nolock) on pkg.linkid = sku.skuid and pkg.linktype = 'sku' where isd.ownerid = and isd.ownertype = and isd.interactionid = and isd.salesubjecttype = 'sku' select skuid from tbl_prd_skus sku with (nolock) inner join tbl_prd_packaging pkg with (nolock) on pkg.linkid = sku.skuid and pkg.linktype = 'sku' where sku.ownerid = and ( sku.sku = or pkg.scc14 = ) select skuid, sku, skuDesc, packSizeDesc from tbl_prd_skus with (nolock) where ownerid = and fsl_tablecode = 'MFR' and skuid in () order by sku select AnnualCaseAmt from qryIntItems where mfrSkuId =
Item #sku#: #skuDesc# - #packSizeDesc#
Rate Cs/Yr