FA_ASSET_KEYWORDS
FA_ASSET_KEYWORDS contains valid asset key flexfield segment value combinations. Segment values are stored in the SEGMENT columns. The SEGMENT columns which are used may not 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. .
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
FA_ASSET_KEYWORDS_PK |
CODE_COMBINATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Identifier of the asset key code combinations. | |
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Yes | Structure Instance for a particular Flexfield Structure. | |
| SEGMENT1 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT2 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT3 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT4 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT5 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT6 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT7 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT8 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT9 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT10 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SUMMARY_FLAG | VARCHAR2 | 1 | Yes | Used by Application Object Library for flexfield definition. | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Option indicating whether the asset keyword is active or not. | |
| START_DATE_ACTIVE | DATE | Date when the asset keyword became active. | |||
| END_DATE_ACTIVE | DATE | Date when the asset keyword became inactive. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| fa_additions_b | fa_asset_keywords | ASSET_KEY_CCID |
| fa_mass_retirements | fa_asset_keywords | ASSET_KEY_ID |
| fa_mass_changes | fa_asset_keywords | ASSET_KEY_ID |
| fa_mass_additions | fa_asset_keywords | ASSET_KEY_CCID |
| fa_mass_transfers | fa_asset_keywords | ASSET_KEY_ID |
| fa_mass_reclass | fa_asset_keywords | ASSET_KEY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_ASSET_KEYWORDS_N1 | Non Unique | Default | SEGMENT1 |
| FA_ASSET_KEYWORDS_N10 | Non Unique | Default | SEGMENT10 |
| FA_ASSET_KEYWORDS_N2 | Non Unique | Default | SEGMENT2 |
| FA_ASSET_KEYWORDS_N3 | Non Unique | Default | SEGMENT3 |
| FA_ASSET_KEYWORDS_N4 | Non Unique | Default | SEGMENT4 |
| FA_ASSET_KEYWORDS_N5 | Non Unique | Default | SEGMENT5 |
| FA_ASSET_KEYWORDS_N6 | Non Unique | Default | SEGMENT6 |
| FA_ASSET_KEYWORDS_N7 | Non Unique | Default | SEGMENT7 |
| FA_ASSET_KEYWORDS_N8 | Non Unique | Default | SEGMENT8 |
| FA_ASSET_KEYWORDS_N9 | Non Unique | Default | SEGMENT9 |
| FA_ASSET_KEYWORDS_U1 | Unique | Default | CODE_COMBINATION_ID |