[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

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

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:

APPS

FA_ASSET_KEYWORDS