Last query SELECT CR.*,VU.* FROM certificate_report CR,vendor_user VU WHERE CR.user_id = 8016 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 Mega Fibre Pvt Ltd , Pune , Pin-411026 is registered at Troop Comforts Limited for following Items.
Sr No | Factory/ Unit | Item Nomenclature | Valid Upto |
---|---|---|---|
1 | Ordnance Equipment Factory | LATEX FOAM 10.00MM THICK X 0.6 M X 1.6 M[21]( Specification : IS:1741-1960 & APPENDIX "G" OF IND/TC/3844(a). ) | 2024-12-11 |
2 | Ordnance Equipment Factory | P U FOAM 3.00 MM THICK X 0.90M X 1.90M[21]( Specification : IS:7888-1976 & APPENDIX "G" OF IND/TC/3844 ) | 2024-12-11 |
3 | Ordnance Equipment Factory | POLY URETHANE FOAM 8 MM THICK X 90 CM X 190 CM .[21]( Specification : AS PER APPENDIX "G" OF IND/TC/3844(a) ) | 2024-12-11 |
Registration No. : 41102627AABCM1598B1ZM 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)