select
 a.ri as `R_ID`
,oc3.name as `RET`
,a.rch as `RC`
from dev.sl a join dev.codes oc3
    on (a.pk_business = oc3.pk_business
    and a.pk_data_source = oc3.pk_data_source
    and a.pk_frequency = oc3.pk_frequency
    and oc3.pk_data_state = '123'
    and oc3.code = a.ri and oc3.codeset = 'xyz')

select
 a.ri as `R_ID`
,oc3.name as `RET`
,a.rch as `RC`
from dev.sl a join dev.codes oc3
    on (a.pk_business = oc3.pk_business
    and a.pk_data_source = oc3.pk_data_source
    and a.pk_frequency = oc3.pk_frequency
    and oc3.pk_data_state = '123'
    and oc3.code = a.ri and oc3.codeset = 'xyz') join dev.items b
on (b.pk_business = a.pk_business
and b.pk_data_source = a.pk_data_source
and b.pk_frequency = a.pk_frequency
and b.pk_data_state = '123'
and a.ii = b.item_id
and a.cc = b.country_code)