Search Results ls_attribute15




Overview
Explore in AI Chat

Overview

FA_ADDITIONS_WEB_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Assets (OFA) product family and is described in the ETRM metadata as a view that "contains asset identification information." Functionally, the view consolidates the descriptive and identifying attributes of an asset — its number, description, tag, serial and model numbers, category, parent-child relationships, and lease information — into a single denormalized structure that is convenient for self-service web pages, concurrent report queries, and external integration interfaces.

Because Oracle Assets stores asset master data across several tables (FA_ADDITIONS, FA_CATEGORIES_B, FA_LEASES, and the key flexfield views), callers who need a complete identification record would otherwise have to write multi-table joins each time. FA_ADDITIONS_WEB_V encapsulates those joins, translates lookup codes into meaningful values, and exposes the descriptive flexfield context and attribute segments directly. The "_WEB_V" suffix indicates it was originally engineered to serve Oracle Assets web-based (HTML/self-service) functionality, but it is equally usable from any SQL-based reporting layer.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects:

  • FA_ADDITIONS (SYNONYM) — the primary asset master table, aliased AD in the view text. Supplies asset_id, asset_number, tag_number, description, category reference, parent_asset_id, manufacturer, serial and model numbers, units, and the 30 descriptive flexfield attributes.
  • FA_ASSET_KEYWORDS_KFV (VIEW) — the key flexfield concatenation view, aliased AK, supplying ASSET_KEY (the concatenated asset key segment string).
  • FA_CATEGORIES_B (SYNONYM) and FA_CATEGORIES_B_KFV (VIEW) — the asset category definition and its concatenated key flexfield segment string, aliased CK, supplying the CATEGORY column.
  • FA_LEASES (SYNONYM) — aliased LEASE, supplying lease_number, lease description, lessor_id, and lease descriptive flexfield attributes (LS_ATTRIBUTE1 through LS_ATTRIBUTE15).
  • FA_LOOKUPS (SYNONYM) — aliased LU1, LU2, and LU3, used to translate codes such as property_type_code, in_use_flag, and owned_leased into their MEANING values.
  • PO_VENDORS (VIEW) — aliased PV, supplying the LESSOR (vendor_name) for leased assets.

FA_ADDITIONS_WEB_V therefore acts as a hub joining asset master data with flexfield, category, lease, lookup, and supplier references.

Key Columns

Identity columns include ASSET_ID, ASSET_NUMBER, TAG_NUMBER, and ROW_ID. The ASSET_KEY and CATEGORY columns expose the concatenated key flexfield segment strings for the asset and its category respectively. Descriptive columns include DESCRIPTION, CURRENT_UNITS, ASSET_TYPE, MANUFACTURER_NAME, SERIAL_NUMBER, and MODEL_NUMBER.

Relationship and classification columns include ASSET_KEY_CCID, ASSET_CATEGORY_ID, PARENT_ASSET_ID, and the derived PARENT_ASSET and PARENT_DESCRIPTION. Lookup-translated columns include PROPERTY_TYPE_CODE, IN_USE_FLAG, and OWNED_LEASED, each presented as a MEANING rather than a raw code. Lease-related columns include LEASE_NUMBER, LEASE_DESC, LESSOR_ID, and LS_ATTRIBUTE1 through LS_ATTRIBUTE15. The view also exposes ATTRIBUTE1 through ATTRIBUTE30, ATTRIBUTE_CATEGORY_CODE, and CONTEXT, representing the asset descriptive flexfield, plus standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

A frequent requirement is locating assets by a descriptive flexfield attribute. Note that the search term "ls_attribute1" does not map to a column here; the lease flexfield columns are prefixed LS_ (LS_ATTRIBUTE1), while asset flexfield columns are plain ATTRIBUTE1 through ATTRIBUTE30. A representative query follows:

  • Asset lookup by flexfield: SELECT asset_number, description, attribute1, asset_key FROM apps.fa_additions_web_v WHERE attribute1 = :p_value;
  • Leased asset with lessor: SELECT asset_number, lease_number, lessor, ls_attribute1 FROM apps.fa_additions_web_v WHERE owned_leased = 'LEASED';
  • Parent-child hierarchy report: SELECT asset_number, parent_asset, parent_description FROM apps.fa_additions_web_v WHERE parent_asset_id IS NOT NULL;

Typical scenarios include asset inventory reconciliation reports, self-service asset detail pages, lease administration extracts, and inbound interfaces that need the concatenated asset key alongside descriptive flexfield values. Because the view resolves lookups, it is convenient for end-user reporting; however, for high-volume batch processing, direct access to FA_ADDITIONS with selective joins generally performs better.