奥客

摘要： 查询人员的视图select * from PER_PEOPLE_V7查询人员对应的部门及隶属部门CREATE OR REPLACE VIEW SECOM_SVREG_QUERY_SALES ASselect rgm.PERSON_ID , ppv.full_name person_name -- rgm.RESOURCE_NAME person_name ,rgm.GROUP_ID,rgv.GROUP_NAME ,pgn.related_group_id dept_id,pgn.related_group_name dept_namefrom jtf_rs_group_members_vl.. 阅读全文