Oracle Fusion · Data dictionary
EGP_ITEM_RELATIONSHIPS_B_V
SharedUsed in 14 subject areas23 reporting columns
Product Hub / Items (EGP), denormalized view.
Primary key: not yet catalogued for EGP_ITEM_RELATIONSHIPS_B_V, reference Oracle Tables & Views guide.
Joins (inferred from key columns): ITEM_RELATIONSHIP_ID → EGP_ITEM_RELATIONSHIPS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACD_TYPE | ● | Type of acd. | |
| CHANGE_LINE_ID | ● | Identifier for the change line. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CROSS_REFERENCE | ● | Cross reference. | |
| DESCRIPTION | ● | Description. | |
| END_DATE_ACTIVE | ● | End date active. | |
| EPC_GTIN_SERIAL | ● | Epc gtin serial. | |
| IMPLEMENTATION_DATE | ● | Implementation date. | |
| INACTIVE_FLAG | ● | Indicator (Y/N) for the inactive. | |
| ITEM_RELATIONSHIP_ID | ● | Identifier for the item relationship. | |
| ITEM_RELATIONSHIP_TYPE | ● | Type of item relationship. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| ORG_INDEPENDENT_FLAG | ● | Indicator (Y/N) for the organization independent. | |
| PLANNING_ENABLED_FLAG | ● | Indicator (Y/N) for the planning enabled. | |
| RECIPROCAL_FLAG | ● | Indicator (Y/N) for the reciprocal. | |
| RELATIONSHIP_RANK | ● | Relationship rank. | |
| SOURCE_SYSTEM_ID | ● | Identifier for the source system. | |
| START_DATE_ACTIVE | ● | Start date active. | |
| STATUS_CODE | ● | Code identifying the status. | |
| 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
- Product Management - Structures and Components Real Time
- Product Management - Trading Partner Item Real Time
- Product Management - Where Used Real Time
- Receiving - In-Transit Advanced Shipment Notifications Real Time
- Receiving - In-Transit Interorganization Inventory Transfers Real Time
- Receiving - In-Transit Shipments Real Time
- Receiving - Interorganization Receipts Real Time
- Receiving - Purchase Receipts Real Time
- Receiving - Receipts Real Time
- Receiving - Transactions Real Time
- Receiving - Unordered Receipts Real Time
Need the extract + dbt staging for EGP_ITEM_RELATIONSHIPS_B_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table