1. Tables and Views for Common Features
  2. FND_PROFILE_OPTIONS_VL

FND_PROFILE_OPTIONS_VL

Details

  • Schema: PROFILES

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

MODULE_ID

APPLICATION_ID

PROFILE_OPTION_ID

PROFILE_OPTION_NAME

USER_PROFILE_OPTION_NAME

HIERARCHY_NAME

USER_ENABLED_FLAG

USER_UPDATEABLE_FLAG

SQL_VALIDATION

START_DATE_ACTIVE

END_DATE_ACTIVE

DESCRIPTION

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ROWID ROW_ID,

B.MODULE_ID,

B.APPLICATION_ID,

B.PROFILE_OPTION_ID ,

B.PROFILE_OPTION_NAME,

T.USER_PROFILE_OPTION_NAME,

B.HIERARCHY_NAME , B.USER_ENABLED_FLAG,

B.USER_UPDATEABLE_FLAG,

B.SQL_VALIDATION,

B.START_DATE_ACTIVE,

B.END_DATE_ACTIVE,

T.DESCRIPTION DESCRIPTION,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN

FROM FND_PROFILE_OPTIONS_TL T, FND_PROFILE_OPTIONS_B B WHERE B.PROFILE_OPTION_NAME = T.PROFILE_OPTION_NAME

AND T.LANGUAGE = USERENV('LANG')