查询EBS用户职责SQL

查询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'