How To Know All Profile Options Related with one User By using His User Name:
SELECT
OPT.PROFILE_OPTION_NAME, VAL.PROFILE_OPTION_VALUE , VAL.LAST_UPDATE_DATE
FROM
APPLSYS.FND_PROFILE_OPTION_VALUES VAL,
APPLSYS.FND_PROFILE_OPTIONS OPT,
APPLSYS.FND_USER FUSER
WHERE
VAL.PROFILE_OPTION_ID = OPT.PROFILE_OPTION_ID
AND VAL.LEVEL_VALUE = FUSER.USER_ID
--AND OPT.PROFILE_OPTION_NAME = 'ICX_NUMERIC_CHARACTERS'
-- AND VAL.LEVEL_ID = 10004 -- USER LEVEL
AND FUSER.USER_NAME = 'IBRAHIMMA';
Comments
Post a Comment