Oracle Fusion · Data dictionary
VRM_FMV_LINES
SharedUsed in 2 subject areas40 reporting columns
Revenue Management (VRM), line table, one row per line item under the header.
Likely primary key: FMV_HEADER_ID, FMV_LINE_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AVERAGE_PRICE | ● | Average price. | |
| COMMENTS | ● | Comments. | |
| CORP_CURRENCY_FM_VALUE | ● | Corp currency fm value. | |
| COVERAGE_END_DATE | ● | Coverage end date. | |
| COVERAGE_START_DATE | ● | Coverage start date. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| ELEMENT_TYPE | ● | Type of element. | |
| ESTABLISHED_BY | ● | Established by. | |
| ESTABLISHED_DATE | ● | Established date. | |
| EXCEPTION_COMMENT | ● | Exception comment. | |
| EXCHANGE_DATE | ● | Exchange date. | |
| EXCHANGE_RATE | ● | Exchange rate. | |
| EXCHANGE_RATE_TYPE | ● | Type of exchange rate. | |
| FAIR_MARKET_VALUE | ● | Fair market value. | |
| FMV_HEADER_ID | PK? | ○ | Identifier for the fmv header. |
| FMV_LINE_ID | PK? | ● | Identifier for the fmv line. |
| FMV_TOLERANCE_HIGH_PCT | ● | Fmv tolerance high percent. | |
| FMV_TOLERANCE_LOW_PCT | ● | Fmv tolerance low percent. | |
| FMV_TYPE | ● | Type of fmv. | |
| HIGHEST_PRICE | ● | Highest price. | |
| ITEM_TYPE | ● | Type of item. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_COUNT | ● | Line count. | |
| LINE_SOURCE | ● | Line source. | |
| LOWEST_PRICE | ● | Lowest price. | |
| MANUALLY_ENTERED_FLAG | ● | Indicator (Y/N) for the manually entered. | |
| REVIEW_REASON | ● | Review reason. | |
| REVIEW_STATUS | ● | Status of the review. | |
| STANDARD_DEVIATION | ● | Standard deviation. | |
| TOLERANCE_COVERAGE | ● | Tolerance coverage. | |
| TOLERANCE_COVERAGE_COUNT | ● | Tolerance coverage count. | |
| TOLERANCE_PCT_RANGE_HIGH | ● | Tolerance percent range high. | |
| TOLERANCE_PCT_RANGE_LOW | ● | Tolerance percent range low. | |
| TOLERANCE_RANGE_COVERAGE | ● | Tolerance range coverage. | |
| TOTAL_AMOUNT | ● | Total amount. | |
| TOTAL_QUANTITY | ● | Total quantity. | |
| USED_IN_COMPLIANCE | ● | Used in compliance. | |
| VALUE_REASON | ● | Value reason. | |
| VSOE_VALUE_STATUS | ● | Status of the vsoe value. |
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.
- Revenue Management - Revenue Compliance Fair Market Value Real Time
- Revenue Management - Revenue Compliance MEA Carve-out Real Time
Need the extract + dbt staging for VRM_FMV_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table