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. You can't join across them in OTBI, the owned conformed model joins them on shared 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