eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.XDP_PROFILE_OPTIONS_V

Source

View Text - Preformatted


SELECT fpo.PROFILE_OPTION_NAME, fpt.USER_PROFILE_OPTION_NAME, fpt.DESCRIPTION, fpv.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTIONS fpo, FND_PROFILE_OPTIONS_TL fpt, FND_PROFILE_OPTION_VALUES fpv WHERE fpo.PROFILE_OPTION_NAME = fpt.PROFILE_OPTION_NAME AND fpo.PROFILE_OPTION_ID = fpv.PROFILE_OPTION_ID(+) AND fpo.APPLICATION_ID IN (534,535) AND nvl(fpv.LEVEL_ID, 10001) = 10001 AND nvl(fpo.END_DATE_ACTIVE, SYSDATE) >= SYSDATE AND fpt.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT FPO.PROFILE_OPTION_NAME
, FPT.USER_PROFILE_OPTION_NAME
, FPT.DESCRIPTION
, FPV.PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTIONS FPO
, FND_PROFILE_OPTIONS_TL FPT
, FND_PROFILE_OPTION_VALUES FPV
WHERE FPO.PROFILE_OPTION_NAME = FPT.PROFILE_OPTION_NAME
AND FPO.PROFILE_OPTION_ID = FPV.PROFILE_OPTION_ID(+)
AND FPO.APPLICATION_ID IN (534
, 535)
AND NVL(FPV.LEVEL_ID
, 10001) = 10001
AND NVL(FPO.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND FPT.LANGUAGE = USERENV('LANG')