VIEW: APPS.JTM_FND_USER_PREFERENCES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, BAS.USER_NAME, BAS.MODULE_NAME, BAS.PREFERENCE_NAME, BAS.PREFERENCE_VALUE FROM FND_USER_PREFERENCES BAS, JTM_FND_USER_PREFERENCES_ACC ACC WHERE BAS.USER_NAME = ASG_BASE.GET_USER_NAME AND ACC.USER_NAME = BAS.USER_NAME AND ACC.MODULE_NAME = BAS.MODULE_NAME AND ACC.PREFERENCE_NAME = BAS.PREFERENCE_NAME

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, BAS.USER_NAME
, BAS.MODULE_NAME
, BAS.PREFERENCE_NAME
, BAS.PREFERENCE_VALUE
FROM FND_USER_PREFERENCES BAS
, JTM_FND_USER_PREFERENCES_ACC ACC
WHERE BAS.USER_NAME = ASG_BASE.GET_USER_NAME
AND ACC.USER_NAME = BAS.USER_NAME
AND ACC.MODULE_NAME = BAS.MODULE_NAME
AND ACC.PREFERENCE_NAME = BAS.PREFERENCE_NAME