Oracle Fusion · Data dictionary
CST_STD_COSTS
CostingUsed in 1 subject areas13 reporting columns
Cost Management (CST).
Likely primary key: STD_COST_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COST_TYPE | ● | Type of cost. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | ● | Start date of the effective-dated record. | |
| FROM_PERIOD_NAME | ● | Name of the from period. | |
| LAST_USED_DATE | ● | Last used date. | |
| STAGED_FOR_STD_COST_ADJ_FLAG | ● | Indicator (Y/N) for the staged for std cost adj. | |
| STATUS_CODE | ● | Code identifying the status. | |
| STD_COST_ADJUST_ID | ● | Identifier for the std cost adjust. | |
| STD_COST_ID | PK? | ● | Identifier for the std cost. |
| TOTAL_COST | ● | Total cost. | |
| TO_PERIOD_NAME | ● | Name of the to period. | |
| 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.
Need the extract + dbt staging for CST_STD_COSTS?
We ship parameterized SQL, BICC config, and dbt models you own.