--查看职责,哪个用户有
SELECT FU.USER_NAME,
FRV.RESPONSIBILITY_NAME, --职责名称
FURG.CREATION_DATE,
FURG.CREATED_BY,
FURG.START_DATE, --添加职责开始时间
FURG.END_DATE, --职责到期时间
FURG.LAST_UPDATE_DATE, --更新职责时间
FURG.LAST_UPDATED_BY --更新职责操作人ID
FROM FND_USER_RESP_GROUPS_ALL FURG,
FND_RESPONSIBILITY_VL FRV,
FND_USER FU
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 --不包括用户已经失效的职责
ORDER BY FURG.USER_ID, FURG.START_DATE; --多列排序,第一类一样,才会排序第二段
SELECT FU.USER_NAME,
FRV.RESPONSIBILITY_NAME, --职责名称
FURG.CREATION_DATE,
FURG.CREATED_BY,
FURG.START_DATE, --添加职责开始时间
FURG.END_DATE, --职责到期时间
FURG.LAST_UPDATE_DATE, --更新职责时间
FURG.LAST_UPDATED_BY --更新职责操作人ID
FROM FND_USER_RESP_GROUPS_ALL FURG,
FND_RESPONSIBILITY_VL FRV,
FND_USER FU
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 --不包括用户已经失效的职责
ORDER BY FURG.USER_ID, FURG.START_DATE; --多列排序,第一类一样,才会排序第二段