Last query SELECT CR.*,VU.* FROM certificate_report CR,vendor_user VU WHERE CR.user_id = 15741 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 Barrel Hone, JHAJJAR, Pin-124507 is registered at Troop Comforts Limited for following Items.
Sr No | Factory/ Unit | Item Nomenclature | Valid Upto |
---|---|---|---|
Registration No. : 12450706AIBPD1137E1Z2 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)