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

Popular Posts