Oracle layer-3 nested query bug

The following SQL statement does not query any records, even though the database has qualified records. This is an Oracle layer-3 query bug.

Select cb. * from mw_app.t_cb cb where cb. obj_id in

(Select CBA. channel_id from mw_app.t_current_business_alarm CBA where CBA. business_id in

(Select B. business_id from mw_app.t_rt_business B where B. alarm_state <> '0' and B. business_code = '1 '))

To query the results, you must change the SQL statement

Select cb. * from mw_app.t_cb cb Left Join (select alarm. channel_id from mw_app.t_current_business_alarm alarm

Where alarm. business_id in (select business_id from mw_app.t_rt_business where alarm_state <> '0' and business_code = '1') B

On cb. obj_id = B. channel_id

Or

Select cb. * from mw_app.t_cb cb Left Join (

Select alarm. channel_id from mw_app.t_current_business_alarm alarm left join mw_app.t_rt_business biz

On alarm. business_id = biz. business_id

Where (biz. alarm_state <> '0' and biz. business_code = '1') B

On cb. obj_id = B. channel_id