# DW_ITEM_REL_RELATED_ITEMS_D (Preview)

This table requires activation of Item Management functional area. This table stores Related items relationship details.

## Details

Module: Product Model

## Key Columns

SOURCE_ORGANIZATION_ID, ITEM_RELATIONSHIP_ID, SOURCE_INVENTORY_ITEM_ID, RELATED_ITEM_ID, RELATED_ITEM_ORGANIZATION_ID

## Columns

Columns
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_INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | Source Inventory Item Identifier #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
SOURCE_ORGANIZATION_ID | NUMBER | 38 | 0 | True | Source Organization Identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
RELATED_ITEM_ID | NUMBER | 38 | 0 | True | Related Inventory Item Identifier #2 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
RELATED_ITEM_ORGANIZATION_ID | NUMBER | 38 | 0 | True | Related Organization Identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | This column is for Oracle Internal use only. Source Record Identifier |  |
RELATED_ITEM_RECIPROCAL_FLAG | VARCHAR2 | 16 |  |  | Related Item Reciprocal Flag |  |
RELATED_ITEM_PLANNING_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Related Item Planning Enabled Flag |  |
RELATED_ITEM_TYPE_CODE | VARCHAR2 | 32 |  |  | Related Item Type Code | DW_EGP_RELATIONSHIP_TYPES_LKP_TL | EGP_RELATIONSHIP_TYPES_CODE
RELATED_ITEM_ORG_INDEPENDENT_CODE | VARCHAR2 | 16 |  |  | Related Items Organization Independent Code | DW_ORA_EGP_REL_ITEM_CTRL_LVL_LKP_TL | ORA_EGP_REL_ITEM_CTRL_LVL_CODE
RELATED_ITEM_START_TIMESTAMP | TIMESTAMP |  |  |  | Related Item Start Timestamp |  |
RELATED_ITEM_END_TIMESTAMP | TIMESTAMP |  |  |  | Related Item End Timestamp |  |
RELATED_ITEM_RELATIONSHIP_RANK | NUMBER | 38 | 0 |  | Related Item Rank |  |
RELATED_ITEM_ACD_TYPE | VARCHAR2 | 32 |  |  | Related Item ACD Type |  |
RELATED_ITEM_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Related item Creation Timestamp |  |
RELATED_ITEM_LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Related item Last Update Timestamp |  |

## Notes

#1 In these cases to join with DW_INVENTORY_ITEM_D apart from SOURCE_INVENTORY_ITEM_ID the relationship should be based on SOURCE_ORGANIZATION_ID column

#2 In these cases to join with DW_INVENTORY_ITEM_D apart from RELATED_ITEM_ID the relationship should be based on RELATED_ITEM_ORGANIZATION_ID column

Copyright © 2019, 2026, Oracle and/or its affiliates.