FND_EF_CATEGORY_CONTEXTS_BK

Details

  • Schema: CSM

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FND_EF_CATEGORY_CONTEXTS_BK_PK

APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_CODE, CONTEXT_CODE, CATEGORY_CODE, ENTERPRISE_ID, SANDBOX_ID, CUST_SET_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
SANDBOX_ID VARCHAR2 64 Yes SANDBOX_ID
APPLICATION_ID NUMBER 18 Yes APPLICATION_ID
DESCRIPTIVE_FLEXFIELD_CODE VARCHAR2 40 Yes DESCRIPTIVE_FLEXFIELD_CODE
CONTEXT_CODE VARCHAR2 80 Yes CONTEXT_CODE
CATEGORY_CODE VARCHAR2 800 Yes CATEGORY_CODE
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.
CUST_SET_ID VARCHAR2 300 Yes Customization Set ID

Indexes

Index Uniqueness Tablespace Columns
FND_EF_CATEGORY_CONTEXTS_BK_U1 Unique Default APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_CODE, CONTEXT_CODE, CATEGORY_CODE, ENTERPRISE_ID, SANDBOX_ID, CUST_SET_ID