[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_ITF_IMPAIRMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_ITF_IMPAIRMENTS
|
| Subobject Name: | |
| Status: | VALID |
FA_ITF_IMPAIRMENTS table gets populated for any candidate assets to be impaired per the impairment transaction stored in FA_IMPAIRMENTS table. This is also the source of impairment preview and post report.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_ITF_IMPAIRMENTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 IMPAIRMENT_ID
BOOK_TYPE_CODE
ASSET_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | (15) | Yes | Unique identification number of a impairment process concurrent request |
| IMPAIRMENT_ID | NUMBER | (15) | Yes | Unique identification number of a impairment |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book Name |
| ASSET_ID | NUMBER | Asset identification number | ||
| CASH_GENERATING_UNIT_ID | NUMBER | (15) | Unique identification number of c cash generating unit | |
| NET_BOOK_VALUE | NUMBER | Net book value of an asset | ||
| NET_SELLING_PRICE | NUMBER | Fair value of the cash generating or Asset less cost to sell | ||
| VALUE_IN_USE | NUMBER | Present value of future cash flows expected of an asset or cash generating unit | ||
| IMPAIRMENT_AMOUNT | NUMBER | Periodic Impairment amount | ||
| YTD_IMPAIRMENT | NUMBER | Year-to-date Impairment amount | ||
| LTD_IMPAIRMENT | NUMBER | |||
| GOODWILL_ASSET_FLAG | VARCHAR2 | (1) | Indicate whether a asset is goodwill asset or not | |
| DEPRN_RUN_DATE | DATE | System date when depreciation was run | ||
| DEPRN_AMOUNT | NUMBER | Depreciation expense for this depreciation period | ||
| YTD_DEPRN | NUMBER | Year-to-date depreciation expense | ||
| DEPRN_RESERVE | NUMBER | Total depreciation taken since beginning of asset life | ||
| ADJUSTED_COST | NUMBER | Depreciable basis | ||
| BONUS_RATE | NUMBER | Bonus rate used to calculate depreciation | ||
| LTD_PRODUCTION | NUMBER | Life-to-date production for a units of production asset | ||
| PERIOD_COUNTER | NUMBER | (15) | Depreciation period | |
| PRODUCTION | NUMBER | Current period production for a units of production asset | ||
| REVAL_AMORTIZATION | NUMBER | Amount of revaluation reserve amortized during this period | ||
| REVAL_AMORTIZATION_BASIS | NUMBER | Revaluation reserve used in calculating amortization of revaluation reserve | ||
| REVAL_DEPRN_EXPENSE | NUMBER | Portion of depreciation expense due to revaluation of the asset cost | ||
| REVAL_RESERVE | NUMBER | Revaluation reserve amount after depreciation run | ||
| YTD_PRODUCTION | NUMBER | Year-to-date production for a units of production asset | ||
| YTD_REVAL_DEPRN_EXPENSE | NUMBER | Year-to-date depreciation expense due to revaluation | ||
| PRIOR_FY_EXPENSE | NUMBER | Depreciation expense due to prior fiscal years | ||
| BONUS_DEPRN_AMOUNT | NUMBER | Bonus depreciation expense for this depreciation period | ||
| BONUS_YTD_DEPRN | NUMBER | Bonus year-to-date depreciation expense | ||
| BONUS_DEPRN_RESERVE | NUMBER | Total bonus depreciation taken since the beginning of asset life | ||
| PRIOR_FY_BONUS_EXPENSE | NUMBER | Bonus Depreciation expense due to prior fiscal years | ||
| DEPRN_OVERRIDE_FLAG | VARCHAR2 | (1) | Override status | |
| SYSTEM_DEPRN_AMOUNT | NUMBER | System calculated Depreciation Amount | ||
| SYSTEM_BONUS_DEPRN_AMOUNT | NUMBER | System calculated Bonus Depreciation Amount | ||
| DEPRN_ADJUSTMENT_AMOUNT | NUMBER | Depreciation adjustment amount | ||
| BONUS_DEPRN_ADJUSTMENT_AMOUNT | NUMBER | Bonus depreciation adjustment amount | ||
| REVAL_RESERVE_ADJ_AMOUNT | NUMBER | Change in revaluation reserve amount due to an impairment transaction | ||
| COST | NUMBER | Asset cost | ||
| PERIOD_OF_ADDITION_FLAG | VARCHAR2 | (1) | Indicate whether an asset is in period of addition or not | |
| CURRENT_UNITS | NUMBER | Current number of units for the asset | ||
| CATEGORY_ID | NUMBER | (15) | Identifies category to which the asset belongs | |
| IMPAIRMENT_DATE | DATE | Impairment date | ||
| WORKER_ID | NUMBER | (15) | Worker identification number for parallel processing | |
| PROCESS_ORDER | NUMBER | (15) | Identifies when to process this record for parallel processing | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| RATE_ADJUSTMENT_FACTOR | NUMBER | Percent of remaining depreciation after a revaluation or an amortized change, or 1 | ||
| FORMULA_FACTOR | NUMBER | Factor used to adjust the depreciation rate for formula-based NBV-based assets | ||
| EOFY_RESERVE | NUMBER | Accumulated depreciation at the end of the previous fiscal year | ||
| IMPAIR_CLASS | VARCHAR2 | (3) | Impairment classification type | |
| REASON | VARCHAR2 | (100) | Reason description | |
| IMPAIR_LOSS_ACCT | VARCHAR2 | (25) | Loss account to which the impairment loss must be booked | |
| SPLIT_IMPAIR_FLAG | VARCHAR2 | (1) | Indicates whether the impairment is split or not. A value of Y indicates that the impairment is split. Any other value indicates that the impairment is not split | |
| SPLIT1_IMPAIR_CLASS | VARCHAR2 | (3) | Split 1 impairment classification type | |
| SPLIT1_REASON | VARCHAR2 | (100) | Split 1 Reason description | |
| SPLIT1_LOSS_AMOUNT | NUMBER | Split 1 Loss Amount calculated internally from Split 1 Percentage | ||
| SPLIT1_REVAL_RESERVE | NUMBER | Amount of Revaluation Reserved adjusted by Split 1 | ||
| SPLIT1_PERCENT | NUMBER | (3) | Split 1 Percentage | |
| SPLIT1_LOSS_ACCT | VARCHAR2 | (25) | Split 1 Loss Account to which the impairment loss must be booked | |
| SPLIT1_PROCESS_ORDER | NUMBER | The order in which Split 1 was processed | ||
| SPLIT2_IMPAIR_CLASS | VARCHAR2 | (3) | Split 2 impairment classification type | |
| SPLIT2_REASON | VARCHAR2 | (100) | Split 2 Reason description | |
| SPLIT2_LOSS_AMOUNT | NUMBER | Split 2 Loss Amount calculated internally from Split 2 Percentage | ||
| SPLIT2_REVAL_RESERVE | NUMBER | Amount of Revaluation Reserved adjusted by Split 2 | ||
| SPLIT2_PERCENT | NUMBER | (3) | Split 2 Percentage | |
| SPLIT2_LOSS_ACCT | VARCHAR2 | (25) | Split 2 Loss Account to which the impairment loss must be booked | |
| SPLIT2_PROCESS_ORDER | NUMBER | The order in which Split 2 was processed | ||
| SPLIT3_IMPAIR_CLASS | VARCHAR2 | (3) | Split 3 impairment classification type | |
| SPLIT3_REASON | VARCHAR2 | (100) | Split 3 Reason description | |
| SPLIT3_LOSS_AMOUNT | NUMBER | Split 3 Loss Amount calculated internally from Split 3 Percentage | ||
| SPLIT3_REVAL_RESERVE | VARCHAR2 | (240) | Amount of Revaluation Reserved adjusted by Split 3 | |
| SPLIT3_PERCENT | NUMBER | (3) | Split 3 Percentage | |
| SPLIT3_LOSS_ACCT | VARCHAR2 | (25) | Split 3 Loss Account to which the impairment loss must be booked | |
| SPLIT3_PROCESS_ORDER | NUMBER | The order in which Split 3 was processed | ||
| CAPITAL_ADJUSTMENT | NUMBER | The value of Capital Adjustment after considering impairment effect | ||
| GENERAL_FUND | NUMBER | The value of General Fund after considering impairment effect | ||
| REVERSED_IMP_AMT | NUMBER | The amount of impairment loss amount attributed to I&E account reversed | ||
| REVERSED_IMP_AMT_S1 | NUMBER | The amount of Split 1 impairment loss amount attributed to I&E account reversed | ||
| REVERSED_IMP_AMT_S2 | NUMBER | The amount of Split 2 impairment loss amount attributed to I&E account reversed | ||
| REVERSED_IMP_AMT_S3 | NUMBER | The amount of Split 3 impairment loss amount attributed to I&E account reversed | ||
| REVERSED_DEPRN_IMPACT | NUMBER | The amount of depreciation impact attributed to I&E account reversed | ||
| REVERSED_DEPRN_IMPACT_S1 | NUMBER | The amount of Split 1 depreciation impact attributed to I&E account reversed | ||
| REVERSED_DEPRN_IMPACT_S2 | NUMBER | The amount of Split 2 depreciation impact attributed to I&E account reversed | ||
| REVERSED_DEPRN_IMPACT_S3 | NUMBER | The amount of Split 3 depreciation impact attributed to I&E account reversed | ||
| REVERSED_REVAL_AMT | NUMBER | The amount of impairment loss amount attributed to Revaluation Reserve account reversed | ||
| REVERSED_REVAL_AMT_S1 | NUMBER | The amount of Split 1 impairment loss amount attributed to Revaluation Reserve account reversed | ||
| REVERSED_REVAL_AMT_S2 | NUMBER | The amount of Split 2 impairment loss amount attributed to Revaluation Reserve account reversed | ||
| REVERSED_REVAL_AMT_S3 | NUMBER | The amount of Split 3 impairment loss amount attributed to Revaluation Reserve account reversed | ||
| REVERSED_REVAL_IMPACT | NUMBER | The amount of depreciation impact attributed to Revaluation Reserve account reversed | ||
| REVERSED_REVAL_IMPACT_S1 | NUMBER | The amount of Split 1 depreciation impact attributed to Revaluation Reserve account reversed | ||
| REVERSED_REVAL_IMPACT_S2 | NUMBER | The amount of Split 2 depreciation impact attributed to Revaluation Reserve account reversed | ||
| REVERSED_REVAL_IMPACT_S3 | NUMBER | The amount of Split 3 depreciation impact attributed to Revaluation Reserve account reversed | ||
| IMPAIRMENT_RESERVE | NUMBER | Life-to-date Impairment amount | ||
| ALLOWED_DEPRN_LIMIT_AMOUNT | NUMBER | Asset Depreciation limit | ||
| REVAL_LOSS_BALANCE | NUMBER | Revaluation Loss amount |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, IMPAIRMENT_ID
, BOOK_TYPE_CODE
, ASSET_ID
, CASH_GENERATING_UNIT_ID
, NET_BOOK_VALUE
, NET_SELLING_PRICE
, VALUE_IN_USE
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, LTD_IMPAIRMENT
, GOODWILL_ASSET_FLAG
, DEPRN_RUN_DATE
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, ADJUSTED_COST
, BONUS_RATE
, LTD_PRODUCTION
, PERIOD_COUNTER
, PRODUCTION
, REVAL_AMORTIZATION
, REVAL_AMORTIZATION_BASIS
, REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
, YTD_PRODUCTION
, YTD_REVAL_DEPRN_EXPENSE
, PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT
, DEPRN_ADJUSTMENT_AMOUNT
, BONUS_DEPRN_ADJUSTMENT_AMOUNT
, REVAL_RESERVE_ADJ_AMOUNT
, COST
, PERIOD_OF_ADDITION_FLAG
, CURRENT_UNITS
, CATEGORY_ID
, IMPAIRMENT_DATE
, WORKER_ID
, PROCESS_ORDER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RATE_ADJUSTMENT_FACTOR
, FORMULA_FACTOR
, EOFY_RESERVE
, IMPAIR_CLASS
, REASON
, IMPAIR_LOSS_ACCT
, SPLIT_IMPAIR_FLAG
, SPLIT1_IMPAIR_CLASS
, SPLIT1_REASON
, SPLIT1_LOSS_AMOUNT
, SPLIT1_REVAL_RESERVE
, SPLIT1_PERCENT
, SPLIT1_LOSS_ACCT
, SPLIT1_PROCESS_ORDER
, SPLIT2_IMPAIR_CLASS
, SPLIT2_REASON
, SPLIT2_LOSS_AMOUNT
, SPLIT2_REVAL_RESERVE
, SPLIT2_PERCENT
, SPLIT2_LOSS_ACCT
, SPLIT2_PROCESS_ORDER
, SPLIT3_IMPAIR_CLASS
, SPLIT3_REASON
, SPLIT3_LOSS_AMOUNT
, SPLIT3_REVAL_RESERVE
, SPLIT3_PERCENT
, SPLIT3_LOSS_ACCT
, SPLIT3_PROCESS_ORDER
, CAPITAL_ADJUSTMENT
, GENERAL_FUND
, REVERSED_IMP_AMT
, REVERSED_IMP_AMT_S1
, REVERSED_IMP_AMT_S2
, REVERSED_IMP_AMT_S3
, REVERSED_DEPRN_IMPACT
, REVERSED_DEPRN_IMPACT_S1
, REVERSED_DEPRN_IMPACT_S2
, REVERSED_DEPRN_IMPACT_S3
, REVERSED_REVAL_AMT
, REVERSED_REVAL_AMT_S1
, REVERSED_REVAL_AMT_S2
, REVERSED_REVAL_AMT_S3
, REVERSED_REVAL_IMPACT
, REVERSED_REVAL_IMPACT_S1
, REVERSED_REVAL_IMPACT_S2
, REVERSED_REVAL_IMPACT_S3
, IMPAIRMENT_RESERVE
, ALLOWED_DEPRN_LIMIT_AMOUNT
, REVAL_LOSS_BALANCE
FROM FA.FA_ITF_IMPAIRMENTS;
FA.FA_ITF_IMPAIRMENTS does not reference any database object
FA.FA_ITF_IMPAIRMENTS is referenced by following:
FA
FA_ITF_IMPAIRMENTS#
|
|
|
|