VIEW: APPS.FND_PROFILE_OPTIONS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.APPLICATION_ID , B.PROFILE_OPTION_ID , B.PROFILE_OPTION_NAME , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , B.WRITE_ALLOWED_FLAG , B.READ_ALLOWED_FLAG , B.USER_CHANGEABLE_FLAG , B.USER_VISIBLE_FLAG , B.SITE_ENABLED_FLAG , B.SITE_UPDATE_ALLOWED_FLAG , B.APP_ENABLED_FLAG , B.APP_UPDATE_ALLOWED_FLAG , B.RESP_ENABLED_FLAG , B.RESP_UPDATE_ALLOWED_FLAG , B.USER_ENABLED_FLAG , B.USER_UPDATE_ALLOWED_FLAG , B.START_DATE_ACTIVE , B.SQL_VALIDATION , B.END_DATE_ACTIVE , T.USER_PROFILE_OPTION_NAME , B.HIERARCHY_TYPE , B.SERVER_ENABLED_FLAG , B.SERVER_UPDATE_ALLOWED_FLAG , B.ORG_ENABLED_FLAG , B.ORG_UPDATE_ALLOWED_FLAG ,B.SERVERRESP_ENABLED_FLAG ,B.SERVERRESP_UPDATE_ALLOWED_FLAG , T.DESCRIPTION DESCRIPTION FROM FND_PROFILE_OPTIONS_TL T, FND_PROFILE_OPTIONS B WHERE B.PROFILE_OPTION_NAME = T.PROFILE_OPTION_NAME AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID
, B.PROFILE_OPTION_ID
, B.PROFILE_OPTION_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.WRITE_ALLOWED_FLAG
, B.READ_ALLOWED_FLAG
, B.USER_CHANGEABLE_FLAG
, B.USER_VISIBLE_FLAG
, B.SITE_ENABLED_FLAG
, B.SITE_UPDATE_ALLOWED_FLAG
, B.APP_ENABLED_FLAG
, B.APP_UPDATE_ALLOWED_FLAG
, B.RESP_ENABLED_FLAG
, B.RESP_UPDATE_ALLOWED_FLAG
, B.USER_ENABLED_FLAG
, B.USER_UPDATE_ALLOWED_FLAG
, B.START_DATE_ACTIVE
, B.SQL_VALIDATION
, B.END_DATE_ACTIVE
, T.USER_PROFILE_OPTION_NAME
, B.HIERARCHY_TYPE
, B.SERVER_ENABLED_FLAG
, B.SERVER_UPDATE_ALLOWED_FLAG
, B.ORG_ENABLED_FLAG
, B.ORG_UPDATE_ALLOWED_FLAG
, B.SERVERRESP_ENABLED_FLAG
, B.SERVERRESP_UPDATE_ALLOWED_FLAG
, T.DESCRIPTION DESCRIPTION
FROM FND_PROFILE_OPTIONS_TL T
, FND_PROFILE_OPTIONS B
WHERE B.PROFILE_OPTION_NAME = T.PROFILE_OPTION_NAME
AND T.LANGUAGE = USERENV('LANG')