FND_SAVED_SEARCH_USER_DFLT
This table captures the current default saved search for a user. This value overrides any defaulting logic based on FND_SAVED_SEARCH_B data.
Details
-
Schema: SEARCH
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FND_SAVED_SEARCH_USER_D_PK |
USER_NAME, CONTEXT_CODE, OBJECT_TYPE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USER_NAME | VARCHAR2 | 2000 | Yes | USER_NAME - The user associated to the saved searches defaults | |
| CONTEXT_CODE | VARCHAR2 | 30 | Yes | CONTEXT_CODE - A striping attribute that keeps one set of saved searches distinct from another. Exampe: 'CRM', 'HCM'. | |
| OBJECT_TYPE | VARCHAR2 | 30 | Yes | OBJECT_TYPE - a sub classification of CONTEXT_CODE for striping saved searches. | |
| SAVED_SEARCH_ID | NUMBER | 18 | Yes | SAVED_SEARCH_ID - unique id for saved search | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SAVED_SEARCH_U_D_U1 | Unique | Default | USER_NAME, CONTEXT_CODE, OBJECT_TYPE |