Search Results date_in

Overview

APPS.FA_ASSET_DISTRIBUTION_V is an Oracle E-Business Suite reporting view owned by the APPS schema that consolidates fixed asset master data with its current distribution, book, category, and expense account information into a single denormalized result set. It is typically used for corporate reporting, asset audits, and integration extracts where a flat, human-readable representation of each asset and its assignment is required. Because it joins FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, FA_DISTRIBUTION_HISTORY, category, and GL accounting flexfield data, it removes the need for report developers to reproduce the multi-table join logic themselves. The view is defined with a corporate book class restriction, so only assets associated with a book class of "CORPORATE" are returned.

Underlying Base Objects

The view is defined over the following documented objects: FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORIES_B, FA_CATEGORY_BOOKS, FA_DISTRIBUTION_HISTORY, FA_EMPLOYEES (itself a view), FA_LOCATIONS, and GL_CODE_COMBINATIONS, with supporting calls through HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages. FA_ADDITIONS supplies the physical asset attributes such as asset number, tag number, description, manufacturer, serial number, and model number. FA_BOOKS and FA_BOOK_CONTROLS provide book-level depreciation and cost information, with FA_BOOK_CONTROLS filtering on book_class = 'CORPORATE'. FA_CATEGORIES_B and FA_CATEGORY_BOOKS supply the category flexfield segments and the associated asset cost account. FA_DISTRIBUTION_HISTORY supplies the current effective assignment (employee, location, expense account, and units assigned), while FA_EMPLOYEES, FA_LOCATIONS, and GL_CODE_COMBINATIONS resolve the descriptive names and accounting flexfield segment values.

Key Columns

• ASSET_NUMBER, TAG_NUMBER, DESCRIPTION, MANUFACTURER_NAME, SERIAL_NUMBER, MODEL_NUMBER — identifying and descriptive attributes of the asset.
• MAJOR_CATEGORY (CA.SEGMENT1), SUB_CATEGORY (CA.SEGMENT2) — asset category flexfield segments; the view comments indicate these are customizable.
• BOOK_TYPE_CODE — the asset book to which the row relates.
• DATE_IN (BK.DATE_PLACED_IN_SERVICE) — the date the asset was placed in service. This is the column the user searched for as "date_in"; note the alias is defined on DATE_PLACED_IN_SERVICE, not on a column literally named DATE_IN.
• COST — calculated as ROUND(bk.cost * dh.units_assigned / ad.current_units, 2), i.e., the prorated book cost based on units assigned versus current units.
• EMPLOYEE_NUMBER, EMPLOYEE_NAME — the employee to whom the distribution is currently assigned.
• STATE, CITY, SITE, LOCATOR — location flexfield segments (LOC.SEGMENT1–4), customizable.
• COMPANY, REGION, COST_CENTER, EXPENSE_ACCOUNT, PRODUCT, SUB_ACCOUNT — expense account flexfield segments (EXPENSE_CC.SEGMENT1–6), customizable.
• ASSET_ACCOUNT (CB.ASSET_COST_ACCT) — the asset cost account from the category/book combination.

Common Use Cases and Queries

Typical uses include corporate asset registers, in-service date analysis, assignment tracking, and expense account distribution reporting. The view filters out retired and ineffective rows via bk.period_counter_fully_retired IS NULL, bk.date_ineffective IS NULL, and dh.date_ineffective IS NULL, restricting output to active distributions.

A representative query returning assets placed in service within a period:

• SELECT asset_number, tag_number, book_type_code, date_in, cost, employee_name, cost_center
• FROM apps.fa_asset_distribution_v
• WHERE date_in BETWEEN :from_date AND :to_date
• ORDER BY date_in;

Because the alias "DATE_IN" is not a physical column, reports should always reference it as exposed by the view rather than assuming a base column of the same name. All access in EBS 12.1.1 and 12.2.2 is through the APPS synonym, and query performance depends on indexes on FA_ADDITIONS, FA_BOOKS, and FA_DISTRIBUTION_HISTORY.