Search Results sub_category




Overview
Explore in AI Chat

Overview

APPS.FA_ASSET_V is a public Oracle EBS view in the Fixed Assets (OFA) module that exposes a consolidated, denormalized read model of asset master and depreciation data. It is registered as FND Design Data under the OFA product family and carries a STATUS of VALID in both Oracle EBS 12.1.1 and 12.2.2. The view is owned by the APPS schema and is intended to support reporting, ad-hoc querying, and downstream integration where a flattened view of asset attributes is preferable to joining multiple Fixed Assets base tables. The user query term "sub_category" maps directly to the SUB_CATEGORY column exposed by the view, which is one of the sixteen columns surfaced.

Underlying Base Objects

FA_ASSET_V is defined over four Fixed Assets base objects, all resolved through APPS synonyms: FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, and FA_CATEGORIES_B. FA_ADDITIONS supplies the physical asset identity and descriptive attributes. FA_BOOKS supplies the per-book financial and depreciation attributes. FA_BOOK_CONTROLS provides book-level context used to constrain and join the query. FA_CATEGORIES_B supplies the category hierarchy segments, including the category value surfaced as SUB_CATEGORY. The view is documented as not being referenced by any other database object, meaning it is a terminal reporting artifact rather than a dependency of further packaged logic. Because the underlying objects are referenced via APPS synonyms, the view resolves to the base tables owned by the OFA product schema.

Key Columns

The view projects sixteen columns. Asset identity is provided by ASSET_NUMBER, TAG_NUMBER, DESCRIPTION, SERIAL_NUMBER, MODEL_NUMBER, and MANUFACTURER_NAME. Category information is exposed through MAJOR_CATEGORY and SUB_CATEGORY, both VARCHAR2(30); SUB_CATEGORY is the column most relevant to the user's search and corresponds to the detail-level asset category. Book context is carried by BOOK_TYPE_CODE and DATE_PLACED_IN_SERVICE. Depreciation attributes include DEPRN_METHOD_CODE, LIFE_IN_MONTHS, ADJUSTED_RATE, and PRODUCTION_CAPACITY. Financial measures are represented by COST and SALVAGE_VALUE. Together these columns provide a self-contained asset-plus-book record without requiring the caller to navigate the underlying joins manually.

Common Use Cases and Queries

Typical uses include fixed asset registers, depreciation method audits, category-level cost roll-ups, and extracts feeding downstream systems. The most direct pattern is to select the columns of interest explicitly and filter on category or book.

  • Asset listing by sub-category: SELECT ASSET_NUMBER, DESCRIPTION, SUB_CATEGORY, COST FROM APPS.FA_ASSET_V WHERE SUB_CATEGORY = :p_sub_category;
  • Book-scoped register: SELECT ASSET_NUMBER, BOOK_TYPE_CODE, DATE_PLACED_IN_SERVICE, COST FROM APPS.FA_ASSET_V WHERE BOOK_TYPE_CODE = :p_book;
  • Depreciation profile review: SELECT ASSET_NUMBER, DEPRN_METHOD_CODE, LIFE_IN_MONTHS, ADJUSTED_RATE FROM APPS.FA_ASSET_V;
  • Cost aggregation: SELECT SUB_CATEGORY, SUM(COST) FROM APPS.FA_ASSET_V GROUP BY SUB_CATEGORY;
  • Manufacturer and model analysis: SELECT MANUFACTURER_NAME, MODEL_NUMBER, COUNT(*) FROM APPS.FA_ASSET_V GROUP BY MANUFACTURER_NAME, MODEL_NUMBER;

Consumers should note that the view does not expose asset IDs or book-level effective dates, so joins back to FA_ADDITIONS or FA_BOOKS may be required when primary keys or date-ranged book records are needed. As with all APPS public views, it should be queried rather than referenced as a foreign-key target.