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 rent_arrears ( council_tax_id number, cmi_cross_ref_id number )
TABLE: CREATE TABLE council_tax ( council_tax_id number, cmi_cross_ref_id number )
TABLE: CREATE TABLE customer_master_index ( master_customer_id number, cmi_details text )
TABLE: CREATE TABLE cmi_cross_references ( cmi_cross_ref_id number, master_customer_id number, source_system_code text )
TABLE: CREATE TABLE parking_fines ( council_tax_id number, cmi_cross_ref_id number )
TABLE: CREATE TABLE electoral_register ( electoral_register_id number, cmi_cross_ref_id number )
TABLE: CREATE TABLE benefits_overpayments ( council_tax_id number, cmi_cross_ref_id number )
TABLE: CREATE TABLE business_rates ( business_rates_id number, cmi_cross_ref_id number )

### Question ###
What are the renting arrears tax ids related to the customer master index whose detail is not 'Schmidt, Kertzmann and Lubowitz'?

### Accurate SQL ###

SELECT T1.council_tax_id FROM rent_arrears AS T1 JOIN cmi_cross_references AS T2 ON T1.cmi_cross_ref_id = T2.cmi_cross_ref_id JOIN customer_master_index AS T3 ON T3.master_customer_id = T2.master_customer_id WHERE T3.cmi_details <> 'Schmidt ,  Kertzmann and Lubowitz'