Following sql can be used to find out service extension condition :

select e1.ext_set_name, c.name, e1.ext_set_desc
from extensionset e1,extsetcondval e2, cdconditionvaltp c
where e1.extension_set_id=e2.extension_Set_id
and e2.cond_val_tp_cd=c.cond_val_tp_cd
order by e1.ext_set_name, c.name

 

 

 

 

 

Advertisements