VIEW: APPS.JTM_FND_PROF_OPTIONS_VAL_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID ,VAL.APPLICATION_ID ,VAL.PROFILE_OPTION_ID ,VAL.LEVEL_ID ,VAL.LEVEL_VALUE ,VAL.LAST_UPDATE_DATE ,VAL.LAST_UPDATED_BY ,VAL.CREATION_DATE ,VAL.CREATED_BY ,VAL.LAST_UPDATE_LOGIN ,VAL.PROFILE_OPTION_VALUE ,NVL(VAL.LEVEL_VALUE_APPLICATION_ID, -1) LEVEL_VALUE_APPLICATION_ID FROM FND_PROFILE_OPTION_VALUES VAL, JTM_FND_PROF_OPTIONS_VAL_ACC ACC WHERE VAL.APPLICATION_ID = ACC.APPLICATION_ID AND VAL.LEVEL_ID = ACC.LEVEL_ID AND VAL.LEVEL_VALUE = ACC.LEVEL_VALUE AND NVL(VAL.LEVEL_VALUE_APPLICATION_ID, -1) = NVL(ACC.LEVEL_VALUE_APPLICATION_ID, -1) AND VAL.PROFILE_OPTION_ID = ACC.PROFILE_OPTION_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, VAL.APPLICATION_ID
, VAL.PROFILE_OPTION_ID
, VAL.LEVEL_ID
, VAL.LEVEL_VALUE
, VAL.LAST_UPDATE_DATE
, VAL.LAST_UPDATED_BY
, VAL.CREATION_DATE
, VAL.CREATED_BY
, VAL.LAST_UPDATE_LOGIN
, VAL.PROFILE_OPTION_VALUE
, NVL(VAL.LEVEL_VALUE_APPLICATION_ID
, -1) LEVEL_VALUE_APPLICATION_ID
FROM FND_PROFILE_OPTION_VALUES VAL
, JTM_FND_PROF_OPTIONS_VAL_ACC ACC
WHERE VAL.APPLICATION_ID = ACC.APPLICATION_ID
AND VAL.LEVEL_ID = ACC.LEVEL_ID
AND VAL.LEVEL_VALUE = ACC.LEVEL_VALUE
AND NVL(VAL.LEVEL_VALUE_APPLICATION_ID
, -1) = NVL(ACC.LEVEL_VALUE_APPLICATION_ID
, -1)
AND VAL.PROFILE_OPTION_ID = ACC.PROFILE_OPTION_ID