DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FA_ITF_IMPAIRMENTS_MRC_V

Object Details
Object Name: FA_ITF_IMPAIRMENTS_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_ITF_IMPAIRMENTS_MRC_V
Subobject Name:
Status: VALID

View Type

A multiple reporting currency view


FA_ITF_IMPAIRMENTS_MRC_V is the MRC - Multiple Reporting Currency view on top of FA_MC_ITF_IMPAIRMENTS.


[View Source]

Columns
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
SET_OF_BOOKS_ID NUMBER (15) Yes Reporting set of books identification number for General Ledger sets of books
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
IMPAIRMENT_RESERVE NUMBER

Life-to-date Impairment amount
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
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
REVAL_RESERVE_ADJ_AMOUNT NUMBER

Change in revaluation reserve amount due to an impairment transaction
WORKER_ID NUMBER (15)
Worker identification number for parallel processing
PROCESS_ORDER NUMBER (15)
Identifies when to process this record for parallel processing
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
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_ID
,      IMPAIRMENT_ID
,      BOOK_TYPE_CODE
,      SET_OF_BOOKS_ID
,      ASSET_ID
,      CASH_GENERATING_UNIT_ID
,      NET_BOOK_VALUE
,      NET_SELLING_PRICE
,      VALUE_IN_USE
,      IMPAIRMENT_AMOUNT
,      YTD_IMPAIRMENT
,      IMPAIRMENT_RESERVE
,      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
,      COST
,      PERIOD_OF_ADDITION_FLAG
,      CURRENT_UNITS
,      CATEGORY_ID
,      IMPAIRMENT_DATE
,      REVAL_RESERVE_ADJ_AMOUNT
,      WORKER_ID
,      PROCESS_ORDER
,      RATE_ADJUSTMENT_FACTOR
,      FORMULA_FACTOR
,      EOFY_RESERVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.FA_ITF_IMPAIRMENTS_MRC_V;

Dependencies

[top of page]

APPS.FA_ITF_IMPAIRMENTS_MRC_V references the following:

SchemaAPPS
SynonymFA_MC_ITF_IMPAIRMENTS

APPS.FA_ITF_IMPAIRMENTS_MRC_V is not referenced by any database object