BEGIN
fnd_user_pkg.delresp ('SCOTT', ---- User Name
'FND', ---Application Short Name
'APPLICATION_DEVELOPER', ---Responsibility Key
'STANDARD'); --Security Group Key
END;Execute below Query you will get the Application Short Name and Responsibility Key
SELECT MUT.APPLICATION_SHORT_NAME, SHI.RESPONSIBILITY_KEY, SHI.RESPONSIBILITY_NAME
FROM FND_APPLICATION_VL MUT, FND_RESPONSIBILITY_VL SHI
WHERE SHI.APPLICATION_ID=MUT.APPLICATION_ID
ORDER BY SHI.RESPONSIBILITY_NAME;
Examble:-
BEGIN
fnd_user_pkg.delresp ('MUTHU',
'INV',
'INVENTORY',
'STANDARD');
END;
fnd_user_pkg.delresp ('SCOTT', ---- User Name
'FND', ---Application Short Name
'APPLICATION_DEVELOPER', ---Responsibility Key
'STANDARD'); --Security Group Key
END;Execute below Query you will get the Application Short Name and Responsibility Key
SELECT MUT.APPLICATION_SHORT_NAME, SHI.RESPONSIBILITY_KEY, SHI.RESPONSIBILITY_NAME
FROM FND_APPLICATION_VL MUT, FND_RESPONSIBILITY_VL SHI
WHERE SHI.APPLICATION_ID=MUT.APPLICATION_ID
ORDER BY SHI.RESPONSIBILITY_NAME;
Examble:-
BEGIN
fnd_user_pkg.delresp ('MUTHU',
'INV',
'INVENTORY',
'STANDARD');
END;
No comments:
Post a Comment