CREATE view RRV_FE_AREA as select * from FE_AREA where (exists (select * from fe_v_grp4currentuser where groupname=?WH_USER?) and area_code>= 1) and exists (select 1 from fe_entity_by_user where r_name in (select groupname from FE_V_GRP4CURRENTUSER) and entity_name = ?RRV_FE_AREA?) with check option