OFA Views (148)

OFA - Assets — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`FABV_ACCT_PRDS`	- Retrofitted
`FABV_ASSETS`	- Retrofitted
`FABV_ASSET_ASSIGNS`	- Retrofitted
`FABV_ASSET_BKS`	- Retrofitted
`FABV_ASSET_CATS`	- Retrofitted
`FABV_ASSET_LEASES`
`FABV_ASSET_LOCS`	- Retrofitted
`FABV_BOOKS`
`FABV_DEPRECIATIONS`	- Retrofitted
`FABV_SRC_LNS`	- Retrofitted
`FABV_TRANS_HDRS`	- Retrofitted
`FABV_TRANS_LINES`	- Retrofitted
`FAFV_ACCT_PRDS`	- Retrofitted
`FAFV_ASSETS`	- Retrofitted
`FAFV_ASSET_ASSIGNS`	- Retrofitted
`FAFV_ASSET_BKS`	- Retrofitted
`FAFV_ASSET_CATS`	- Retrofitted
`FAFV_ASSET_LEASES`	- Retrofitted
`FAFV_ASSET_LOCS`	- Retrofitted
`FAFV_BOOKS`
`FAFV_DEPRECIATIONS`	- Retrofitted
`FAFV_SRC_LNS`	- Retrofitted
`FAFV_TRANS_HDRS`	- Retrofitted
`FAFV_TRANS_LINES`
`FA_ADDITIONS_ASSET_V`
`FA_ADDITIONS_NON_SEC_VL`
`FA_ADDITIONS_V`
`FA_ADDITIONS_VL`
`FA_ADDITIONS_WEB_V`	Contains asset identification information
`FA_ADD_INVOICE_WEB_V`	Invoice information pertaining to the asset
`FA_ADJUSTMENTS_MRC_V`
`FA_AEL_GL_V`
`FA_AEL_SL_MRC_V`
`FA_AEL_SL_V`
`FA_ALTERNATE_LEDGERS_V`	Alternate Ledgers Defined for a book
`FA_ASSET_DISTRIBUTION_V`	Asset Identification and Distribution
`FA_ASSET_HIERARCHY_PURPOSE_V`
`FA_ASSET_HIERARCHY_V`
`FA_ASSET_HIERARCHY_VALUES_V`
`FA_ASSET_HISTORY_V`	- Retrofitted
`FA_ASSET_HIST_WEB_V`	Asset history information
`FA_ASSET_HRCHY_DETAILS_V`
`FA_ASSET_INVOICES_MRC_V`	- Retrofitted
`FA_ASSET_INVOICES_V`	Business view of asset identification, financial, and purchasing information
`FA_ASSET_MAINT_VIEW`
`FA_ASSET_V`	Asset identification and financial information
`FA_BOOKS_BK_CNTRL_WEB_V`	Asset financial information in a given depreciation book
`FA_BOOKS_BOOK_CONTROLS_V`	- Retrofitted
`FA_BOOKS_GROUPS_MRC_V`
`FA_BOOKS_GROUPS_V`	Updates NBV and reserve of group assets with depreciation adjustments
`FA_BOOKS_GROUPS_V1`	Updates NBV and reserve of group assets with depreciation adjustments
`FA_BOOKS_MRC_V`
`FA_BOOKS_SUMMARY_MRC_V`
`FA_BOOKS_V`	Selects active financial information for an asset in a given book
`FA_BOOK_CONTROLS_MRC_V`	- Retrofitted
`FA_CAPITALIZE_CIP_V`	Newly added or capitalized CIP assets
`FA_CATEGORIES_VL`
`FA_CHILD_ASSETS_V`
`FA_CURR_DEPRN_ADJ_V`	Provides total depreciation for the current period
`FA_DEFERRED_DEPRN_EVENTS_V`
`FA_DEFERRED_DEPRN_MRC_V`	- Retrofitted
`FA_DEPRN_DETAIL_H_MRC_V`
`FA_DEPRN_DETAIL_MRC_V`
`FA_DEPRN_EVENTS_V`
`FA_DEPRN_GROUPS_V`
`FA_DEPRN_GROUPS_V1`	Adds unplanned depreciation adjustments to fa_deprn_groups_v
`FA_DEPRN_OVERRIDE_V`
`FA_DEPRN_PERIODS_MRC_V`
`FA_DEPRN_SUMMARY_H_MRC_V`
`FA_DEPRN_SUMMARY_MRC_V`
`FA_DEPRN_WEB_V`	Depreciation information for an asset in a given depreciation book
`FA_DISTRIBUTION_HISTORY_V`	- Retrofitted
`FA_DISTRIBUTION_HIST_WEB_V`	Historical distribution information
`FA_DISTRIBUTION_INQUIRY_V`
`FA_DISTRIBUTION_INQ_WEB_V`	Asset distribution information
`FA_EMPLOYEES`	Employees view with termination information
`FA_EMP_ASSET_WEB_V`
`FA_EXTENDED_DEPRN_V`	FA_EXTENDED_DEPRN_V view is used for extended depreciation.
`FA_FINANCIAL_INQUIRY_COST_V`	Financial Cost History
`FA_FINANCIAL_INQUIRY_DEPRN_H_V`	Depreciation history information
`FA_FINANCIAL_INQUIRY_DEPRN_V`	Depreciation history information
`FA_FINANCIAL_INQUIRY_UPL_V`	- Retrofitted
`FA_FIN_INQRY_COST_WEB_V`	Cost history information
`FA_FIN_INQRY_DEPRN_WEB_V`	Depreciation history information
`FA_FIN_INQRY_UPL_WEB_V`	Unplanned depreciation history
`FA_FUTURE_MASS_ADDITIONS_V`
`FA_GROUP_COST_INQUIRY_V`
`FA_GROUP_DEPRN_DETAIL_MRC_V`
`FA_GROUP_DEPRN_SUMMARY_MRC_V`
`FA_HIERARCHY_BATCH_DETAILS_V`
`FA_HIERARCHY_BATCH_HEADER_V`
`FA_HIERARCHY_DISTRIBUTIONS_V`
`FA_HIERARCHY_RULE_DETAILS_V`
`FA_HR_BATCH_DIST_NEW_V`
`FA_HR_BATCH_DIST_OLD_V`
`FA_HR_RETIREMENT_DETAILS_V`
`FA_HR_RETIREMENT_HEADERS_V`
`FA_IMPAIRMENTS_MRC_V`	FA_IMPAIRMENTS_MRC_V is the MRC view on top of FA_MC_IMPAIRMENTS.
`FA_INS_ADDITIONS_V`
`FA_INS_LINES_V`
`FA_INS_MST_POLS_V`
`FA_INS_POLICIES_V`
`FA_INVENTORY_V`	This view shows reconciliation information on assets that have been included in physical inventory
`FA_INVOICE_DETAILS_V`
`FA_INVOICE_DETAILS_WEB_V`	Detailed invoice information
`FA_INVOICE_TRANSFERS_V`
`FA_INV_INTERFACE_V`	- Retrofitted
`FA_ITF_IMPAIRMENTS_MRC_V`	FA_ITF_IMPAIRMENTS_MRC_V is the MRC view on top of FA_MC_ITF_IMPAIRMENTS.
`FA_LEASES_V`	Selects descriptive lease information
`FA_LEASES_WEB_V`	Information about leases assigned to assets
`FA_LEASE_PAYMENT_ITEMS_V`
`FA_LIFES_V`
`FA_LOOKUPS_VL`
`FA_LOOKUP_TYPES_VL`
`FA_MASS_ADDITIONS_V`
`FA_MASS_EXTERNAL_TRANSFERS_V`
`FA_MASS_EXT_RETIREMENTS_V`
`FA_MUPD_V`
`FA_PRRUN_PERIODS_V`	- Retrofitted
`FA_QUICK_ADDITIONS_V`
`FA_QUICK_BOOKS_V`	- Retrofitted
`FA_QUICK_DISTRIBUTIONS_V`	- Retrofitted
`FA_RESERVE_TRANSFERS_V`
`FA_RETIRED_ASSET_WEB_V`	Information about retired assets
`FA_RETIREMENTS_MRC_V`	- Retrofitted
`FA_RETIREMENTS_V`	Asset Retirement Information
`FA_RETIREMENTS_WEB_V`	Asset retirement transaction information
`FA_RETIREMENT_ADJUSTMENTS_V`
`FA_RETIREMENT_REQUESTS_V`	This view displays Mass Retirements and its effect on the performed retirement transaction
`FA_RX_ATTRSETS_VL`	Stores attribute set information for RX reports (translated MLS view)
`FA_RX_CR_REPORTS_V`	- Retrofitted
`FA_RX_NOCR_REPORTS_V`	- Retrofitted
`FA_RX_REPORTS_V`	- Retrofitted
`FA_RX_REP_COLUMNS_VL`	Stores attribute definitions for Report eXchange report attributes (translated MLS view)
`FA_RX_REP_PARAMETERS_V`	- Retrofitted
`FA_RX_SUMMARY_VL`	Stores summary definitions for Report eXchange report attributes (translated MLS view)
`FA_SORP_ASSET_LINK_REVAL_V`	This view is used to retrieve impairments and related information selected by user for linking while performing revaluation at category leve
`FA_SORP_CAT_LINK_REVAL_V`	This view is used to retrieve impairments and related information selected by user for linking while performing revaluation at asset level.
`FA_SOURCE_LINES_V`
`FA_SXL_BOOKS_V`
`FA_TRANSACTIONS_V`
`FA_TRANSACTION_HEADERS_V`
`FA_TRANSACTION_HISTORY_BOOKS_V`	- Retrofitted
`FA_TRANSACTION_HISTORY_TRX_V`	- Retrofitted
`FA_TRANSFER_INVOICES_V`
`FA_TRANS_HIST_BOOKS_WEB_V`	Asset transaction history in a given book
`FA_TRANS_HIST_TRX_WEB_V`	Asset transaction history for all books
`FA_UNPLANNED_DEPR_V`	- Retrofitted