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_LOOKUP_ASSIGNMENTS

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_LOOKUP_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOOKUP_ASSIGNMENT_ID
FND_LOOKUP_ASSIGNMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOOKUP_TYPE LOOKUP_CODE OBJ_NAME INSTANCE_PK1_VALUE INSTANCE_PK2_VALUE INSTANCE_PK3_VALUE INSTANCE_PK4_VALUE INSTANCE_PK5_VALUE
FND_LOOKUP_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJ_NAME INSTANCE_PK1_VALUE INSTANCE_PK2_VALUE INSTANCE_PK3_VALUE INSTANCE_PK4_VALUE INSTANCE_PK5_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
LOOKUP_ASSIGNMENT_ID	NUMBER		Yes	Primary key generated from FND_LOOKUP_ASSIGNMENTS_S
LOOKUP_TYPE	VARCHAR2	(30)	Yes	Lookup Type
LOOKUP_CODE	VARCHAR2	(30)	Yes	Lookup Value Code
OBJ_NAME	VARCHAR2	(30)	Yes	Object Id
INSTANCE_PK1_VALUE	VARCHAR2	(320)	Yes	Value of first Primary Key Column
INSTANCE_PK2_VALUE	VARCHAR2	(320)		Value of second Primary Key Column
INSTANCE_PK3_VALUE	VARCHAR2	(320)		Value of third Primary Key Column
INSTANCE_PK4_VALUE	VARCHAR2	(320)		Value of fourth Primary Key Column
INSTANCE_PK5_VALUE	VARCHAR2	(320)		Value of fifth Primary Key Column
DISPLAY_SEQUENCE	NUMBER	(15)
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)		Standard WHO Column

Query Text

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


SELECT LOOKUP_ASSIGNMENT_ID
,      LOOKUP_TYPE
,      LOOKUP_CODE
,      OBJ_NAME
,      INSTANCE_PK1_VALUE
,      INSTANCE_PK2_VALUE
,      INSTANCE_PK3_VALUE
,      INSTANCE_PK4_VALUE
,      INSTANCE_PK5_VALUE
,      DISPLAY_SEQUENCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_LOOKUP_ASSIGNMENTS;

Dependencies

[top of page]

APPLSYS.FND_LOOKUP_ASSIGNMENTS does not reference any database object

APPLSYS.FND_LOOKUP_ASSIGNMENTS is referenced by following:

APPS: FND_LOOKUP_ASSIGNMENTS