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: FA.FA_ASSET_KEYWORDS

Object Details

Object Name:	FA_ASSET_KEYWORDS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_ASSET_KEYWORDS
Subobject Name:
Status:	VALID

FA_ASSET_KEYWORDS stores valid asset key flexfield segment value
combinations.
.
Segment values are stored in the SEGMENT columns. The SEGMENT
columns which are used are not guaranteed to be in any order.
.
The Application Object Library table FND_ID_FLEX_SEGMENTS stores
information about which column in this table is used for each
segment.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_ASSET_KEYWORDS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
FA_ASSET_KEYWORDS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT1
FA_ASSET_KEYWORDS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT10
FA_ASSET_KEYWORDS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT2
FA_ASSET_KEYWORDS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT3
FA_ASSET_KEYWORDS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT4
FA_ASSET_KEYWORDS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT5
FA_ASSET_KEYWORDS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT6
FA_ASSET_KEYWORDS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT7
FA_ASSET_KEYWORDS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT8
FA_ASSET_KEYWORDS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT9

Columns

Name	Datatype	Length	Mandatory	Comments
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Key flexfield code combination identifier for asset key flexfield
SEGMENT1	VARCHAR2	(30)		Key flexfield segment
SEGMENT2	VARCHAR2	(30)		Key flexfield segment
SEGMENT3	VARCHAR2	(30)		Key flexfield segment
SEGMENT4	VARCHAR2	(30)		Key flexfield segment
SEGMENT5	VARCHAR2	(30)		Key flexfield segment
SEGMENT6	VARCHAR2	(30)		Key flexfield segment
SEGMENT7	VARCHAR2	(30)		Key flexfield segment
SEGMENT8	VARCHAR2	(30)		Key flexfield segment
SEGMENT9	VARCHAR2	(30)		Key flexfield segment
SEGMENT10	VARCHAR2	(30)		Key flexfield segment
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Used by Application Object Library for flexfield definition
ENABLED_FLAG	VARCHAR2	(1)	Yes	Indicates if key flexfield combination is currently valid
START_DATE_ACTIVE	DATE			Initial date the key flexfield combination is valid
END_DATE_ACTIVE	DATE			Last date the key flexfield combination is active
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	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 CODE_COMBINATION_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FA.FA_ASSET_KEYWORDS;

Dependencies

[top of page]

FA.FA_ASSET_KEYWORDS does not reference any database object

FA.FA_ASSET_KEYWORDS is referenced by following:

FA: FA_ASSET_KEYWORDS#