View: FND_PROFILE_OPTIONS_VL

Product:	FND - Application Object Library
Description:	View of FND_PROFILE_OPTIONS and FND_PROFILE_OPTIONS_TL
Implementation/DBA Data:	APPS.FND_PROFILE_OPTIONS_VL

View Text

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

Columns