Table: FA_IMPAIRMENTS | Oracle EBS ETRM Search

IGI_MHC_REVAL_DETAILS_LL_V holds the revaluation details at the distribution level for each asset level for the Live Revaluation run that was done for the current period.

APPS.IGI_MHC_REVAL_DETAILS_LL_V·↳ IGI_MHC_REVALUATION_DETAIL·↳ IGI_MHC_REVAL_SUMMARY_LL_V·Explore IGI module →

Table: IGI_IMP_IAC_INTERFACE_PY_ADD 12.2.2 satellite-leaning

owner IGI·IGI - Public Sector Financials International·34 columns

Stores asset information for each asset processed by the Inflation Accounting Prior Year Addition program

IGI.IGI_IMP_IAC_INTERFACE_PY_ADD·Explore IGI module →

View: IGI_MHC_CURR_REVAL_DTL_V 12.2.2

IGI - Public Sector Financials International·37 columns

IGI_MHC_CURR_REVAL_DTL_V holds the current active records for each run of Revaluation. Since Revaluation can be run in Live and Preview modes, data for all the runs is stored in the IGI_MHC_REVALUATION_DETAIL. This view filters and holds

APPS.IGI_MHC_CURR_REVAL_DTL_V·↳ IGI_MHC_REVALUATION_DETAIL·Explore IGI module →

View: IGI_MHC_CURR_REVAL_DTL_V 12.1.1

IGI - Public Sector Financials International·37 columns

IGI_MHC_CURR_REVAL_DTL_V holds the current active records for each run of Revaluation. Since Revaluation can be run in Live and Preview modes, data for all the runs is stored in the IGI_MHC_REVALUATION_DETAIL. This view filters and holds

APPS.IGI_MHC_CURR_REVAL_DTL_V·↳ IGI_MHC_REVALUATION_DETAIL·Explore IGI module →

Table: IGI_MHC_REVALUATION_DETAIL 12.2.2 standalone

owner IGI·IGI - Public Sector Financials International·38 columns

When the Mass Revaluation program is run , either for INDEXED, ADHOC or CATCHUP revaluation, a record is inserted into the IGI_MHC_REVALUATION_DETAIL table for each distribution of an asset. If the process is run in the 'Preview Mode' , the

IGI.IGI_MHC_REVALUATION_DETAIL·Explore IGI module →

Table: IGI_MHC_GEN_INTERFACE 12.1.1

owner IGI·IGI - Public Sector Financials International·39 columns

This table holds the temporary details of an asset at the distribution level after it has been imported or upgraded into the MHCA system.

IGI.IGI_MHC_GEN_INTERFACE·Explore IGI module →

View: IGI_MHC_REVAL_DETAILS_LL_V 12.2.2

IGI - Public Sector Financials International·39 columns

IGI_MHC_REVAL_DETAILS_LL_V holds the revaluation details at the distribution level for each asset level for the Live Revaluation run that was done for the current period.

APPS.IGI_MHC_REVAL_DETAILS_LL_V·↳ IGI_MHC_REVALUATION_DETAIL·↳ IGI_MHC_REVAL_SUMMARY_LL_V·Explore IGI module →

View: IGI_MHC_REVAL_DETAILS_PL_V 12.2.2

IGI - Public Sector Financials International·39 columns

IGI_MHC_REVAL_SUMMARY_PL_V holds data for each distribution of an asset for all the Live runs of Revaluation done for the Previous periods

APPS.IGI_MHC_REVAL_DETAILS_PL_V·↳ IGI_MHC_REVALUATION_DETAIL·↳ IGI_MHC_REVAL_SUMMARY_PL_V·Explore IGI module →

Table: IGI_IAC_ASSET_BALANCES 12.2.2 standalone

owner IGI·IGI - Public Sector Financials International·19 columns

Holds periodic asset balance position

IGI.IGI_IAC_ASSET_BALANCES·Explore IGI 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 →

View: FA_IMPAIRMENTS_MRC_V 12.2.2

OFA - Assets·24 columns

FA_IMPAIRMENTS_MRC_V is the MRC view on top of FA_MC_IMPAIRMENTS.

APPS.FA_IMPAIRMENTS_MRC_V·↳ FA_MC_IMPAIRMENTS·Explore OFA module →

Table: JA_AU_SRW_TAX_DEPRN_TMP 12.2.2 satellite-leaning

owner JA·JA - Asia/Pacific Localizations·25 columns

Australian Schedule 32 report temporary table

JA.JA_AU_SRW_TAX_DEPRN_TMP·Explore JA 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_ITF_IMPAIRMENTS 12.1.1

owner FA·OFA - Assets·53 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: JG_ZZ_FA_REG_ITF 12.2.2

owner JG·JG - Regional Localizations·76 columns

JG_ZZ_FA_REG_ITF holds data needed for Fixed Assets Register Report

JG.JG_ZZ_FA_REG_ITF·Explore JG module →

Table: IGI_IMP_IAC_INTERFACE_PY_ADD 12.1.1 satellite-leaning

owner IGI·IGI - Public Sector Financials International·34 columns

Stores asset information for each asset processed by the Inflation Accounting Prior Year Addition program

IGI.IGI_IMP_IAC_INTERFACE_PY_ADD·Explore IGI module →

Table: JG_ZZ_FA_REG_ITF 12.1.1

owner JG·JG - Regional Localizations·76 columns

JG_ZZ_FA_REG_ITF holds data needed for Fixed Assets Register Report

JG.JG_ZZ_FA_REG_ITF·Explore JG module →

Table: IGI_MHC_REVALUATION_DETAIL 12.1.1 standalone

owner IGI·IGI - Public Sector Financials International·38 columns

When the Mass Revaluation program is run , either for INDEXED, ADHOC or CATCHUP revaluation, a record is inserted into the IGI_MHC_REVALUATION_DETAIL table for each distribution of an asset. If the process is run in the 'Preview Mode' , the

IGI.IGI_MHC_REVALUATION_DETAIL·Explore IGI module →

Table: IGI_MHC_GEN_INTERFACE 12.2.2

owner IGI·IGI - Public Sector Financials International·39 columns

This table holds the temporary details of an asset at the distribution level after it has been imported or upgraded into the MHCA system.

IGI.IGI_MHC_GEN_INTERFACE·Explore IGI module →

Table: FA_IMPAIRMENTS 12.2.2 standalone

owner FA·OFA - Assets·39 columns

FA_IMPAIRMENTS table stores the Impairment Transaction information.

FA.FA_IMPAIRMENTS·Explore OFA module →

View: IGI_MHC_REVAL_DETAILS_PL_V 12.1.1

IGI - Public Sector Financials International·39 columns

IGI_MHC_REVAL_SUMMARY_PL_V holds data for each distribution of an asset for all the Live runs of Revaluation done for the Previous periods