Last query SELECT CR.*,VU.* FROM certificate_report CR,vendor_user VU WHERE CR.user_id = 15696 and CR.factory_id in ('30','31','33', '34') and CR.user_id=VU.user_id and CR.valid_upto>=now() order by CR.factory_id desc
Troop Comforts Limited
A Government of India Enterprise
Ministry of Defence
This is to certify that M/S HAMRAZ INTERNATIONAL, Kanpur, Pin-208008 is registered at Troop Comforts Limited for following Items.
Sr No | Factory/ Unit | Item Nomenclature | Valid Upto |
---|---|---|---|
1 | Ordnance Equipment Factory Hazaratpur | Fabrication of Bag kit MK-II( As per latest specification governing by AHSP ) | 2027-06-12 |
2 | Ordnance Equipment Factory Hazaratpur | Fabrication of Duffle Trolley Bag.( As per latest specification governing by AHSP ) | 2027-06-12 |
3 | Ordnance Equipment Factory Hazaratpur | Fabrication of Case Canvas for telescopic sight for Assault Riffles( As per latest specification governing by AHSP ) | 2027-06-12 |
4 | Ordnance Equipment Factory Hazaratpur | Fabrication of Carrier Main Pack MK-1( Stitching & fitting of Garniture items as per latest specification governing by AHSPr latest specification governing by AHSP ) | 2027-06-12 |
5 | Ordnance Equipment Factory Hazaratpur | Fabrication of Case Canvas for telescopic( as per latest specification governing by AHSP ) | 2027-06-12 |
6 | Ordnance Equipment Factory Hazaratpur | Fabrication of Hammock( As per latest specification governing by AHSP ) | 2027-06-12 |
7 | Ordnance Equipment Factory Hazaratpur | Fabrication of Cap Balaclava OG Improved( Fabrication of Cap Balaclava OG (Imp.) Specification S/5094/TC-1 (b)/CAP BAL OG (IMP.) ) | 2027-06-12 |
8 | Ordnance Equipment Factory Hazaratpur | Fabrication of COAT ECC( As per latest drawing and specification governing by AHSP ) | 2027-06-12 |
Registration No. : 20800809AAIFH6227N1ZV Conditions of Registration: Normal This Registration has been carried out based on self-declared documents furnished by Vendor. Changes, if any, in Address or constitution of the Firm, major Machinery/Equipment or Technology should be intimated to the Registration Authority immediately. The Registration Authority reserves the right to cancel this Registration Certificate at any time. Registration will be valid for 03 years
(Troop Comforts Limited) (Signature is not required)