Analytics Catalog/Data dictionary/CST_INTR_ONHAND_VALUATIONS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
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

ColumnKeyIn reportsDescription (inferred)
ACCTD_CMR_RCV_QUANTITYAcctd cmr receiving quantity.
ACCTD_ONHAND_VALUEAcctd onhand value.
CMR_RCV_QUANTITYCmr receiving quantity.
CONSIGNED_FLAGIndicator (Y/N) for the consigned.
CURRENCY_CODECode identifying the currency.
END_DATEEnd date.
EXPENSE_TRANSACTION_FLAGIndicator (Y/N) for the expense transaction.
ONHAND_VALUEOnhand value.
PERIOD_NAMEName of the period.
QUANTITY_ONHANDQuantity onhand.
START_DATEStart date.
TRANSACTION_FLOW_TYPEType of transaction flow.
TXN_SOURCE_DOC_NUMBERTransaction source doc number.
TXN_SOURCE_DOC_TYPEType of transaction source doc.
TXN_SOURCE_REF_DOC_NUMBERTransaction source reference doc number.
TXN_SOURCE_REF_DOC_TYPEType of transaction source reference doc.
UOM_CODECode 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.
Talk to us
Problems that run through this table
Inventory as of any date · What the extract does not carry · The export ceiling