Oracle Fusion · Data dictionary
CST_INTR_ONHAND_VALUATIONS
CostingUsed in 1 subject areas17 reporting columns
Cost Management (CST).
Primary key: not yet catalogued for CST_INTR_ONHAND_VALUATIONS — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCTD_CMR_RCV_QUANTITY | ● | Acctd cmr receiving quantity. | |
| ACCTD_ONHAND_VALUE | ● | Acctd onhand value. | |
| CMR_RCV_QUANTITY | ● | Cmr receiving quantity. | |
| CONSIGNED_FLAG | ● | Indicator (Y/N) for the consigned. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| END_DATE | ● | End date. | |
| EXPENSE_TRANSACTION_FLAG | ● | Indicator (Y/N) for the expense transaction. | |
| ONHAND_VALUE | ● | Onhand value. | |
| PERIOD_NAME | ● | Name of the period. | |
| QUANTITY_ONHAND | ● | Quantity onhand. | |
| START_DATE | ● | Start date. | |
| TRANSACTION_FLOW_TYPE | ● | Type of transaction flow. | |
| TXN_SOURCE_DOC_NUMBER | ● | Transaction source doc number. | |
| TXN_SOURCE_DOC_TYPE | ● | Type of transaction source doc. | |
| TXN_SOURCE_REF_DOC_NUMBER | ● | Transaction source reference doc number. | |
| TXN_SOURCE_REF_DOC_TYPE | ● | Type of transaction source reference doc. | |
| 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_INTR_ONHAND_VALUATIONS?
We ship parameterized SQL, BICC config, and dbt models you own.