Oracle Fusion · Data dictionary
CSE_W_CONTRACTS
SharedUsed in 10 subject areas10 reporting columns
Source object in the Oracle Fusion data model.
Primary key: not yet catalogued for CSE_W_CONTRACTS, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CALCULATED_EXPIRATION_DATE | ● | Calculated expiration date. | |
| CONTRACT_END_DATE | ● | Contract end date. | |
| CONTRACT_ID | ● | Identifier for the contract. | |
| CONTRACT_NOTES | ● | Contract notes. | |
| CONTRACT_NUMBER | ● | Contract number. | |
| CONTRACT_START_DATE | ● | Contract start date. | |
| CONTRACT_STATUS_CODE | ● | Code identifying the contract status. | |
| EXTERNAL_REFERENCE_NUMBER | ● | External reference number. | |
| OBJECT_ID | ● | Identifier for the object. | |
| OBJECT_TYPE_CODE | ● | Code identifying the object type. |
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.
- Maintenance Management - Asset Failure Analysis Real Time
- Maintenance Management - Asset History Real Time
- Maintenance Management - Asset Real Time
- Maintenance Management - Forecast Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Supplier Warranty - Asset Real Time
Need the extract + dbt staging for CSE_W_CONTRACTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table