OracleERP表结构

eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not ap [Dependency Information]

TABLE: FA.FA_DEPRN_DETAIL

Object Details

Object Name:FA_DEPRN _DETAIL

Object

Type:

TABLE Owner:FA

FND Design Data:OFA.FA_D EPRN_DET AIL

Subobject

Name:

Status:VALID

FA_DEPRN_DETAIL contains the depreciation amounts that the

depreciation program charges to the depreciation expense account

in each distribution line. Oracle Assets uses this information to

create depreciation expense journal entries for your general

ledger.

The depreciation program inserts one row per distribution line for

an asset each time you run depreciation. For example, if you

assign an asset to two different cost centers, the depreciation

program inserts two rows in this table for the asset.

DEPRN_AMOUNT is the amount of depreciation expense calculated for

this distribution line.

YTD_DEPRN is the year-to-date depreciation allocated to this

distribution line.

When you add an asset, Oracle Assets inserts a row into this table

for the period before the current period. This row has the asset

cost in the ADDITION_COST_TO_CLEAR column and a DEPRN_SOURCE_CODE of 'B'. This column is used for

reporting on new assets. When you run depreciation, Oracle Assets

transfers the cost to the COST column in the current period row,

this row has a DEPRN_SOURCE_CODE of 'D'. .

Storage Details

Tablespace :APPS_TS_ TX_DATA

PCT Free:10 PCT Used:

Indexes

Index Type Uniquenes

s Tablespace Column

DISTRIBUTI

ON_ID

BOOK_TYP

E_CODE

PERIOD_C

OUNTER

ASSET_ID

BOOK_TYP

E_CODE

PERIOD_C

OUNTER

BOOK_TYP

E_CODE

PERIOD_C

OUNTER

Columns

Name Datatype Length Mandatory Comments BOOK_TYP

E_CODE

VARCHAR2-15Yes Book name

ASSET_ID NUMBER-15Yes Asset

identificatio

n number

PERIOD_C OUNTER NUMBER-15Yes Depreciatio

n period

DISTRIBUTI ON_ID NUMBER-15Yes Identifies

the

distribution

line that

contains the

asset

FA_DEPRN _DETAIL_U 1NORMAL UNIQUE APPS_TS_

TX_IDX

FA_DEPRN _DETAIL_N 2NORMAL NONUNIQU

APPS_TS_

TX_IDX

FA_DEPRN _DETAIL_N 1NORMAL NONUNIQU

APPS_TS_

TX_IDX

Query Text

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

SELECT 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

, DEPRN_EXPENSE_JE_LINE_NUM

, DEPRN_RESERVE_JE_LINE_NUM

, REVAL_AMORT_JE_LINE_NUM

, REVAL_RESERVE_JE_LINE_NUM

, JE_HEADER_ID

, REVAL_AMORTIZATION

, REVAL_DEPRN_EXPENSE

, REVAL_RESERVE

, YTD_REVAL_DEPRN_EXPENSE

, BONUS_DEPRN_AMOUNT

, BONUS_YTD_DEPRN

, BONUS_DEPRN_RESERVE

, BONUS_DEPRN_ADJUSTMENT_AMOUNT

, BONUS_DEPRN_EXP_JE_LINE_NUM

, BONUS_DEPRN_RSV_JE_LINE_NUM

FROM FA.FA_DEPRN_DETAIL;

Dependencies

[top of page]

FA.FA_DEPRN_DETAIL does not reference any database object FA.FA_DEPRN_DETAIL is referenced by following:

APPS

FABV_DEPRECIATIONS

FAFV_DEPRECIATIONS

FARX_AD - show dependent code

FARX_AL - show dependent code

FARX_BL - show dependent code

FA_ADJUSTMENT_PVT - show dependent code

FA_ASSET_VAL_PVT - show dependent code

FA_CUA_DEPR_PKG - show dependent code

FA_DELETION_PUB - show dependent code

FA_DEPRN_DETAIL_PKG - show dependent code

FA_DEPRN_ROLLBACK_PKG - show dependent code

FA_DEPRN_WEB_V

FA_FINANCIAL_INQUIRY_DEPRN_V

FA_FIN_INQRY_DEPRN_WEB_V

FA_GAINLOSS_UPD_PKG - show dependent code

FA_INS_DETAIL_PKG - show dependent code

FA_JE_ROLLBACK_PKG - show dependent code

FA_MC_UPG2_PKG - show dependent code

FA_MC_UPG3_PKG - show dependent code

FA_QUERY_BALANCES_PKG - show dependent code

FA_RETIRE_PVT_PKG - show dependent code

FA_RX_SHARED_PKG - show dependent code

FA_STD_TYPES - show dependent code

FA_TRACK_MEMBER_PVT - show dependent code

FA_UNPLANNED_PVT - show dependent code

FA_WHATIF_DEPRN2_PKG - show dependent code

IGIRX_IMP_IAC_REP - show dependent code

IGI_IAC_ADJ_AMORT_PKG - show dependent code

IGI_IAC_ADJ_COST_REVAL_PKG - show dependent code

IGI_IAC_ADJ_PKG - show dependent code

IGI_IAC_DEPRN_PKG - show dependent code

IGI_IAC_PROJ_PKG - show dependent code

IGI_IAC_REINSTATE_PKG - show dependent code

IGI_IAC_REVAL_CRUD - show dependent code

IGI_IAC_REVAL_UTILITIES - show dependent code

IGI_IAC_TRANSFERS_PKG - show dependent code

IGI_IAC_TYPES - show dependent code

IGI_IAC_YTD_PRE_PROCESS_PKG - show dependent code IGI_IMP_IAC_PREPARE_PKG - show dependent code

IGI_IMP_IAC_TRANSFER_PKG - show dependent code

IGI_MHC_ASSET_BALANCE - show dependent code

IGI_MHC_DEPRN_POST_UTILS_PKG - show dependent code IGI_MHC_REVAL_UTILS - show dependent code

IGI_MHC_TFR_TXNS_PKG - show dependent code

JL_CO_FA_ACCOUNTING_PKG - show dependent code

JL_ZZ_FA_DEPRN_ADJ_PKG - show dependent code

MC_FA_UTILITIES_PKG - show dependent code

OKL_ACCOUNT_BALANCES_V

OKL_FA_DIST_UV

OKL_FA_TRX_LINE_UV

Oracle Proprietary, Confidential Information

- Use Restricted by Contract

ser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will

e window focus feature will not work. Please check the contents o

f other windows on your desktop if you click on a link that does not ap

k on a link that does not appear to do anything.