Search Results fa_asset_keywords_kfv




Overview
Explore in AI Chat

Overview

APPS.FA_LEASES_WEB_V is a reporting and integration view in the Oracle E-Business Suite Fixed Assets (FA) module. It exposes a denormalized, web-friendly projection of leased asset information by joining asset master records to their associated lease headers, lessors, categories, and asset key flexfield combinations. The view is owned by the APPS schema and is present in both EBS 12.1.1 and 12.2.2.

The view is designed to support user-facing inquiries and integrations that require lease details alongside core asset attributes. Because Fixed Assets stores lease information in the FA_LEASES table and asset detail in FA_ADDITIONS, this view eliminates the need for consumers to reproduce the join logic and key flexfield resolution themselves. In practice, it serves OAF-based and JSP-based Fixed Assets lease pages, and it is frequently reused in custom reports, extracts, and interface programs where a flattened lease-to-asset result set is required.

Underlying Base Objects

The ETRM metadata documents the following objects referenced by the view definition:

The joins on FA_CATEGORIES_B, FA_CATEGORIES_B_KFV, and FA_ASSET_KEYWORDS_KFV are outer joins, so assets whose category or key flexfield combination is not populated still appear. The joins to FA_LEASES and PO_VENDORS are inner joins, meaning only assets with a valid lease and resolvable lessor are returned. The metadata explicitly documents FA_ASSET_KEYWORDS_KFV as a referenced object, which is directly relevant to searches for "fa_asset_keywords_kfv".

Key Columns

Common Use Cases and Queries

Typical use cases include lease asset inquiries, lessor utilization reporting, and extracts that feed downstream reconciliation or tax systems. Because the view already resolves the asset key flexfield concatenation, it is commonly chosen over direct joins to FA_ADDITIONS when a readable asset key is required.

Sample query returning leased assets with their key and category:

  • SELECT asset_number, asset_description, asset_key, category, lease_number, vendor_name FROM apps.fa_leases_web_v WHERE owned_leased = 'LEASED';
  • SELECT lessor_id, vendor_name, lease_number, COUNT(asset_id) FROM apps.fa_leases_web_v GROUP BY lessor_id, vendor_name, lease_number;
  • SELECT asset_id, asset_number, asset_key FROM apps.fa_leases_web_v WHERE asset_category_id = :p_category_id ORDER BY asset_number;

Consumers should note that the inner joins restrict output to assets with a populated lease. When querying the asset key flexfield independently, FA_ASSET_KEYWORDS_KFV remains the appropriate base view; FA_LEASES_WEB_V simply exposes it in a pre-joined lease context.