eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.FND_PROFILE_OPTIONS_VL

Object Details

Object Name:	FND_PROFILE_OPTIONS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_PROFILE_OPTIONS_VL
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.FND_PROFILE_OPTIONS_VL references the following:

APPS: FND_PROFILE_OPTIONS; FND_PROFILE_OPTIONS_TL

APPS.FND_PROFILE_OPTIONS_VL is referenced by following:

APPS: AHL_OSP_SHIPMENT_PUB - 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; FA_JP_TAX_EXTN_PVT - show dependent code; FND_CLIENT_INFO - show dependent code; FND_PROFILE_OPTIONS_PKG - show dependent code; GMF_SESSION_VARS - show dependent code; JTF_DEBUG_PUB - show dependent code; JTF_DIAGNOSTIC_COREAPI - show dependent code; LNS_BILLING_BATCH_PUB - 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; PAY_PYUCSLIS_PKG - show dependent code; PER_DATA_UPDATE_REPORT - show dependent code; PO_APPROVAL_REMINDER_SV - show dependent code; XLA_JE_VALIDATION_PKG - show dependent code