Oracle Fusion · Data dictionary
EGP_TRADING_PARTNER_ITEMS
SharedUsed in 18 subject areas5 reporting columns
Product Hub / Items (EGP).
Primary key: not yet catalogued for EGP_TRADING_PARTNER_ITEMS — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AVERAGE_RATING_NUMBER | ● | Average rating number. | |
| TP_ITEM_DESC | ● | Description of the tp item. | |
| TP_ITEM_NUMBER | ● | Tp item number. | |
| TP_ITEM_UOM_CODE | ● | Code identifying the tp item unit of measure. | |
| TP_TYPE | ● | Type of tp. |
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.
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Inventory - Inventory Transfer Order Real Time
- Manufacturing - Work Order Performance Real Time
- Manufacturing - Workstation Supervision Real Time
- Product Management - Manufacturer 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_TRADING_PARTNER_ITEMS?
We ship parameterized SQL, BICC config, and dbt models you own.