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 Hub
Key Columns
SOURCE_ORGANIZATION_ID, RELATED_ITEM_ORGANIZATION_ID, SOURCE_INVENTORY_ITEM_ID, RELATED_ITEM_ID, ITEM_RELATIONSHIP_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 |
| 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