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

CMR_TRANSACTION_TYPES_VL

SharedUsed in 1 subject areas1 reporting columns

Channel Management / Rebates (CMR) — view layer — joins the base table with translations for the current language.

Likely primary key: TRANSACTION_TYPE_CODE (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

ColumnKeyIn reportsDescription (inferred)
TRANSACTION_TYPE_CODEPK?Code identifying the transaction type.
TRANSACTION_TYPE_NAMEName of the transaction type.

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