VIEW: APPS.IEX_APP_PREFERENCES_VL

Source

View Text - Preformatted

SELECT B.PREFERENCE_ID PREFERENCE_ID ,B.PREFERENCE_NAME PREFERENCE_NAME ,TL.USER_NAME USER_NAME ,B.PREFERENCE_VALUE PREFERENCE_VALUE ,B.ENABLED_FLAG ENABLED_FLAG ,B.CREATED_BY CREATED_BY ,B.CREATION_DATE CREATION_DATE ,B.LAST_UPDATE_DATE LAST_UPDATE_DATE ,B.LAST_UPDATED_BY LAST_UPDATED_BY ,B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,B.REQUEST_ID REQUEST_ID ,B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID ,B.PROGRAM_ID PROGRAM_ID ,B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE FROM IEX_APP_PREFERENCES_B B, IEX_APP_PREFERENCES_TL TL WHERE B.PREFERENCE_id = TL.PREFERENCE_id and TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.PREFERENCE_ID PREFERENCE_ID
, B.PREFERENCE_NAME PREFERENCE_NAME
, TL.USER_NAME USER_NAME
, B.PREFERENCE_VALUE PREFERENCE_VALUE
, B.ENABLED_FLAG ENABLED_FLAG
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, B.REQUEST_ID REQUEST_ID
, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, B.PROGRAM_ID PROGRAM_ID
, B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM IEX_APP_PREFERENCES_B B
, IEX_APP_PREFERENCES_TL TL
WHERE B.PREFERENCE_ID = TL.PREFERENCE_ID
AND TL.LANGUAGE = USERENV('LANG')