View: XDP_PROFILE_OPTIONS_V

Product:	XDP - Provisioning
Description:	This View shows all the Profile Option for XDP and XNP.
Implementation/DBA Data:	APPS.XDP_PROFILE_OPTIONS_V

View Text

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')

Columns