SELECT USER_ID,RESPONSIBILITY_ID,RESPONSIBILITY_APPLICATION_ID,
SECURITY_GROUP_ID
FROM FND_USER_RESP_GROUPS
WHERE USER_ID = (SELECT USER_ID
FROM FND_USER
WHERE USER_NAME = 'MFG')
AND RESPONSIBILITY_ID = (SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_NAME = 'Inventory');
select * from fnd_user_resp_groups where user_id = 1068 and SECURITY_GROUP_ID = 401;
select * from FND_SECURITY_GROUPS;
SECURITY_GROUP_ID
FROM FND_USER_RESP_GROUPS
WHERE USER_ID = (SELECT USER_ID
FROM FND_USER
WHERE USER_NAME = 'MFG')
AND RESPONSIBILITY_ID = (SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_NAME = 'Inventory');
select * from fnd_user_resp_groups where user_id = 1068 and SECURITY_GROUP_ID = 401;
select * from FND_SECURITY_GROUPS;
No comments:
Post a Comment