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

VIEW: APPS.FA_DEPRN_SUMMARY_MRC_V

Object Details
Object Name: FA_DEPRN_SUMMARY_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_DEPRN_SUMMARY_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) Yes Reporting set of books identification number for GL sets of books
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book name
ASSET_ID NUMBER (15) Yes Asset identification number
DEPRN_RUN_DATE DATE
Yes System date when depreciation was run
DEPRN_AMOUNT NUMBER
Yes Depreciation expense in the reporting currency for this depreciation period
YTD_DEPRN NUMBER
Yes Year-to-date depreciation expense in the reporting currency
DEPRN_RESERVE NUMBER
Yes Total depreciation in the reporting currency, taken since beginning of asset life
DEPRN_SOURCE_CODE VARCHAR2 (15) Yes 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
Yes 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) Yes 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 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 is stored only when the tracking member method is specified)
SYSTEM_BONUS_DEPRN_AMOUNT NUMBER

System calculated Bonus Depreciation Amount (this is stored only when tracking member method is specified)
EVENT_ID NUMBER (38)
Event internal identifier
DEPRN_RUN_ID NUMBER (15)
Depreciation submission internal identifier
DEPRN_ADJUSTMENT_AMOUNT NUMBER

Depreciation adjustment amount
BONUS_DEPRN_ADJUSTMENT_AMOUNT NUMBER

Bonus depreciation adjustment amount
IMPAIRMENT_AMOUNT NUMBER

YTD_IMPAIRMENT NUMBER

IMPAIRMENT_RESERVE NUMBER

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
,      DEPRN_ADJUSTMENT_AMOUNT
,      BONUS_DEPRN_ADJUSTMENT_AMOUNT
,      IMPAIRMENT_AMOUNT
,      YTD_IMPAIRMENT
,      IMPAIRMENT_RESERVE
FROM APPS.FA_DEPRN_SUMMARY_MRC_V;

Dependencies

[top of page]

APPS.FA_DEPRN_SUMMARY_MRC_V references the following:

SchemaAPPS
SynonymFA_MC_DEPRN_SUMMARY
APPS.FA_DEPRN_SUMMARY_MRC_V is referenced by following:

SchemaAPPS
Package BodyFA_BALREP_PKG - show dependent code
Package BodyFA_FAS400_XMLP_PKG - show dependent code
Package BodyFA_FAS401_XMLP_PKG - show dependent code
Package BodyFA_FAS403_XMLP_PKG - show dependent code
Package BodyFA_FAS480_XMLP_PKG - show dependent code
Package BodyFA_FASCOSTD_XMLP_PKG - show dependent code
Package BodyFA_FASCOSTS_XMLP_PKG - show dependent code
Package BodyFA_FASRSVED_XMLP_PKG - show dependent code
Package BodyFA_FASRSVES_XMLP_PKG - show dependent code
Package BodyFA_RES_LDG_PKG - show dependent code
Package BodyFA_RSVLDG_REP_INS_PKG - show dependent code
Package BodyFA_TOFES_YUD_ALEF_PKG - show dependent code
Package BodyJL_JLMXFGLR_XMLP_PKG - show dependent code
Package BodyJL_JLMXFISR_XMLP_PKG - show dependent code
Package BodyJL_ZZ_FA_FUNCTIONS_PKG - show dependent code