Adventure Medical Trauma Pack with Advanced Clotting Sponge
|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 = '2064-0292' AND (upper(f.web_text) = 'ADVENTURE MEDICAL' or upper(f.orig_text) = 'ADVENTURE MEDICAL' or upper(a.brand) = 'ADVENTURE MEDICAL') 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|
When it comes to emergencies, professionals know excess equipment only gets in the way. Act fast to provide immediate trauma care with this Trauma Pak which contains key supplies to control bleeding at the scene until medical professionals arrive. This essentials-only trauma pack contains Adventure® Medical Kit’s Advanced Clotting Sponge, a hemostatic dressing that stops bleeding three times faster by accelerating your body’s natural clotting process with zeolite. In addition to the hemostatic dressing, this pack includes a combine pad, triangular bandage, and gauze dressings to help control the bleeding and duct tape to hold it all in place. Packed in a tough, waterproof pouch that easily fits into a BDU pocket or glove box, the Trauma Pak is compact, easy-to-use addition to your medical kit, first responder kit, or everyday carry bag that could help you save a life.
1 - Bandage, Conforming Gauze, 3"
1 - Dressing, Gauze, Sterile, 2" x 2", Pkg./2
1 - Dressing, Gauze, Sterile, 4" x 4", Pkg./2
1 - Gloves, Nitrile (Pair), Hand Wipe
1 - 25 g Advanced Clotting Sponge
1 - Trauma Pad, 5" x 9"
1 - Duct Tape, 2" x 26"
Fracture / Sprain
1 - Bandage, Triangular
4 - Antiseptic Wipe
1 - Trauma and Accident Management Instructions
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review