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_COLUMNS

Object Details

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

FND_COLUMNS stores information about individual columns in
application tables. Each row includes the actual column name
(COLUMN_NAME), the more descriptive title (USER_COLUMN_NAME), the
description of the column, the column size (WIDTH), numeric
precision (PRECISION), numeric scale (SCALE), the data type
(COLUMN_TYPE), and the default value applied to the column
when altering the column from nullable to not nullable
(DEFAULT_VALUE). Each row also contains values identifying the
flexfield that uses this table column and the value set that the
underlying flexfield segment uses, and information on whether
this column is used by flexfield in any way
(FLEXFIELD_USAGE_CODE). You need
at least one row for each column of each table in each
application. Oracle Application Object Library uses this
information for flexfield, AuditTrail, and for other purposes.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_COLUMNS_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID TABLE_ID COLUMN_ID
FND_COLUMNS_U2	NORMAL	UNIQUE	APPS_TS_SEED	COLUMN_NAME APPLICATION_ID TABLE_ID
FND_COLUMNS_U3	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID TABLE_ID USER_COLUMN_NAME
FND_COLUMNS_U4	NORMAL	UNIQUE	APPS_TS_SEED	COLUMN_SEQUENCE APPLICATION_ID TABLE_ID
FND_COLUMN_DESC	DOMAIN	NONUNIQUE		DESCRIPTION

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application that owns the table that owns this column. Foreign key to FND_TABLE.
TABLE_ID	NUMBER	(15)	Yes	Table to which column belongs. Foreign key to FND_TABLES.
COLUMN_ID	NUMBER	(15)	Yes	Column identifier.
COLUMN_NAME	VARCHAR2	(30)	Yes	Actual database column name
USER_COLUMN_NAME	VARCHAR2	(80)	Yes	Name for column that is meaningful to users
COLUMN_SEQUENCE	NUMBER	(15)	Yes	Sequence number. Indicates order of columns in created table.
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
COLUMN_TYPE	VARCHAR2	(1)	Yes	Column datatype. D (Date), N (Number), V (Varchar), I (RowID), L (Long), X (Long Raw) are possible values.
WIDTH	NUMBER	(15)	Yes	Bytes of storage for column value
NULL_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Y/N flag: Are null values allowed?
TRANSLATE_FLAG	VARCHAR2	(1)	Yes	Y/N flag: Is value translated?
FLEXFIELD_USAGE_CODE	VARCHAR2	(1)	Yes	Code that indicates how the column is used in flexfields. N (not used), K (key flexfield segment), D (descriptive flexfield attribute), Q (?), S (structure identifier), I (key flexfield identifier), and C (category) are possible values.
DESCRIPTION	VARCHAR2	(240)		Name of flexfield associated with this column
FLEXFIELD_APPLICATION_ID	NUMBER	(10)		Flexfield application identifier
FLEXFIELD_NAME	VARCHAR2	(30)		Flexfield name
FLEX_VALUE_SET_APPLICATION_ID	NUMBER	(10)		Flexfield value set application identifier
FLEX_VALUE_SET_ID	NUMBER	(10)		Flexfield value set identifier
DEFAULT_VALUE	VARCHAR2	(2000)		Default value for column, if any
PRECISION	NUMBER	(15)		Precision for column, if any
SCALE	NUMBER	(15)		Scale for column, if any
IREP_COMMENTS	VARCHAR2	(4000)		Comments from CASE

Query Text

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


SELECT APPLICATION_ID
,      TABLE_ID
,      COLUMN_ID
,      COLUMN_NAME
,      USER_COLUMN_NAME
,      COLUMN_SEQUENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COLUMN_TYPE
,      WIDTH
,      NULL_ALLOWED_FLAG
,      TRANSLATE_FLAG
,      FLEXFIELD_USAGE_CODE
,      DESCRIPTION
,      FLEXFIELD_APPLICATION_ID
,      FLEXFIELD_NAME
,      FLEX_VALUE_SET_APPLICATION_ID
,      FLEX_VALUE_SET_ID
,      DEFAULT_VALUE
,      PRECISION
,      SCALE
,      IREP_COMMENTS
FROM APPLSYS.FND_COLUMNS;

Dependencies

[top of page]

APPLSYS.FND_COLUMNS does not reference any database object

APPLSYS.FND_COLUMNS is referenced by following:

APPS: DR$FND_COLUMN_DESCTC; ETRM_FNDNAV - show dependent code; ETRM_RPT - show dependent code; FND_COLUMNS