OKC_K_REL_OBJS
This component specifies the relationship between contract header or lines to other contracts defined in ECM. The relationship between one ECM contract and another is manually specified by the user. The relationship type between the contracts will be defined in a user extensible look up code in fnd_lookups where lookup_type = ???OKC_RELATIONSHIP_TYPE???.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
OKC_K_REL_OBJS_PK |
ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 18 | Yes | Primary key column. | |
| REL_OBJ_PUID | VARCHAR2 | 120 | Rel Obj PUID | ||
| CHR_ID | NUMBER | 18 | Yes | Id of the contract for which the relationship is defined. | |
| CLE_ID | NUMBER | 18 | If relationship is specified for a particular contract line, is null otherwise. This is only populated for OM originated contract lines. User specified relationships are always at the contract level, and this attribute is not used. | ||
| RTY_CODE | VARCHAR2 | 30 | Yes | Type of relationship. For OM relationships, seeded values are provided. For user defined relationships, users can add their own relationship types. For e.g., Ordered From (OM relationship), Referenced By (user relationship). | |
| JTOT_OBJECT1_CODE | VARCHAR2 | 30 | Yes | Identifies the source of the relationship, always hard coded. Order Header - OKX_ORDERHEAD Order Line ??? OKX_ORDERLINE User defined ??? OKX_ECMCONTRACT | |
| 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. | |
| 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. | ||
| OBJECT1_ID1 | NUMBER | 18 | Identifier1 of the related object in the source system. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| EXTERNAL_KEY1 | VARCHAR2 | 120 | External key that uniquely identifies a record. | ||
| EXTERNAL_KEY2 | VARCHAR2 | 120 | Additional attribute to qualify external key. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_CONTRACT_REL_OBJS_N1 | Non Unique | Default | CHR_ID |
| OKC_CONTRACT_REL_OBJS_N2 | Non Unique | Default | CLE_ID |
| OKC_CONTRACT_REL_OBJS_N4 | Non Unique | Default | OBJECT1_ID1 |
| OKC_CONTRACT_REL_OBJS_N5 | Non Unique | Default | RTY_CODE, JTOT_OBJECT1_CODE |
| OKC_CONTRACT_REL_OBJS_U2 | Unique | Default | EXTERNAL_KEY1, EXTERNAL_KEY2 |
| OKC_K_REL_OBJS_PK | Unique | Default | ID |
| OKC_K_REL_OBJS_U3 | Unique | Default | REL_OBJ_PUID |