E-bis r12 query to find userid, responsibility

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;