Results for “fafv_assets”

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

Overview

FAFV_ASSETS is a read-only Oracle E-Business Suite view owned by the APPS schema in the Oracle Assets (OFA) module. It is documented as a retrofitted object, meaning it exists to preserve backward compatibility for forms, reports, or integration interfaces that were originally built against an earlier object structure and continue to reference FAFV_ASSETS by name. Within the E-Business Suite 12.1.1 and 12.2.2 data model, the view presents a consolidated, denormalized projection of asset master information joined with leasing, distribution, category, book, and asset-keyword data.

Because the view carries a mandatory WITH READ ONLY clause, it cannot be used to insert, update, or delete asset records. Its role is strictly informational: it supplies a single-row-per-asset-and-book projection suitable for reporting extracts, concurrent program queries, and downstream integration views that need asset attributes without navigating the full normalized Assets schema.

Underlying Base Objects

The view definition references six base objects, all exposed through synonyms in the APPS schema:

• FA_ADDITIONS — the primary asset master table providing the core asset identity and descriptive columns.
• FA_CATEGORIES — supplies the asset category description joined on ASSET_CATEGORY_ID = CATEGORY_ID.
• FA_BOOKS — supplies book-level records and the critical transaction tail filter TRANSACTION_HEADER_ID_OUT IS NULL.
• FA_DISTRIBUTION_HISTORY — supplies distribution identifiers, also filtered by TRANSACTION_HEADER_ID_OUT IS NULL to exclude reversed or transferred distributions.
• FA_LEASES — provides lease number; joined with an outer join (LEASE_ID = LE.LEASE_ID (+)) so owned assets without leases remain visible.
• FA_ASSET_KEYWORDS — joined via an outer join on AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID (+), resolving the flexfield key concatenation.

The inclusion of only non-null TRANSACTION_HEADER_ID_OUT rows for both FA_BOOKS and FA_DISTRIBUTION_HISTORY ensures that only the current, active book and distribution records for each asset are returned.

Key Columns

• ASSET_ID / ASSET_NUMBER — the internal and user-facing asset identifiers.
• "_KF:CODE_COMBINATION" — a flexfield key reference derived from the asset keyword join.
• CURRENT_UNITS, ASSET_TYPE, TAG_NUMBER, ASSET_DESCRIPTION — core descriptive attributes from FA_ADDITIONS.
• MANUFACTURER_NAME, SERIAL_NUMBER, MODEL_NUMBER — physical identification attributes.
• PARENT_ASSET_ID — supports parent/child asset hierarchies.
• PROPERTY_TYPE_CODE, PROPERTY_1245_1250_CODE — tax property classification codes (1245/1250 refer to U.S. tax depreciation categories).
• IN_USE_FLAG, OWNED_LEASED, NEW_USED, INVENTORIAL — status and classification flags.
• ASSET_CATEGORY_ID / CATEGORY_DESCRIPTION — category identity and description.
• LEASE_ID / LEASE_NUMBER — lease linkage, null for owned assets.
• DISTRIBUTION_ID — current distribution record reference.
• BOOK_TYPE_CODE — corporate, tax, or other depreciation book identifier.

Common Use Cases and Queries

The view is typically queried by reports and interfaces needing a flattened asset picture with both book and lease context. A representative query for a given book might read:

SELECT asset_number, asset_description, category_description, book_type_code, lease_number FROM apps.fafv_assets WHERE book_type_code = 'CORP' AND in_use_flag = 'YES';

Because it joins FA_BOOKS and FA_DISTRIBUTION_HISTORY, a single asset with multiple books will appear on multiple rows, one per book. Analysts querying the view should therefore filter on BOOK_TYPE_CODE to avoid unexpected row multiplication. Note that the search phrase "acquired Fairview city Utah" relates to user-entered asset descriptions or locations and finds no dedicated column in this view; such filtering must be performed against free-text fields such as ASSET_DESCRIPTION or joined location tables in FA_ADDITIONS.