This table requires activation of Item Management functional area. This table stores trading partner item relationship details.
Module: Product Model
ITEM_RELATIONSHIP_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ITEM_RELATIONSHIP_ID | NUMBER | 38 | 0 | True | Item Relationship Identifier | DW_ITEM_RELATIONSHIPS_D_TL | ITEM_RELATIONSHIP_ID |
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source Record Identifier | ||||
| ITEM_RELATIONSHIP_TYPE_CODE | VARCHAR2 | 32 | Item Relationship Type Code | DW_ORA_EGP_ITEM_RELATIONSHIP_TYPE_LKP_TL | ORA_EGP_ITEM_RELATIONSHIP_TYPE_CODE | ||
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Inventory Item Identifier | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| TRADING_PARTNER_ITEM_ID | NUMBER | 38 | 0 | Trading Partner Item Identifier | DW_TRADING_PARTNER_ITEMS_D | TRADING_PARTNER_ITEM_ID | |
| TRADING_PARTNER_RELATIONSHIP_CODE | VARCHAR2 | 32 | Trading Partner Relationship Type | DW_EGP_COMPETITOR_ITEM_XREF_LKP_TL | EGP_COMPETITOR_ITEM_XREF_CODE | ||
| TRADING_PARTNER_STATUS_CODE | VARCHAR2 | 32 | Trading Partner Status Code | DW_ORA_ACA_AML_STATUS_LKP_TL | ORA_ACA_AML_STATUS_CODE | ||
| TRADING_PARTNER_RANK | NUMBER | Trading Partner Rank | |||||
| TRADING_PARTNER_ACD_TYPE | VARCHAR2 | 32 | Trading Partner ACD Type | ||||
| TRADING_PARTNER_START_TIMESTAMP | TIMESTAMP | Trading Partner Start Timestamp | |||||
| TRADING_PARTNER_END_TIMESTAMP | TIMESTAMP | Trading Partner End Timestamp | |||||
| TRADING_PARTNER_CREATION_TIMESTAMP | TIMESTAMP | Trading Partner Creation Timestamp | |||||
| TRADING_PARTNER_LAST_UPDATE_TIMESTAMP | TIMESTAMP | Trading Partner item Last Update Timestamp |
Copyright © 2019, 2026, Oracle and/or its affiliates.