select * from ssouser.ssomng_view
where sa_locate = '대만'
and (sso_ex_flag != 'D' and nvl(sa_temp,'77') <> '71')
order by sa_dept_name;