Oracle Fusion · Data dictionary
WIE_WO_OP_OUTPUT_DETAIL_V
SharedUsed in 3 subject areas13 reporting columns
Work in Process (WIE), denormalized view.
Primary key: not yet catalogued for WIE_WO_OP_OUTPUT_DETAIL_V, reference Oracle Tables & Views guide.
Joins (inferred from key columns): INVENTORY_ITEM_ID → INV_LICENSE_PLATE_NUMBERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BASIS_TYPE | ● | Type of basis. | |
| COMPLETED_QUANTITY | ● | Completed quantity. | |
| COMPLETION_TYPE | ● | Type of completion. | |
| COMPL_SUBINVENTORY_CODE | ● | Code identifying the compl subinventory. | |
| COST_ALLOCATION_PERCENTAGE | ● | Cost allocation percentage. | |
| INVENTORY_ITEM_ID | ● | Identifier for the inventory item. | |
| OUTPUT_QUANTITY | ● | Output quantity. | |
| OUTPUT_SEQ_NUMBER | ● | Output seq number. | |
| OUTPUT_TYPE | ● | Type of output. | |
| PRIMARY_FLAG | ● | Indicator (Y/N) for the primary. | |
| PRODUCT_YIELD | ● | Product yield. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| WO_OPERATION_OUTPUT_ID | ● | Identifier for the wo operation output. |
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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - Cost Accounting Real Time
- Costing - Work Order Costs Real Time
- Manufacturing - Actual Production Real Time
Need the extract + dbt staging for WIE_WO_OP_OUTPUT_DETAIL_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table