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_COMPILED_ID_FLEX_STRUCTS

Object Details

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

FND_COMPILED_ID_FLEX_STRUCTS stores compiled information about
key flexfield structures. Each row includes an application
identifier, a key flexfield code, and a key flexfield number
identifying a key flexfield structure. Each row also includes
the actual compiled definition of the key flexfield structure,
and a sequence that identifies the order of the compiled
definition if it takes more than one row to store the compiled
definition. You need at least one row for each key flexfield
structure that has been defined, frozen, and saved. Oracle
Application Object Library uses this information to display
and validate key flexfield pop-up windows.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_COMPILED_ID_FLEX_STRUCT_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM COMPILER_VERSION_NUM SEQUENCE LANGUAGE

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(10)	Yes	Application identifier
ID_FLEX_CODE	VARCHAR2	(4)	Yes	Key flexfield code
ID_FLEX_NUM	NUMBER	(10)	Yes	Key flexfield structure number
COMPILER_VERSION_NUM	NUMBER	(10)	Yes	compiler version number
SEQUENCE	NUMBER	(10)	Yes	Sequence of compiled key flexfield structure definition
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LANGUAGE	VARCHAR2	(30)		Language
COMPILED_DEFINITION	LONG	(0)	Yes	Compiled definition

Query Text

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


SELECT APPLICATION_ID
,      ID_FLEX_CODE
,      ID_FLEX_NUM
,      COMPILER_VERSION_NUM
,      SEQUENCE
,      CREATION_DATE
,      CREATED_BY
,      LANGUAGE
,      COMPILED_DEFINITION
FROM APPLSYS.FND_COMPILED_ID_FLEX_STRUCTS;

Dependencies

[top of page]

APPLSYS.FND_COMPILED_ID_FLEX_STRUCTS does not reference any database object

APPLSYS.FND_COMPILED_ID_FLEX_STRUCTS is referenced by following:

APPS: FND_COMPILED_ID_FLEX_STRUCTS