Oracle Fusion · Data dictionary
VRM_REV_LINE_CONTS_ALL
SharedUsed in 1 subject areas14 reporting columns
Revenue Management (VRM), transaction table (rows scoped across all operating units).
Primary key: not yet catalogued for VRM_REV_LINE_CONTS_ALL, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COMMENTS | ● | Comments. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DEFAULTED_IN_VRM_FLAG | ● | Indicator (Y/N) for the defaulted in vrm. | |
| EXPIRATION_DATE | ● | Expiration date. | |
| EXPIRATION_DAYS | ● | Expiration days. | |
| EXPIRATION_EVENT_DATE | ● | Expiration event date. | |
| EXPIRED_BY | ● | Expired by. | |
| EXPIRED_FLAG | ● | Indicator (Y/N) for the expired. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| OPTIONAL_REMOVAL_EVENT | ● | Optional removal event. | |
| PRIMARY_REMOVAL_EVENT | ● | Primary removal event. | |
| REASON_REMOVAL_DATE | ● | Reason removal date. |
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 VRM_REV_LINE_CONTS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table