各位,谁能写个查询员工岗位的脚本给我,谢谢!

select * from PER_ASSIGNMENTS_V

select * from PER_ALL_ASSIGNMENTS_F

仅供参考...

select distinct pf.last_name full_name,
pos.JOB_DESC,
--pos.POSITION_LATEST_NAME,
pos.NAME,
pos.LOCATION_DESC,pos.ORGANIZATION_DESC
from apps.per_all_people_f pf,apps.per_all_assignments_f pa,apps.HR_POSITIONS_V1 pos
where pf.person_id=pa.person_id
and pa.position_id=pos.POSITION_ID
and pa.position_id is not null
and nvl(pa.effective_start_date,sysdate-1)<sysdate
and nvl(pa.effective_end_date,sysdate+1)>sysdate
and pf.last_name='张三'