Oracle Fusion · Data dictionary
CSE_W_ENTITLEMENTS
SharedUsed in 1 subject areas26 reporting columns
Source object in the Oracle Fusion data model.
Primary key: not yet catalogued for CSE_W_ENTITLEMENTS, reference Oracle Tables & Views guide.
Joins (inferred from key columns): ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V · WORK_ORDER_ID → WIE_WORK_ORDERS_B · WO_OPERATION_ID → WIE_WO_OPERATIONS_B · WO_OPERATION_MATERIAL_ID → WIE_WO_OPERATION_MATERIALS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSET_ID | ● | Identifier for the asset. | |
| CLAIM_ID | ● | Identifier for the claim. | |
| CONTRACT_ID | ● | Identifier for the contract. | |
| CORP_CURRENCY_CODE | ● | Currency code for the corp. | |
| COST_TRANSACTION_ID | ● | Identifier for the cost transaction. | |
| CURCY_CONV_RATE_TYPE | ● | Type of curcy conv rate. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| ENTITLEMENT_DATE | ● | Entitlement date. | |
| ENTITLEMENT_DESCRIPTION | ● | Description of the entitlement. | |
| ENTITLEMENT_ID | ● | Identifier for the entitlement. | |
| ENTITLEMENT_NOTES | ● | Entitlement notes. | |
| ENTITLEMENT_NUMBER | ● | Entitlement number. | |
| ENTITLEMENT_TYPE_CODE | ● | Code identifying the entitlement type. | |
| EXTERNAL_REFERENCE_NUMBER | ● | External reference number. | |
| MANUALLY_CREATED_FLAG | ● | Indicator (Y/N) for the manually created. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| REIMBURSEMENT_CURRENCY_CODE | ● | Currency code for the reimbursement. | |
| REIMBURSEMENT_QTY | ● | Reimbursement quantity. | |
| REIMBURSEMENT_QTY_UOM_CODE | ● | Code identifying the reimbursement quantity unit of measure. | |
| REIMBURSEMENT_TOTAL_COST | ● | Reimbursement total cost. | |
| REIMBURSEMENT_UNIT_COST | ● | Reimbursement unit cost. | |
| WARRANTY_ENTITLED_FLAG | ● | Indicator (Y/N) for the warranty entitled. | |
| WORK_ORDER_ID | ● | Identifier for the work order. | |
| WO_OPERATION_ID | ● | Identifier for the wo operation. | |
| WO_OPERATION_MATERIAL_ID | ● | Identifier for the wo operation material. | |
| WO_OPERATION_RESOURCE_ID | ● | Identifier for the wo operation resource. |
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 CSE_W_ENTITLEMENTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table