Otis Brass Scraper Set
|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 = 'FG-932 ' AND (upper(f.web_text) = 'OTIS' or upper(f.orig_text) = 'OTIS' or upper(a.brand) = 'OTIS') 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|
The MSR/AR Maintenance Tool Set contains the tools to clean some of the most critical parts of your firearm that would have been nearly impossible to clean before. Included in this set are a scraper, a locking lug scraper, a straight pick, a pin punch, a nylon end brush, a compact receiver brush, and two rod handles. These tools will not scratch the firearm, and with them you can now thoroughly clean areas such as the locking lugs, the slides, bolt face, rails, and any other hard to reach places. These components can be ordered as separate add-ons to all kits, and will fit in existing softpacks!
- IP110038P (Brass Scraper)
The brass scraper is used to clean carbon deposits and other debris from any flat surface on your firearm. This includes areas such as the bolt face and rails.
- IP-100-37 (Locking Lug Scraper)
This scraper is designed specifically for the locking lugs of your AR-15/M4/M16. It has a 90 degree bend so it allows you to finally be able to clean the back side of the locking lugs.
- IP-100-39 (Straight Locking Lug Pick)
The straight pick is engineered to clean in the tight crevices of your firearm.
- IP-100-61 (Pin Punch)
The pin punch is great for removing the pins out of any firearm held together with a pin system.
- IP-318 (Nylon End Brush)
This end brush can be used to lubricate the slides, but also has stiff enough bristles to dust off carbon and other loose debris.
- IP-324 (Compact Receiver Brush)
With its aggressive heat treated, nylon bristles, the compact receiver brush can be used on all parts of any firearm that may need a bit of a scrub.
- IP11009100P (Male Rod Handle) & IP11009098P (Female Rod Handle)
The male and female rods act as handles, and can be added onto any of the components in this tool set for additional length during precision cleaning.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review