Oracle Fusion · Data dictionary
FA_ASSET_RETIREMENTS_V
Fixed AssetsUsed in 1 subject areas15 reporting columns
Fixed Assets (FA) — denormalized view.
Primary key: not yet catalogued for FA_ASSET_RETIREMENTS_V — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| GAIN_LOSS_TYPE_CODE | ● | Code identifying the gain loss type. | |
| RECOGNIZE_GAIN_LOSS | ● | Recognize gain loss. | |
| REFERENCE_NUM | ● | Reference number. | |
| RETIREMENT_ID | ● | Identifier for the retirement. | |
| RETIREMENT_TYPE_CODE | ● | Code identifying the retirement type. | |
| SOLD_TO | ● | Sold to. | |
| STATUS | ● | Status. | |
| STL_DEPRN_AMOUNT | ● | Stl deprn amount. | |
| TRANSACTION_HEADER_ID | ● | Identifier for the transaction header. | |
| TRANSACTION_HEADER_ID_OUT | ● | Transaction header id out. | |
| TRANSACTION_KEY | ● | Transaction key. | |
| TRANSACTION_NAME | ● | Name of the transaction. | |
| TRANSACTION_SUBTYPE | ● | Transaction subtype. | |
| TRANSACTION_TYPE_CODE | ● | Code identifying the transaction type. | |
| UNITS | ● | Units. |
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 FA_ASSET_RETIREMENTS_V?
We ship parameterized SQL, BICC config, and dbt models you own.