Flambeau Classic XL 3 Tray Box
Item# 2137B / 6184TB
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '2137B / 6184TB' AND (upper(f.web_text) = 'FLAMBEAU' or upper(f.orig_text) = 'FLAMBEAU' or upper(a.brand) = 'FLAMBEAU') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
Classic tray series features Drawtite latch, Tip-Guard tray supports and all weather, worm proof materials. The tongue-and groove construction between lid and base yields water resistant design and precision fit. This oversized eXtra-Large 3-tray features up to 37 compartments and two clear lid covers on top tray that keep small items from moving around inside box. The largest 3-tray box available.
Size 20 x 10.25 x 10.375 Up to 37 compartments. Drawtite latch, tip-guard tray supports and all weather, worm-proof materials. Tongue-and-Groove construction between lid and base yields water-resistant design and precision fit. Each includes removable dividers for enhanced storage capabilities. Varied tray depth for greater capacity options.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$2.29 to $10.99
$29.99 to $36.99