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

VIEW: APPS.FA_DEPRN_SUMMARY_H_MRC_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15)
Reporting set of books identification number for GL sets of books
BOOK_TYPE_CODE VARCHAR2 (15)
Book name
ASSET_ID NUMBER (15)
Asset identification number
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
DEPRN_SOURCE_CODE VARCHAR2 (15)
Indicates whether the depreciation record was created by the Books window (BOOKS), by running the Depreciation program (DEPRN), or by the Member Asset Tracking functionality (TRACK)
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

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. Updated only when the asset is revalued or has an amortized adjustment
REVAL_DEPRN_EXPENSE NUMBER

Portion of depreciation expense due to revaluation of the asset cost. Oracle Assets does not create any journal entries for this amount. It is for reporting only
REVAL_RESERVE NUMBER

For a period in which this asset was revalued: change in net book value due to revaluation of asset cost and sometimes also revaluation of depreciation reserve. For all other periods: 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. Oracle Assets does not create any journal entries for this amount. It is for reporting only
PRIOR_FY_EXPENSE NUMBER

Depreciation expense due to prior fiscal years
BONUS_DEPRN_AMOUNT NUMBER

Bonus depreciation expense for this depreciation period. Amount included in deprn_amount
BONUS_YTD_DEPRN NUMBER

Bonus year-to-date depreciation expense. Amount included in ytd_deprn
BONUS_DEPRN_RESERVE NUMBER

Total bonus depreciation taken since the beginning of the asset life. Amount included in deprn_reserve
PRIOR_FY_BONUS_EXPENSE NUMBER

Bonus Depreciation expense due to prior fiscal years
DEPRN_OVERRIDE_FLAG VARCHAR2 (1)
Override status ('D' - stands for depreciation amount was overridden, 'B' stands for bonus amount was overridden, 'A' stands for depreciation and bonus amounts were overridden)
SYSTEM_DEPRN_AMOUNT NUMBER

System calculated depreciation amount (this amount is stored only when the tracking member method is specified)
SYSTEM_BONUS_DEPRN_AMOUNT NUMBER

System calculated Depreciation Amount (this amount is stored only when the tracking member method is specified)
EVENT_ID NUMBER (38)
Event internal identifier
DEPRN_RUN_ID NUMBER (15)
Depreciation submission internal identifier
REVERSAL_EVENT_ID NUMBER (38)
Reversal event internal identifier
REVERSAL_DATE DATE

Date on which the depreciation was reversed
DEPRN_ADJUSTMENT_AMOUNT NUMBER

Depreciation adjustment amount
BONUS_DEPRN_ADJUSTMENT_AMOUNT NUMBER

Bonus depreciation adjustment amount
Query Text

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


SELECT SET_OF_BOOKS_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      DEPRN_RUN_DATE
,      DEPRN_AMOUNT
,      YTD_DEPRN
,      DEPRN_RESERVE
,      DEPRN_SOURCE_CODE
,      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
,      EVENT_ID
,      DEPRN_RUN_ID
,      REVERSAL_EVENT_ID
,      REVERSAL_DATE
,      DEPRN_ADJUSTMENT_AMOUNT
,      BONUS_DEPRN_ADJUSTMENT_AMOUNT
FROM APPS.FA_DEPRN_SUMMARY_H_MRC_V;

Dependencies

[top of page]

APPS.FA_DEPRN_SUMMARY_H_MRC_V references the following:

SchemaAPPS
SynonymFA_MC_DEPRN_SUMMARY_H

APPS.FA_DEPRN_SUMMARY_H_MRC_V is not referenced by any database object