Last query SELECT CR.*,VU.* FROM certificate_report CR,vendor_user VU WHERE CR.user_id = 15666 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 Hatim Steel Tube Company, Chennai, Pin-600001 is registered at Troop Comforts Limited for following Items.
Sr No | Factory/ Unit | Item Nomenclature | Valid Upto |
---|---|---|---|
Registration No. : 60000133AABPL2630E1ZE 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)