Analytics Catalog/Data dictionary/CST_ALL_INTF_TRANSACTIONS_V
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

CST_ALL_INTF_TRANSACTIONS_V

CostingUsed in 1 subject areas11 reporting columns

Cost Management (CST) — denormalized view.

Primary key: not yet catalogued for CST_ALL_INTF_TRANSACTIONS_V — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
EXTERNAL_SYSTEM_REF_IDIdentifier for the external system reference.
LAST_UPDATED_BYUser who last updated the row.
LAST_UPDATE_DATEDate and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGINSession login of the user who last updated the row.
QUANTITYQuantity.
TRANSACTION_DATETransaction date.
TXN_SOURCE_DOC_NUMBERTransaction source doc number.
TXN_SOURCE_REF_DOC_NUMBERTransaction source reference doc number.
TXN_SOURCE_REF_DOC_TYPEType of transaction source reference doc.

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_ALL_INTF_TRANSACTIONS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us