懒人SQL-人员信息

最新推荐文章于 2023-06-13 09:29:27 发布

Ants'Tribe

最新推荐文章于 2023-06-13 09:29:27 发布

阅读量317

点赞数 1

分类专栏： EBS 技术

本文链接：https://blog.csdn.net/AntsTribe/article/details/79619069

版权

EBS 技术专栏收录该内容

6 篇文章 0 订阅

订阅专栏

SELECT pap.full_name       AS "Name"
       ,pap.employee_number AS "Employee Number"
       ,fu.user_name        AS "Oracle User Name"
       ,paf.*
FROM   fnd_user          fu
      ,per_all_people_f  pap
      ,per_assignments_f paf
WHERE  fu.employee_id = pap.person_id
AND    trunc(SYSDATE) BETWEEN pap.effective_start_date AND pap.effective_end_date
AND    pap.person_id = paf.person_id
AND    trunc(SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
AND    paf.set_of_books_id = 8639;