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]

TABLE: APPLSYS.FND_LOV_CHOICE_VALUES

Object Details

Object Name:	FND_LOV_CHOICE_VALUES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_LOV_CHOICE_VALUES
Subobject Name:
Status:	VALID

Stores values for LOV Choice List. For a user (USER_ID) and an item (FULL_REF_NAME), a value is stored (VALUE_CODE) with a specific display sequence (VALUE_DISPLAY_SEQUENCE).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_LOV_CHOICE_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VALUE_SOURCE USER_ID FULL_REF_NAME VALUE_DISPLAY_SEQUENCE
FND_LOV_CHOICE_VALUES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	VALUE_SOURCE USER_ID FULL_REF_NAME VALUE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
VALUE_SOURCE	VARCHAR2	(20)	Yes	Identifies where the value came from. USER, SEED, SEEDCOPY
USER_ID	NUMBER	(15)	Yes	Identifies the user who chose the value. This value makes sense only when VALUE_SOURCE is USER or SEEDCOPY
FULL_REF_NAME	VARCHAR2	(255)	Yes	Identifies the item for which the value is saved
VALUE_DISPLAY_SEQUENCE	NUMBER	(15)	Yes	Display sequence of the value
VALUE_CODE	VARCHAR2	(30)	Yes	Code saved for the user, for the item
CREATED_BY	NUMBER	(15)	Yes	standard who column
CREATION_DATE	DATE		Yes	standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	standard who column
LAST_UPDATE_DATE	DATE		Yes	standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	standard who column

Query Text

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


SELECT VALUE_SOURCE
,      USER_ID
,      FULL_REF_NAME
,      VALUE_DISPLAY_SEQUENCE
,      VALUE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_LOV_CHOICE_VALUES;

Dependencies

[top of page]

APPLSYS.FND_LOV_CHOICE_VALUES does not reference any database object

APPLSYS.FND_LOV_CHOICE_VALUES is referenced by following:

APPS: FND_LOV_CHOICE_VALUES