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 Hub
Key Columns
ITEM_RELATIONSHIP_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
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