Tenders >> Limited Tenders
Welcome to Cement Corporation of India's tender section. Kindly choose any one unit and view various tenders under it. You may view or download the tender after accepting its respective Terms & Conditions.

Please click on the Bracket "( )" to view respective tender.
SELECT distinct u.id, u.unit, u.image, u.status, u.date_added, IFNULL(t.cnt_tender, 0) as cnt_tender, IFNULL(cnt_corrigend, 0) as cnt_corrigend, IFNULL(tl.cnt_tender_l, 0) as cnt_tender_l FROM unit u LEFT JOIN (SELECT count(id) as cnt_tender, cast(unit AS UNSIGNED) as unit FROM limited_tender WHERE archive_status = 'no' GROUP BY unit) t ON u.id = t.unit LEFT JOIN (SELECT count(id) as cnt_corrigend, cast(unit AS UNSIGNED) as unit from corrigendum WHERE tender_type='limited' GROUP BY unit) c ON u.id = c.unit LEFT JOIN (SELECT count(id) as cnt_tender_l, cast(unit AS UNSIGNED) as unit FROM limited_tender WHERE archive_status = 'no' AND open_dt_tender >= CURDATE() GROUP BY unit) tl ON u.id = tl.unit WHERE u.status = 1 ORDER BY u.unit ASC
Adilabad
Total Tenders -(0)
Corrigendums -(0)
View latest tender -(0)
Bangalore
Total Tenders -(0)
Corrigendums -(0)
View latest tender -(0)
Bokajan
Total Tenders -(176)
Corrigendums -(54)
View latest tender -(36)
Corporate Office
Total Tenders -(14)
Corrigendums -(3)
View latest tender -(3)
Co_Akaltara
Total Tenders -(0)
Corrigendums -(0)
View latest tender -(0)
Co_Mandhar
Total Tenders -(0)
Corrigendums -(0)
View latest tender -(0)
Dehradun Zonal Office
Total Tenders -(0)
Corrigendums -(0)
View latest tender -(0)
Guwahati Zonal Office
Total Tenders -(0)
Corrigendums -(0)
View latest tender -(0)
Pune
Total Tenders -(0)
Corrigendums -(0)
View latest tender -(0)
Rajban
Total Tenders -(103)
Corrigendums -(10)
View latest tender -(3)
Silchar Grinding Unit
Total Tenders -(0)
Corrigendums -(2)
View latest tender -(0)
Tandur
Total Tenders -(400)
Corrigendums -(178)
View latest tender -(20)
Zonal Office Hyderabad
Total Tenders -(1)
Corrigendums -(1)
View latest tender -(0)
Copyright 2018 All Right Reserved, Privacy Policy, Disclaimer