Results for “salvage_value”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FA_ASSET_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Assets (OFA) product family. It is classified in ETRM as providing "asset identification and financial information," and it serves as a consolidated reporting and integration interface for fixed asset records across identification attributes and book-level financial attributes. In EBS 12.1.1 and 12.2.2 the object is documented with status VALID and is defined over four synonym references in APPS, making it suitable for custom reports, discoverer workbooks, concurrent program extracts, and inbound/outbound interface queri es where a single flattened row per asset per book is required. Because the view embeds business filters, it returns only a constrained slice of the underlying asset population, which is an important consideration for any integration expecting exhaustive asset data.
Underlying Base Objects
The documented base objects are FA_ADDITIONS (SYNONYM), FA_BOOKS (SYNONYM), FA_BOOK_CONTROLS (SYNONYM), and FA_CATEGORIES_B (SYNONYM), all resolving to the APPS tables FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, and FA_CATEGORIES_B. The view text joins FA_ADDITIONS AD to FA_BOOKS BK on ASSET_ID, then to FA_BOOK_CONTROLS BC on BOOK_TYPE_CODE, and to FA_CATEGORIES_B CA on ASSET_CATEGORY_ID. Three joins are therefore mandatory: an asset must have a corresponding FA_BOOKS row, a matching FA_BOOK_CONTROLS row, and a valid category row.
Two predicates materially restrict the result set. First, BC.BOOK_CLASS = 'CORPORATE' limits output to book controls whose book class is the seeded CORPORATE value, so tax and other non-corporate books are excluded. Second, BK.PERIOD_COUNTER_FULLY_RETIRED IS NULL and BK.DATE_INEFFECTIVE IS NULL exclude assets that are fully retired or whose book assignment has been made ineffective. The view is consequently a "live corporate book" asset listing rather than a complete historical asset register.
Key Columns
The view exposes sixteen columns. Identification columns include ASSET_NUMBER (the user-facing asset number), TAG_NUMBER, DESCRIPTION, MANUFACTURER_NAME, SERIAL_NUMBER, and MODEL_NUMBER, all sourced from FA_ADDITIONS. Category columns are MAJOR_CATEGORY, mapped from FA_CATEGORIES_B.SEGMENT1, and SUB_CATEGORY, mapped from FA_CATEGORIES_B.SEGMENT2. This is the column most often located through keyword searches such as "sub_category," and it is important to note that the view text carries a /* CUSTOMIZE */ comment on both category columns, indicating they are intended as customer-extensible mappings rather than strictly fixed semantics. Financial and depreciation columns come from FA_BOOKS: BOOK_TYPE_CODE, DATE_PLACED_IN_SERVICE, DEPRN_METHOD_CODE, LIFE_IN_MONTHS, COST, SALVAGE_VALUE, ADJUSTED_RATE, and PRODUCTION_CAPACITY.
Common Use Cases and Queries
Typical uses include corporate book asset listings, category-based cost reporting, reconciliation of depreciation attributes, and extracts feeding downstream asset systems. Because SUB_CATEGORY is derived from SEGMENT2 of the category key flexfield, queries filtering on sub-category must account for the site's flexfield segment definition.
- List corporate book assets with category breakdown: SELECT asset_number, tag_number, major_category, sub_category, book_type_code, cost FROM apps.fa_asset_v WHERE sub_category = 'COMPUTERS';
- Depreciation review: SELECT asset_number, deprn_method_code, life_in_months, adjusted_rate FROM apps.fa_asset_v WHERE book_type_code = 'CORP';
- Identification extract: SELECT asset_number, tag_number, serial_number, manufacturer_name, model_number FROM apps.fa_asset_v ORDER BY asset_number;
- Cost and salvage analysis: SELECT major_category, SUM(cost), SUM(salvage_value) FROM apps.fa_asset_v GROUP BY major_category;
Users requiring retired assets, non-corporate books, or assets lacking book controls must query the base tables directly, since the view's filters preclude those rows.
-
View: FA_ASSET_V 12.1.1
Asset identification and financial information
APPS.FA_ASSET_V·↳ FA_ADDITIONS·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·Explore OFA module →
-
View: FA_ASSET_V 12.2.2
Asset identification and financial information
APPS.FA_ASSET_V·↳ FA_ADDITIONS·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·Explore OFA module →
-
View: OKL_SPLIT_ASSET_TRX_UV 12.1.1
User interface view for Split Asset Data Object
APPS.OKL_SPLIT_ASSET_TRX_UV·↳ MTL_SYSTEM_ITEMS_B·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·Explore OKL module →
-
View: OKL_SPLIT_ASSET_TRX_UV 12.2.2
User interface view for Split Asset Data Object
APPS.OKL_SPLIT_ASSET_TRX_UV·↳ MTL_SYSTEM_ITEMS_B·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·Explore OKL module →
-
Asset transaction history in a given book
APPS.FA_TRANS_HIST_BOOKS_WEB_V·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·↳ FA_LOOKUPS·Explore OFA module →
-
- Retrofitted
APPS.FA_TRANSACTION_HISTORY_BOOKS_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OFA module →
-
View: FA_ASSET_INVOICES_V 12.2.2
Business view of asset identification, financial, and purchasing information
APPS.FA_ASSET_INVOICES_V·↳ FA_ADDITIONS·↳ FA_ASSET_INVOICES·↳ FA_BOOKS·Explore OFA module →
-
View: FA_SXL_BOOKS_V 12.2.2
-
View: FA_SXL_BOOKS_V 12.1.1
-
- Retrofitted
APPS.JA_AU_ADDITIONS_BOOKS_V·↳ FA_ADDITIONS·↳ FA_BOOKS·↳ FA_RETIREMENTS·Explore JA module →
-
View: OKL_LA_BOOK_DEPRN_UV 12.1.1
User interface view for asset book depreciation page
APPS.OKL_LA_BOOK_DEPRN_UV·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·↳ OKL_TXL_ASSETS_B·Explore OKL module →
-
View: OKX_AST_BKS_V 12.2.2
This view retrieves details of all the assets in all the books fro Oracle Fixed Assets.
APPS.OKX_AST_BKS_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKX module →
-
View: OKL_ASSET_DEPRN_UV 12.1.1
APPS.OKL_ASSET_DEPRN_UV·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKL module →
-
View: OKL_LA_BOOK_DEPRN_UV 12.2.2
User interface view for asset book depreciation page
APPS.OKL_LA_BOOK_DEPRN_UV·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·↳ OKL_TXL_ASSETS_B·Explore OKL module →
-
APPS.OKL_AM_ASSET_DETAILS_UV·↳ FA_CATEGORIES_VL·↳ OKC_K_HEADERS_B·↳ OKC_LINE_STYLES_V·Explore OKL module →
-
APPS.OKL_AM_ASSET_DETAILS_CHR_UV·↳ FA_CATEGORIES_VL·↳ OKC_K_HEADERS_B·↳ OKC_LINE_STYLES_V·Explore OKL module →
-
APPS.OKL_AM_ASSET_DETAILS_CHR_UV·↳ FA_CATEGORIES_VL·↳ OKC_K_HEADERS_B·↳ OKC_LINE_STYLES_V·Explore OKL module →
-
APPS.OKL_AM_OFF_LEASE_TRX_UV·↳ FA_BOOK_CONTROLS·↳ FA_CATEGORIES_VL·↳ FA_METHODS·Explore OKL module →
-
OKL_LINE_KIND_EXCHANGE_V will retrieve data necessary for performing Like Kind Exchange.
APPS.OKL_LIKE_KIND_EXCHANGE_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKL module →
-
APPS.OKL_AM_ASSET_DETAILS_UV·↳ FA_CATEGORIES_VL·↳ OKC_K_HEADERS_B·↳ OKC_LINE_STYLES_V·Explore OKL module →
-
View: OKL_ASSET_DEPRN_UV 12.2.2
APPS.OKL_ASSET_DEPRN_UV·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKL module →
-
View: FA_ASSET_INVOICES_V 12.1.1
Business view of asset identification, financial, and purchasing information
APPS.FA_ASSET_INVOICES_V·↳ FA_ADDITIONS·↳ FA_ASSET_INVOICES·↳ FA_BOOKS·Explore OFA module →
-
- Retrofitted
APPS.FA_BOOKS_BOOK_CONTROLS_V·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·Explore OFA module →
-
Asset financial information in a given depreciation book
APPS.FA_BOOKS_BK_CNTRL_WEB_V·↳ FA_ADDITIONS_B·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·Explore OFA module →
-
Asset financial information in a given depreciation book
APPS.FA_BOOKS_BK_CNTRL_WEB_V·↳ FA_ADDITIONS_B·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·Explore OFA module →
-
- Retrofitted
APPS.JA_AU_ADDITIONS_ALLOCATIONS_V·↳ FA_ADDITIONS·↳ FA_BOOKS·↳ JA_AU_BAL_CHG_APPLIED·Explore JA module →
-
View: FABV_ASSET_BKS 12.2.2
- Retrofitted
-
APPS.OKL_AM_SALVAGE_VALUE_WD_UV·↳ FA_BOOK_CONTROLS·↳ FA_CATEGORIES_VL·↳ OKC_K_ITEMS·Explore OKL module →
-
- Retrofitted
APPS.JA_AU_ADDITIONS_ALLOCATIONS_V·↳ FA_ADDITIONS·↳ FA_BOOKS·↳ JA_AU_BAL_CHG_APPLIED·Explore JA module →
-
- Retrofitted
APPS.FA_BOOKS_BOOK_CONTROLS_V·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·↳ FA_MC_BOOKS·Explore OFA module →
-
Tax Book Interface table
-
View: FA_QUICK_BOOKS_V 12.1.1
- Retrofitted
APPS.FA_QUICK_BOOKS_V·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·Explore OFA module →
-
APPS.OKL_AM_SALVAGE_VALUE_WD_UV·↳ FA_BOOK_CONTROLS·↳ FA_CATEGORIES_VL·↳ OKC_K_ITEMS·Explore OKL module →
-
This table stores financial and depreciation information at the asset level.
-
FA_ADJUSTMENTS_T is a temporary table used during processing of impairment transaction and Extended Depreciation.
-
View: JA_AU_FA_ADD_ADJ_V 12.1.1
- Retrofitted
APPS.JA_AU_FA_ADD_ADJ_V·↳ FA_ADDITIONS·↳ FA_BOOKS·↳ JA_AU_BAL_CHG_APPLIED·Explore JA module →
-
View: OKL_TXD_ASSETS_V 12.1.1
A transaction table to record various Tax book related assets attributes needed by Fixed Asset Module before activating the contract and additionaly to store the split asset transaction attributes needed by Fixed Asset Moulde before activa
APPS.OKL_TXD_ASSETS_V·↳ OKL_TXD_ASSETS_B·↳ OKL_TXD_ASSETS_TL·Explore OKL module →
-
Asset transaction history in a given book
APPS.FA_TRANS_HIST_BOOKS_WEB_V·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·↳ FA_LOOKUPS·Explore OFA module →
-
View: OKX_ASSETS_V 12.2.2
Source View for Fixed Asset Line in Oracle Contracts for lease.
APPS.OKX_ASSETS_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKX module →
-
View: OKX_ASSETS_V 12.1.1
Source View for Fixed Asset Line in Oracle Contracts for lease.
APPS.OKX_ASSETS_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKX module →
-
View: OKL_TXD_ASSETS_V 12.2.2
A transaction table to record various Tax book related assets attributes needed by Fixed Asset Module before activating the contract and additionaly to store the split asset transaction attributes needed by Fixed Asset Moulde before activa
APPS.OKL_TXD_ASSETS_V·↳ OKL_TXD_ASSETS_B·↳ OKL_TXD_ASSETS_TL·Explore OKL module →
-
IGI_MHC_REVAL_DETAILS_LL_V holds the revaluation details at the distribution level for each asset level for the Live Revaluation run that was done for the current period.
APPS.IGI_MHC_REVAL_DETAILS_LL_V·↳ IGI_MHC_REVALUATION_DETAIL·↳ IGI_MHC_REVAL_SUMMARY_LL_V·Explore IGI module →
-
A transaction table to record various Tax book related assets attributes needed by Fixed Asset Module before activating the contract and additionaly to store the split asset transaction attributes needed by Fixed Asset Moulde before activa
-
IGI_MHC_CURR_REVAL_DTL_V holds the current active records for each run of Revaluation. Since Revaluation can be run in Live and Preview modes, data for all the runs is stored in the IGI_MHC_REVALUATION_DETAIL. This view filters and holds
APPS.IGI_MHC_CURR_REVAL_DTL_V·↳ IGI_MHC_REVALUATION_DETAIL·Explore IGI module →
-
IGI_MHC_CURR_REVAL_DTL_V holds the current active records for each run of Revaluation. Since Revaluation can be run in Live and Preview modes, data for all the runs is stored in the IGI_MHC_REVALUATION_DETAIL. This view filters and holds
APPS.IGI_MHC_CURR_REVAL_DTL_V·↳ IGI_MHC_REVALUATION_DETAIL·Explore IGI module →
-
When the Mass Revaluation program is run , either for INDEXED, ADHOC or CATCHUP revaluation, a record is inserted into the IGI_MHC_REVALUATION_DETAIL table for each distribution of an asset. If the process is run in the 'Preview Mode' , the
-
Table: IGI_MHC_GEN_INTERFACE 12.1.1
This table holds the temporary details of an asset at the distribution level after it has been imported or upgraded into the MHCA system.
-
IGI_MHC_REVAL_DETAILS_LL_V holds the revaluation details at the distribution level for each asset level for the Live Revaluation run that was done for the current period.
APPS.IGI_MHC_REVAL_DETAILS_LL_V·↳ IGI_MHC_REVALUATION_DETAIL·↳ IGI_MHC_REVAL_SUMMARY_LL_V·Explore IGI module →
-
View: OKL_VIEW_TRX_ASSETS_V 12.2.2
User interface view to view asset level accounting transactions
APPS.OKL_VIEW_TRX_ASSETS_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKL module →