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.ECE_PROFILE_OPTIONS

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

The ECE_PROFILE_OPTIONS view contains all the EC Profile Options and values.
The ECE_PROFILE_OPTIONS view is based on the data stored in FND_PROFILE_OPTIONS_VL and FND_PROFILE_OPTIONS_VALUES tables.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROFILE_OPTION_ID	NUMBER		Yes	Profile option identifier
APPLICATION_ID	NUMBER		Yes	Application identifier
PROFILE_OPTION_NAME	VARCHAR2	(80)	Yes	Name of the profile option
USER_PROFILE_OPTION_NAME	VARCHAR2	(240)	Yes	Title of the profile option
DESCRIPTION	VARCHAR2	(240)		Description
SQL_VALIDATION	VARCHAR2	(2000)		The validation criteria for retreiving profile option values
PROFILE_OPTION_VALUE	VARCHAR2	(240)		Value of the Profile Option
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
START_DATE_ACTIVE	DATE		Yes	The date when the profile option is active
END_DATE_ACTIVE	DATE			The date when the profile option expires
WRITE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if user can update the profile option.
READ_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if user can read the profile option
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROFILE_OPTION_ID
,      APPLICATION_ID
,      PROFILE_OPTION_NAME
,      USER_PROFILE_OPTION_NAME
,      DESCRIPTION
,      SQL_VALIDATION
,      PROFILE_OPTION_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      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
FROM APPS.ECE_PROFILE_OPTIONS;

Dependencies

[top of page]

APPS.ECE_PROFILE_OPTIONS references the following:

APPS: FND_PROFILE_OPTIONS_VL; FND_PROFILE_OPTION_VALUES

APPS.ECE_PROFILE_OPTIONS is not referenced by any database object