Results for “nbv_retired”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_RETIREMENTS_WEB_V is a pre-built Oracle EBS view owned by the APPS schema within the Oracle Assets (OFA) product family. Its stated purpose, per the ETRM metadata, is to expose "asset retirement transaction information." It is defined over the FA_RETIREMENTS table and a supporting set of Assets and General Ledger objects, and is designed to present retirement data in a web-friendly, formatted form suitable for concurrent programs, self-service pages, and custom reporting.

The defining characteristic of this view is that it wraps every monetary column in a call to FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE, 30), converting numeric amounts into formatted character strings according to the book's currency. This makes the view ideal for presentation layers, since the caller need not apply currency formatting. Note that because the amount columns are returned as strings, they cannot be aggregated or compared numerically without an explicit TO_NUMBER conversion. This is a critical consideration for anyone searching on gain_loss_amount: in this view the column is a formatted string, not a numeric value.

Underlying Base Objects

The view is defined primarily over FA_RETIREMENTS (aliased RET), which supplies every column and the ROWID used as RET_ROWID. It joins to the following documented base objects:

• FA_RETIREMENTS — master source of retirement and gain/loss data.
• GL_SETS_OF_BOOKS (GLSB) — supplies CURRENCY_CODE for the formatting function.
• FND_CURRENCY — package providing SAFE_GET_FORMAT_MASK.
• FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, FA_ASSET_HISTORY, FA_TRANSACTION_HEADERS, FA_FISCAL_YEAR — supporting asset, book, and transaction context objects.

The primary relationship is one retirement row per asset/book combination in FA_RETIREMENTS, enriched with descriptive asset and book information. The currency context flows from the set of books associated with the retirement's book type.

Key Columns

All monetary columns are formatted via FND_CURRENCY. The most significant columns include:

• RETIREMENT_ID, ASSET_ID, BOOK_TYPE_CODE — keys identifying the retirement transaction, asset, and depreciation book.
• DATE_RETIRED, DATE_EFFECTIVE — retirement and accounting effective dates.
• COST_RETIRED, NBV_RETIRED — original cost and net book value removed, as formatted strings.
• GAIN_LOSS_AMOUNT — the gain or loss realized on retirement, formatted for display; paired with GAIN_LOSS_TYPE_CODE to distinguish gain from loss.
• PROCEEDS_OF_SALE, COST_OF_REMOVAL — sale proceeds and removal costs.
• RETIREMENT_TYPE_CODE, RETIREMENT_PRORATE_CONVENTION, UNITS — retirement method and proration.
• ITC_RECAPTURED, ITC_RECAPTURE_ID — investment tax credit recapture for applicable books.
• STL_METHOD_CODE, STL_LIFE_IN_MONTHS, STL_DEPRN_AMOUNT — short-term lease retirement details.
• STATUS, TRANSACTION_HEADER_ID_IN/OUT — transaction lifecycle references.
• ATTRIBUTE1–15, ATTRIBUTE_CATEGORY_CODE — descriptive flexfield support.

Common Use Cases and Queries

Typical uses include retirement audit reports, gain/loss analysis, and feeding self-service retirement pages. Because gain/loss is exposed as a formatted string, retrieve it directly for display, or convert it for computation.

List retirements with gain/loss (display form):

• SELECT retirement_id, asset_id, book_type_code, date_retired, nbv_retired, proceeds_of_sale, gain_loss_amount, gain_loss_type_code
• FROM apps.fa_retirements_web_v
• WHERE book_type_code = 'CORP'
• ORDER BY date_retired DESC;

Numerically aggregate gain/loss (requires conversion):

• SELECT book_type_code, SUM(TO_NUMBER(gain_loss_amount)) total_gl
• FROM apps.fa_retirements_web_v
• WHERE TRUNC(date_retired,'YYYY') = TRUNC(SYSDATE,'YYYY')
• GROUP BY book_type_code;

For heavy numeric processing, querying FA_RETIREMENTS directly is preferable; FA_RETIREMENTS_WEB_V is best reserved for presentation and reporting where currency-formatted output is desired. Joins back to FA_ADDITIONS on ASSET_ID yield asset descriptions for complete retirement reports.