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

VIEW: APPS.FA_DEPRN_DETAIL_H_MRC_V

Object Details
Object Name: FA_DEPRN_DETAIL_H_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_DEPRN_DETAIL_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

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
PERIOD_COUNTER NUMBER (15)
Depreciation period
DISTRIBUTION_ID NUMBER (15)
Identifies the distribution line that contains the asset
DEPRN_SOURCE_CODE VARCHAR2 (1)
Indicates whether the depreciation record was created by the Books window (B), by running the Depreciation program (D), or by the Member Asset Tracking functionality (T)
DEPRN_RUN_DATE DATE

Date depreciation was run
DEPRN_AMOUNT NUMBER

Depreciation expense allocated to the distribution line for the current period
YTD_DEPRN NUMBER

Year-to-date depreciation expense allocated to the distribution line
DEPRN_RESERVE NUMBER

Year-to-date depreciation expense allocated to the distribution line
ADDITION_COST_TO_CLEAR NUMBER

Asset cost in row for period before period you added the asset
COST NUMBER

Asset cost
DEPRN_ADJUSTMENT_AMOUNT NUMBER

Depreciation adjustment amount
REVAL_AMORTIZATION NUMBER

Amount of revaluation reserve amortized during this period
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 the net book value due to revaluation of the asset cost and sometimes the revaluation of the depreciation reserve. For all other periods: the revaluation reserve amount after depreciation is run
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
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
BONUS_DEPRN_ADJUSTMENT_AMOUNT NUMBER

Bonus depreciation adjustment amount
DEPRN_EXPENSE_CCID NUMBER (15)
DEPRN_RESERVE_CCID NUMBER (15)
BONUS_DEPRN_EXPENSE_CCID NUMBER (15)
BONUS_DEPRN_RESERVE_CCID NUMBER (15)
REVAL_AMORT_CCID NUMBER (15)
REVAL_RESERVE_CCID NUMBER (15)
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
Query Text

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


SELECT SET_OF_BOOKS_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      PERIOD_COUNTER
,      DISTRIBUTION_ID
,      DEPRN_SOURCE_CODE
,      DEPRN_RUN_DATE
,      DEPRN_AMOUNT
,      YTD_DEPRN
,      DEPRN_RESERVE
,      ADDITION_COST_TO_CLEAR
,      COST
,      DEPRN_ADJUSTMENT_AMOUNT
,      REVAL_AMORTIZATION
,      REVAL_DEPRN_EXPENSE
,      REVAL_RESERVE
,      YTD_REVAL_DEPRN_EXPENSE
,      BONUS_DEPRN_AMOUNT
,      BONUS_YTD_DEPRN
,      BONUS_DEPRN_RESERVE
,      BONUS_DEPRN_ADJUSTMENT_AMOUNT
,      DEPRN_EXPENSE_CCID
,      DEPRN_RESERVE_CCID
,      BONUS_DEPRN_EXPENSE_CCID
,      BONUS_DEPRN_RESERVE_CCID
,      REVAL_AMORT_CCID
,      REVAL_RESERVE_CCID
,      EVENT_ID
,      DEPRN_RUN_ID
,      REVERSAL_EVENT_ID
,      REVERSAL_DATE
FROM APPS.FA_DEPRN_DETAIL_H_MRC_V;

Dependencies

[top of page]

APPS.FA_DEPRN_DETAIL_H_MRC_V references the following:

SchemaAPPS
SynonymFA_MC_DEPRN_DETAIL_H

APPS.FA_DEPRN_DETAIL_H_MRC_V is not referenced by any database object