Oracle Fusion · Data dictionary
EGP_ITEM_RELATIONSHIPS_B
SharedUsed in 3 subject areas12 reporting columns
Product Hub / Items (EGP) — base table — language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: ITEM_RELATIONSHIP_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CROSS_REFERENCE | ● | Cross reference. | |
| DESCRIPTION | ● | Description. | |
| END_DATE_ACTIVE | ● | End date active. | |
| EPC_GTIN_SERIAL | ● | Epc gtin serial. | |
| INACTIVE_FLAG | ● | Indicator (Y/N) for the inactive. | |
| ITEM_RELATIONSHIP_ID | PK? | ● | Identifier for the item relationship. |
| ITEM_RELATIONSHIP_TYPE | ● | Type of item relationship. | |
| RECIPROCAL_FLAG | ● | Indicator (Y/N) for the reciprocal. | |
| SOURCE_SYSTEM_ID | ● | Identifier for the source system. | |
| START_DATE_ACTIVE | ● | Start date active. | |
| SUB_TYPE | ● | Type of sub. | |
| UOM_CODE | ● | Code identifying the unit of measure. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Product Management - Cross Reference Item Real Time
- Product Management - Related Item Real Time
- Product Management - Source System Item Real Time
Need the extract + dbt staging for EGP_ITEM_RELATIONSHIPS_B?
We ship parameterized SQL, BICC config, and dbt models you own.