# DW_ITEM_REL_CROSS_REFERENCE_D (Preview)

This table requires activation of Item Management functional area. This table stores cross reference Item relationship details.

## Details

Module: Product Model

## Key Columns

ITEM_RELATIONSHIP_ID, ORGANIZATION_ID, INVENTORY_ITEM_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
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | Inventory Item Identifier #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ORGANIZATION_ID | NUMBER | 38 | 0 | True | Organization Identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source Record Identifier |  |
CROSS_REFERENCE_TYPE_CODE | VARCHAR2 | 32 |  |  | Cross Reference Item Relationship Type Code | DW_EGP_ITEM_XREF_TYPES_LKP_TL | EGP_ITEM_XREF_TYPES_CODE
CROSS_REFERENCE_ORG_INDEPENDENT_FLAG | VARCHAR2 | 16 |  |  | Organization Independent flag |  |
CROSS_REFERENCE_VALUE | VARCHAR2 | 512 |  |  | Cross Reference Value |  |
CROSS_REFERENCE_ACD_TYPE | VARCHAR2 | 32 |  |  | Cross Reference ACD Type |  |
CROSS_REFERENCE_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Cross reference Creation Timestamp |  |
CROSS_REFERENCE_LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Cross reference Last Update Timestamp |  |

## Notes

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

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