查询EBS用户职责SQL

最新推荐文章于 2022-06-11 10:54:59 发布

煎蛋没有蛋

最新推荐文章于 2022-06-11 10:54:59 发布

阅读量686

点赞数

分类专栏：应用与中间件-EBS 开发

本文链接：https://blog.youkuaiyun.com/weixin_50666314/article/details/109068081

版权

应用与中间件-EBS 开发专栏收录该内容

4 篇文章

订阅专栏

该SQL查询用于从EBS系统中检索指定用户拥有的与'预算会计'相关的职责信息，包括用户ID、职责名称、应用ID、有效日期等，并确保职责当前处于有效状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查询EBS用户职责SQL

SELECT FU.USER_NAME,
       FU.USER_ID,
       FRV.RESPONSIBILITY_NAME,
       FRV.RESPONSIBILITY_ID,
       FRV.APPLICATION_ID,
       FURG.START_DATE,
       FURG.END_DATE,
       hou.attribute1,
       Hou.NAME
  FROM FND_USER_RESP_GROUPS_ALL  FURG,
       FND_RESPONSIBILITY_VL     FRV,
       FND_USER                  FU,
       per_all_people_f          papf,
       per_all_assignments_f     paaf,
       hr_all_organization_units hou
WHERE FURG.RESPONSIBILITY_ID = FRV.RESPONSIBILITY_ID
   AND FURG.RESPONSIBILITY_APPLICATION_ID = FRV.APPLICATION_ID
   AND FURG.USER_ID = FU.USER_ID
   AND FU.USER_NAME = '%用户名称%' --用户名
   AND FRV.RESPONSIBILITY_NAME LIKE '%预算会计%' --职责名
   AND NVL(FURG.END_DATE, SYSDATE + 1) >= SYSDATE
   and paaf.organization_id=hou.organization_id(+)
   and (trunc(sysdate) between papf.effective_start_date and
       papf.effective_end_date)
   and (trunc(sysdate) between paaf.effective_start_date and
       paaf.effective_end_date)
   and paaf.organization_id=hou.organization_id(+)
   and papf.person_id = fu.employee_id
   and papf.person_id = paaf.person_id
   and paaf.primary_flag = 'Y'