FND_DBRM_DETAILS
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Comments |
|---|---|---|---|
| PLAN | VARCHAR2 | 128 | PLAN |
| CONSUMER_GROUP | VARCHAR2 | 128 | CONSUMER_GROUP |
| PARAMETER | VARCHAR2 | 128 | PARAMETER |
| VALUE | VARCHAR2 | 256 | VALUE |
| ACTIVE_FLAG | VARCHAR2 | 1 | ACTIVE_FLAG |
| EXPIRE_DATE | DATE | EXPIRE_DATE | |
| CREATE_DTL | VARCHAR2 | 512 | CREATE_DTL |
| CREATION_DATE | TIMESTAMP | This is for PSR usage, not a who column. | |
| LAST_UPDATE_DTL | VARCHAR2 | 512 | LAST_UPDATE_DTL |
| LAST_UPDATE_DATE | TIMESTAMP | This is for PSR usage, not a who column. | |
| TEXT | VARCHAR2 | 4000 | TEXT |
| EXT_CHAR_01 | VARCHAR2 | 4000 | EXT_CHR_01 |
| EXT_CLOB_01 | CLOB | EXT_CLOB_01 | |
| EXT_NUM_01 | NUMBER | EXT_NUM_01 | |
| EXT_DT_01 | DATE | EXT_DT_01 |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_DBRM_DETAILS_N1 | Non Unique | FND_DBRM_DETAILS_N1 | PLAN, CONSUMER_GROUP, PARAMETER, ACTIVE_FLAG |
| FND_DBRM_DETAILS_N2 | Non Unique | FND_DBRM_DETAILS_N2 | ACTIVE_FLAG |
| FND_DBRM_DETAILS_N3 | Non Unique | FND_DBRM_DETAILS_N3 | "LAST_UPDATE_DTL" |