Oracle Fusion · Data dictionary
CST_WO_DTL_COST_VARIANCES
CostingUsed in 1 subject areas16 reporting columns
Cost Management (CST).
Likely primary key: WO_DTL_COST_VARIANCE_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COST_DATE | ● | Cost date. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| OPERATION_SEQUENCE_NUM | ● | Operation sequence number. | |
| SCCR_SOURCE_TYPE_CODE | ● | Code identifying the sccr source type. | |
| SUBSTITUTION_FLAG | ● | Indicator (Y/N) for the substitution. | |
| TRANSACTION_TYPE | ● | Type of transaction. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| VARIANCE_COST | ● | Variance cost. | |
| VARIANCE_GROUP | ● | Variance group. | |
| VARIANCE_TYPE | ● | Type of variance. | |
| WD_MAKE_UNIT_COST | ● | Wd make unit cost. | |
| WD_SCALED_QTY | ● | Wd scaled quantity. | |
| WD_UNIT_COST | ● | Wd unit cost. | |
| WO_DTL_COST_VARIANCE_ID | PK? | ● | Identifier for the wo dtl cost variance. |
| WO_QUANTITY | ● | Wo quantity. | |
| WO_UNIT_COST | ● | Wo unit cost. |
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.
Need the extract + dbt staging for CST_WO_DTL_COST_VARIANCES?
We ship parameterized SQL, BICC config, and dbt models you own.