Table: FA_RESERVE_LEDGER_GT | Oracle EBS ETRM Search

Table: FA_RESERVE_LEDGER_GT 12.2.2

owner FA·OFA - Assets·22 columns

FA.FA_RESERVE_LEDGER_GT·Explore OFA module →

Table: FA_DEPRN_DETAIL_H 12.2.2

owner FA·OFA - Assets·29 columns

Stores the depreciation information originally stored in FA_DEPRN_DETAIL for audit purposes.

FA.FA_DEPRN_DETAIL_H·Explore OFA module →

Table: FA_MC_DEPRN_DETAIL_H 12.2.2

owner FA·OFA - Assets·36 columns

Stores the depreciation information originally stored in FA_MC_DEPRN_DETAIL for audit purposes.

FA.FA_MC_DEPRN_DETAIL_H·Explore OFA module →

Table: FA_MC_DEPRN_SUMMARY 12.1.1 link

owner FA·OFA - Assets·35 columns

Depreciation information at the asset level

FA.FA_MC_DEPRN_SUMMARY·Explore OFA module →

View: FA_DEPRN_DETAIL_MRC_V 12.2.2

OFA - Assets·39 columns

APPS.FA_DEPRN_DETAIL_MRC_V·↳ FA_MC_DEPRN_DETAIL·Explore OFA module →

View: FA_EXTENDED_DEPRN_V 12.2.2

OFA - Assets·41 columns

FA_EXTENDED_DEPRN_V view is used for extended depreciation.

APPS.FA_EXTENDED_DEPRN_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_ADJUSTMENTS·Explore OFA module →

View: FA_DEPRN_SUMMARY_MRC_V 12.2.2

OFA - Assets·34 columns

APPS.FA_DEPRN_SUMMARY_MRC_V·↳ FA_MC_DEPRN_SUMMARY·Explore OFA module →

Table: FA_MC_DEPRN_SUMMARY_H 12.2.2

owner FA·OFA - Assets·39 columns

Stores the depreciation information originally stored in FA_MC_DEPRN_SUMMARY for audit purposes.

FA.FA_MC_DEPRN_SUMMARY_H·Explore OFA module →

Table: FA_MC_DEPRN_DETAIL 12.1.1 link

owner FA·OFA - Assets·49 columns

Depreciation amounts in the reporting currency, charged to the depreciation expense account in each distribution line

FA.FA_MC_DEPRN_DETAIL·Explore OFA module →

View: FA_DEPRN_SUMMARY_MRC_V 12.1.1

OFA - Assets·34 columns

APPS.FA_DEPRN_SUMMARY_MRC_V·↳ FA_MC_DEPRN_SUMMARY·Explore OFA module →

Table: FA_MC_DEPRN_DETAIL 12.2.2 link

owner FA·OFA - Assets·51 columns

Depreciation amounts in the reporting currency, charged to the depreciation expense account in each distribution line

FA.FA_MC_DEPRN_DETAIL·Explore OFA module →

Table: FA_DEPRN_SUMMARY 12.2.2 satellite-leaning

owner FA·OFA - Assets·36 columns

Depreciation information at the asset level

FA.FA_DEPRN_SUMMARY·Explore OFA module →

Table: FA_ITF_IMPAIRMENTS 12.2.2

owner FA·OFA - Assets·99 columns

FA_ITF_IMPAIRMENTS table gets populated for any candidate assets to be impaired per the impairment transaction stored in FA_IMPAIRMENTS table.

FA.FA_ITF_IMPAIRMENTS·Explore OFA module →

Table: FA_MC_DEPRN_SUMMARY 12.2.2 link

owner FA·OFA - Assets·38 columns

Depreciation information at the asset level

FA.FA_MC_DEPRN_SUMMARY·Explore OFA module →

Table: FA_DEPRN_SUMMARY_H 12.2.2 standalone

owner FA·OFA - Assets·38 columns

Stores the depreciation information originally stored in FA_DEPRN_SUMMARY for audit purposes.

FA.FA_DEPRN_SUMMARY_H·Explore OFA module →

Table: FA_DEPRN_DETAIL 12.2.2 link

owner FA·OFA - Assets·40 columns

Depreciation amounts charged to the depreciation expense account in each distribution line

FA.FA_DEPRN_DETAIL·Explore OFA module →

Table: FA_MC_BOOKS_SUMMARY 12.1.1 standalone

owner FA·OFA - Assets·101 columns

This table stores financial and depreciation information at the asset level.

FA.FA_MC_BOOKS_SUMMARY·Explore OFA module →

View: FA_ITF_IMPAIRMENTS_MRC_V 12.1.1

OFA - Assets·54 columns

APPS.FA_ITF_IMPAIRMENTS_MRC_V·↳ FA_MC_ITF_IMPAIRMENTS·Explore OFA module →

Table: FA_DEPRN_SUMMARY 12.1.1 satellite-leaning

owner FA·OFA - Assets·33 columns

Depreciation information at the asset level

FA.FA_DEPRN_SUMMARY·Explore OFA module →

Table: FA_MC_ITF_IMPAIRMENTS 12.2.2

owner FA·OFA - Assets·99 columns

FA_MC_ITF_IMPAIRMENTS is the MRC version of FA_ITF_IMPAIRMENTS.

FA.FA_MC_ITF_IMPAIRMENTS·Explore OFA module →

Table: FA_DEPRN_DETAIL 12.1.1 link

owner FA·OFA - Assets·38 columns

Depreciation amounts charged to the depreciation expense account in each distribution line

FA.FA_DEPRN_DETAIL·Explore OFA module →

View: FA_DEPRN_DETAIL_MRC_V 12.1.1

OFA - Assets·39 columns

APPS.FA_DEPRN_DETAIL_MRC_V·↳ FA_MC_DEPRN_DETAIL·Explore OFA module →

Table: FA_ADJUSTMENTS_T 12.2.2 standalone

owner FA·OFA - Assets·90 columns

FA_ADJUSTMENTS_T is a temporary table used during processing of impairment transaction and Extended Depreciation.

FA.FA_ADJUSTMENTS_T·Explore OFA module →

Table: FA_MC_ITF_IMPAIRMENTS 12.1.1

owner FA·OFA - Assets·54 columns

FA.FA_MC_ITF_IMPAIRMENTS·Explore OFA module →

View: FA_ITF_IMPAIRMENTS_MRC_V 12.2.2

OFA - Assets·54 columns

FA_ITF_IMPAIRMENTS_MRC_V is the MRC view on top of FA_MC_ITF_IMPAIRMENTS.

APPS.FA_ITF_IMPAIRMENTS_MRC_V·↳ FA_MC_ITF_IMPAIRMENTS·Explore OFA module →

Table: FA_BOOKS_SUMMARY 12.1.1 link

owner FA·OFA - Assets·100 columns

This table stores group assets' periodical financial information

FA.FA_BOOKS_SUMMARY·Explore OFA module →

Table: FA_BOOKS_SUMMARY_T 12.1.1 standalone

owner FA·OFA - Assets·100 columns

FA.FA_BOOKS_SUMMARY_T·Explore OFA module →

Table: FA_BOOKS_SUMMARY_T 12.2.2 standalone

owner FA·OFA - Assets·100 columns

FA_BOOKS_SUMMARY_T is a temporary table used during processing of impairment transaction.

FA.FA_BOOKS_SUMMARY_T·Explore OFA module →

Table: FA_BOOKS_SUMMARY 12.2.2 link

owner FA·OFA - Assets·103 columns

This table stores group assets' periodical financial information

FA.FA_BOOKS_SUMMARY·Explore OFA module →

Table: FA_MC_BOOKS_SUMMARY 12.2.2 standalone

owner FA·OFA - Assets·104 columns

This table stores financial and depreciation information at the asset level.

FA.FA_MC_BOOKS_SUMMARY·Explore OFA module →

VIEW: FA.FA_MC_DEPRN_DETAIL_H# 12.2.2

VIEW: FA.FA_SORP_UPG_CAGF# 12.2.2

VIEW: FA.FA_SORP_UPG_CAGF_HIST# 12.2.2

owner FA

VIEW: FA.FA_DEPRN_DETAIL_H# 12.2.2

VIEW: FA.FA_SORP_UPG_CAGF_HIST# 12.2.2

VIEW: FA.FA_DEPRN_SUMMARY# 12.2.2

VIEW: FA.FA_MC_DEPRN_SUMMARY# 12.2.2

VIEW: FA.FA_MC_DEPRN_SUMMARY_H# 12.2.2

VIEW: FA.FA_MC_DEPRN_DETAIL_H# 12.2.2

owner FA

VIEW: FA.FA_DEPRN_SUMMARY_H# 12.2.2

owner FA

VIEW: FA.FA_DEPRN_SUMMARY_H# 12.2.2

APPS.FA_IMPAIRMENT_PREV_PVT SQL Statements 12.2.2

VIEW: FA.FA_DEPRN_DETAIL# 12.2.2

VIEW: FA.FA_DEPRN_DETAIL_H# 12.2.2

owner FA

VIEW: FA.FA_SORP_UPG_CAGF# 12.2.2

owner FA

TABLE: FA.FA_DEPRN_SUMMARY 12.1.1

owner FA

VIEW: FA.FA_DEPRN_DETAIL# 12.2.2

owner FA

TABLE: FA.FA_SORP_UPG_CAGF 12.2.2

owner FA

TABLE: FA.FA_SORP_UPG_CAGF_HIST 12.2.2

owner FA

VIEW: FA.FA_MC_DEPRN_DETAIL# 12.2.2

Results for “impairment_reserve”