[Home] [Help]
[Dependency Information]
| Object Name: | FND_PROFILE_OPTIONS_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | FND.FND_PROFILE_OPTIONS_VL
|
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
FND_PROFILE_OPTIONS_VL is a view that joins the translated,
language specific values from FND_PROFILE_OPTIONS_TL with the
non-displayed data from FND_PROFILE_OPTIONS to form complete
profile option entities. Oracle Application Object Library uses
this view to display information in languages installed at your
site.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row identifier | |
| APPLICATION_ID | NUMBER | Yes | Application identifier | |
| PROFILE_OPTION_ID | NUMBER | Yes | Profile option identifier | |
| PROFILE_OPTION_NAME | VARCHAR2 | (80) | Yes | Name of the profile option |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
| WRITE_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the profile option can be updated through user exits or forms |
| READ_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the profile option can be read through user exits or forms |
| USER_CHANGEABLE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if users can update the value for the profile option |
| USER_VISIBLE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the profile option value is visible to users |
| SITE_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the profile option is enabled at the site level |
| SITE_UPDATE_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the profile option should be updatable at the site level |
| APP_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the profile option is enabled at the application level |
| APP_UPDATE_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the profile option should be updatable at the application level |
| RESP_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the profile option is enabled at the responsibility level |
| RESP_UPDATE_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the profile option should be updatable at the responsibility level |
| USER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the profile option is enabled at the user level |
| USER_UPDATE_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the profile option should be updatable at the user level |
| START_DATE_ACTIVE | DATE | Yes | The date when the profile option becomes active | |
| SQL_VALIDATION | VARCHAR2 | (2000) | The validation criteria for QuickPick definition of profile option values | |
| END_DATE_ACTIVE | DATE | The date when the profile option expires | ||
| USER_PROFILE_OPTION_NAME | VARCHAR2 | (240) | Yes | Title of the profile option |
| HIERARCHY_TYPE | VARCHAR2 | (8) | ||
| SERVER_ENABLED_FLAG | VARCHAR2 | (1) | ||
| SERVER_UPDATE_ALLOWED_FLAG | VARCHAR2 | (1) | ||
| ORG_ENABLED_FLAG | VARCHAR2 | (1) | ||
| ORG_UPDATE_ALLOWED_FLAG | VARCHAR2 | (1) | ||
| SERVERRESP_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| SERVERRESP_UPDATE_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | |
| DESCRIPTION | VARCHAR2 | (240) | Description |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, APPLICATION_ID
, PROFILE_OPTION_ID
, PROFILE_OPTION_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WRITE_ALLOWED_FLAG
, READ_ALLOWED_FLAG
, USER_CHANGEABLE_FLAG
, USER_VISIBLE_FLAG
, SITE_ENABLED_FLAG
, SITE_UPDATE_ALLOWED_FLAG
, APP_ENABLED_FLAG
, APP_UPDATE_ALLOWED_FLAG
, RESP_ENABLED_FLAG
, RESP_UPDATE_ALLOWED_FLAG
, USER_ENABLED_FLAG
, USER_UPDATE_ALLOWED_FLAG
, START_DATE_ACTIVE
, SQL_VALIDATION
, END_DATE_ACTIVE
, USER_PROFILE_OPTION_NAME
, HIERARCHY_TYPE
, SERVER_ENABLED_FLAG
, SERVER_UPDATE_ALLOWED_FLAG
, ORG_ENABLED_FLAG
, ORG_UPDATE_ALLOWED_FLAG
, SERVERRESP_ENABLED_FLAG
, SERVERRESP_UPDATE_ALLOWED_FLAG
, DESCRIPTION
FROM APPS.FND_PROFILE_OPTIONS_VL;
APPS
FND_PROFILE_OPTIONS
FND_PROFILE_OPTIONS_TL
APPS
AHL_OSP_SHIPMENT_PUB
- show dependent code
AMW_CONTROLS_PAGE_PKG
- show dependent code
AR_INVOICE_DEFAULT_PVT
- show dependent code
ASO_ATP_INT
- show dependent code
ASO_DEF_UTIL
- show dependent code
ASO_RESERVATION_INT
- show dependent code
AS_SCORECARD_RULES_PVT
- show dependent code
CAC_SYNC_CONTACT_DQM_PVT
- show dependent code
CSP_PC_FORM_MTLTXNS
- show dependent code
CS_KNOWLEDGE_PVT
- show dependent code
ECE_PROFILE_OPTIONS
FND_CLIENT_INFO
- show dependent code
FND_PROFILE_OPTIONS_PKG
- show dependent code
GMF_SESSION_VARS
- show dependent code
HRI_BPL_SETUP_DIAGNOSTIC
- show dependent code
IGS_FI_BILL_EXTRACT
- show dependent code
ISC_DEPOT_BACKLOG_ETL_PKG
- show dependent code
JTF_DEBUG_PUB
- show dependent code
JTF_DIAGNOSTIC_COREAPI
- show dependent code
MSC_GET_PROFILE
- show dependent code
OKC_REPORT_PVT
- show dependent code
OKL_AM_BAL_WRITEOFF_PVT
- show dependent code
OKL_AM_UTIL_PVT
- show dependent code
OKL_AUTO_INSURANCE_PVT
- show dependent code
OKL_CONTRACT_PVT
- show dependent code
OKS_PROFILES_VISIBLE
- show dependent code
OKS_SETUPRPT_PVT
- show dependent code
ONT_DEF_UTIL
- show dependent code
OZF_REFRESH_SALES_PVT
- show dependent code
PER_DATA_UPDATE_REPORT
- show dependent code
PO_APPROVAL_REMINDER_SV
- show dependent code
XLA_JE_VALIDATION_PKG
- show dependent code
|
|
|
|