Oracle Fusion · Data dictionary
SUS_ACTIVITIES_V
SharedUsed in 1 subject areas36 reporting columns
denormalized view.
Primary key: not yet catalogued for SUS_ACTIVITIES_V, reference Oracle Tables & Views guide.
Joins (inferred from key columns): INVOICE_ID → AP_INVOICES_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVITY_DATE | ● | Activity date. | |
| ACTIVITY_ID | ● | Identifier for the activity. | |
| ACTIVITY_NUMBER | ● | Activity number. | |
| ACTIVITY_TYPE_CODE | ● | Code identifying the activity type. | |
| ALERT_FLAG | ● | Indicator (Y/N) for the alert. | |
| CALCULATION_OVERRIDE | ● | Calculation override. | |
| CLASSIFCATION_CATEGORY | ● | Classifcation category. | |
| CLASSIFCATION_RULE_NAME | ● | Name of the classifcation rule. | |
| COMMENTS | ● | Comments. | |
| CONSUMPTION_END_DATE | ● | Consumption end date. | |
| CONSUMPTION_START_DATE | ● | Consumption start date. | |
| COUNTRY | ● | Country. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CREATION_DATE_TIME | ● | Creation date time. | |
| DATA_QUALITY | ● | Data quality. | |
| DESCRIPTION | ● | Description. | |
| ENTRY_TYPE | ● | Type of entry. | |
| EXTERNAL_REF_NUM | ● | External reference number. | |
| INVOICE_DISTRIBUTION_NUMBER | ● | Invoice distribution number. | |
| INVOICE_ID | ● | Identifier for the invoice. | |
| INVOICE_LINE_NUMBER | ● | Invoice line number. | |
| INVOICE_NUMBER | ● | Invoice number. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| ORIGINAL_ACTIVITY_NUMBER | ● | Original activity number. | |
| PERIOD_NAME | ● | Name of the period. | |
| POSTING_DATE_TIME | ● | Posting date time. | |
| SCOPE | ● | Scope. | |
| SCOPE_CATEGORY | ● | Scope category. | |
| SOURCE_TYPE | ● | Type of source. | |
| STATUS | ● | Status. | |
| STATUS_CODE | ● | Code identifying the status. | |
| TOTAL_CO2E | ● | Total co2e. | |
| TOTAL_CO2E_UOM_CODE | ● | Code identifying the total co2e unit of measure. | |
| TOTAL_CO2E_UOM_V | ● | Total co2e unit of measure v. |
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.
Need the extract + dbt staging for SUS_ACTIVITIES_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table