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

CMR_RCV_TRANSACTIONS

SharedUsed in 2 subject areas9 reporting columns

Channel Management / Rebates (CMR).

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

Columns

ColumnKeyIn reportsDescription (inferred)
DESTINATION_TYPE_CODECode identifying the destination type.
RECEIPT_LINE_NUMBERReceipt line number.
RECEIPT_NUMBERReceipt number.
SHIPMENT_LINE_NUMBERShipment line number.
SHIPMENT_NUMBERShipment number.
TRANSACTION_DATETransaction date.
TRANSACTION_QUANTITYTransaction quantity.
TRANSACTION_TYPEType of transaction.
TRANSACTION_UOM_CODECode identifying the transaction 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 CMR_RCV_TRANSACTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us