Oracle Fusion · Data dictionary
CMR_PURCHASE_ORDER_INFO_V
SharedUsed in 2 subject areas23 reporting columns
Channel Management / Rebates (CMR), denormalized view.
Primary key: not yet catalogued for CMR_PURCHASE_ORDER_INFO_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCRUE_ON_RECEIPT_FLAG | ● | Indicator (Y/N) for the accrue on receipt. | |
| CONV_FACTOR_TO_PRIMARY_UOM | ● | Conv factor to primary unit of measure. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| DESTINATION_TYPE_CODE | ● | Code identifying the destination type. | |
| EVENT_DATE | ● | Event date. | |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| MATCH_OPTION | ● | Match option. | |
| NEED_BY_DATE | ● | Need by date. | |
| NONRECOVERABLE_INCLUSIVE_TAX | ● | Nonrecoverable inclusive tax. | |
| NONRECOVERABLE_TAX | ● | Nonrecoverable tax. | |
| PO_CONVERSION_RATE | ● | Purchase order conversion rate. | |
| PO_SCHEDULE | ● | Purchase order schedule. | |
| PRICE | ● | Price. | |
| PROMISED_DATE | ● | Promised date. | |
| PTR_FLAG | ● | Indicator (Y/N) for the ptr. | |
| PURCHASE_BASIS | ● | Purchase basis. | |
| QUANTITY_ORDERED | ● | Quantity ordered. | |
| RECOVERABLE_INCLUSIVE_TAX | ● | Recoverable inclusive tax. | |
| RECOVERABLE_TAX | ● | Recoverable tax. | |
| SOURCE_DOCUMENT_LINE_NUMBER | ● | Source document line number. | |
| SOURCE_DOCUMENT_NUMBER | ● | Source document number. | |
| TAX_EXCLUSIVE_PRICE | ● | Tax exclusive price. | |
| 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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
Need the extract + dbt staging for CMR_PURCHASE_ORDER_INFO_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table