SKU: #qrySkuInfo.sku# #qrySkuInfo.skudesc# #qrySkuInfo.packsizedesc#
Stocking Status checked /> Open checked /> Closed checked /> Special checked /> Unknown
Distributor SKU disabled="disabled" />

select st.stockingstatus, sku.sku, sku.skudesc, sku.packsizedesc from tbl_cdr_stocking st with (nolock) inner join tbl_prd_skus sku with (nolock) on sku.skuid = st.skuid and sku.ownerid = st.ownerid and sku.fsl_tablecode = st.ownertype where st.ownerid = and st.ownertype = and st.cdr_recordid = and st.skuid = select sku.sku, sku.skudesc, sku.packsizedesc from tbl_prd_skus sku with (nolock) where sku.ownerid = and sku.fsl_tablecode = and sku.skuid =