Last query SELECT CR.*,VU.* FROM certificate_report CR,vendor_user VU WHERE CR.user_id = 218 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 VIRAT ALUMINIUM, MUMBAI, Pin-400004 is registered at Troop Comforts Limited for following Items.
Sr No | Factory/ Unit | Item Nomenclature | Valid Upto |
---|---|---|---|
1 | Ordnance Equipment Factory | ALUMINIUM ALLOY BARS VARIOUS[21]( Specification : AS PER REQUIREMENT & SPECIFICATION ) | 2024-11-28 |
2 | Ordnance Equipment Factory | ALUMINIUM ALLOY CHANNELS VARIOUS[21]( Specification : AS PER REQUIREMENT & SPECIFICATION ) | 2024-11-28 |
3 | Ordnance Equipment Factory | ALUMINIUM ALLOY TUBES OR PIPES VARIOUS[21]( Specification : AS PER REQUIREMENT & SPECIFICATION ) | 2024-11-28 |
4 | Ordnance Equipment Factory | ALUMINIUM ALLOY SHEETS OR PLATES VARIOUS[21]( Specification : AS PER REQUIREMENT & SPECIFICATION ) | 2024-11-28 |
5 | Ordnance Equipment Factory | ALUMINIUM ALLOY RODS OR ROUNDS VARIOUS[21]( Specification : AS PER REQUIREMENT & SPECIFICATION ) | 2024-11-28 |
6 | Ordnance Equipment Factory | ALUMINIUM ALLOY SHEET SIZE 3 X 900 X 2400 MM.[21]( Specification : IS : 737-1986 NS-5 1/4 HARD GRADE 53000 H-1 ) | 2024-11-28 |
7 | Ordnance Equipment Factory | ALUMINIUM ALLOY ROD 16MM[21]( Specification : IS : 733 - 1967 DESIGN HE 30WP ) | 2024-11-28 |
8 | Ordnance Equipment Factory | ALUMINIUM ALLOY TUBE 40 MM OD X25MM ID IN THE CUT LENGTH OF 3.41 METER.[21]( Specification : IS:1285-1975 GR. 64430 W.P. ) | 2024-11-28 |
9 | Ordnance Equipment Factory | ALU ALLOY ROD 9.5 MM + 0.2 MM - 0.2 MM[21]( Specification : IS :733- 1977 ALLOY - 64430 CONDITION W.P. ) | 2024-11-28 |
10 | Ordnance Equipment Factory | ALUMINIUM ALLOY SHEET 1.5.MM THICK[21]( Specification : IS : 737-1986 NS-5 1/4 HARD GRADE 53000 H-1 ) | 2024-11-28 |
11 | Ordnance Equipment Factory | ALUMINIUM ALLOY ROD 38.10MM +/- 0.30MM DIA[21]( Specification : IS733 DESGN.HE19WP OR HE 30 WP ) | 2024-11-28 |
12 | Ordnance Equipment Factory | ALUMINIUM ALLOY TUBE 22 MM O/D X 2.5 MM W.T. ML OF 2.09 MTR.[21]( Specification : IS : 1285 DESIGN HV 19 WP OR HV 30 WP ) | 2024-11-28 |
13 | Ordnance Equipment Factory | ALUMINIUM ALLOY RODS OR ROUNDS OR WIRES VARIOUS[21]( Specification : AS PER REQUIREMENT & SPECIFICATION ) | 2024-11-28 |
Registration No. : 40000427AACPS4448N1Z4 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)