Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_24193494_3 ( division VARCHAR, powertrain__engine_transmission_ VARCHAR )

### Question ###
Name the division for detroit diesel series 50egr allison wb-400r

### Accurate SQL ###

SELECT division FROM table_24193494_3 WHERE powertrain__engine_transmission_ = "Detroit Diesel Series 50EGR Allison WB-400R"