eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not ap [Dependency Information]TABLE: FA.FA_DEPRN_DETAILObject DetailsObject Name:FA_DEPRN _DETAILObjectType:TABLE Owner:FAFND Design Data:OFA.FA_D EPRN_DET AILSubobjectName:Status:VALIDFA_DEPRN_DETAIL contains the depreciation amounts that thedepreciation program charges to the depreciation expense accountin each distribution line. Oracle Assets uses this information tocreate depreciation expense journal entries for your generalledger..The depreciation program inserts one row per distribution line foran asset each time you run depreciation. For example, if youassign an asset to two different cost centers, the depreciationprogram inserts two rows in this table for the asset..DEPRN_AMOUNT is the amount of depreciation expense calculated forthis distribution line..YTD_DEPRN is the year-to-date depreciation allocated to thisdistribution line..When you add an asset, Oracle Assets inserts a row into this tablefor the period before the current period. This row has the assetcost in the ADDITION_COST_TO_CLEAR column and a DEPRN_SOURCE_CODE of 'B'. This column is used forreporting on new assets. When you run depreciation, Oracle Assetstransfers the cost to the COST column in the current period row,this row has a DEPRN_SOURCE_CODE of 'D'. .Storage DetailsTablespace :APPS_TS_ TX_DATAPCT Free:10 PCT Used:IndexesIndex Type Uniqueness Tablespace ColumnDISTRIBUTION_IDBOOK_TYPE_CODEPERIOD_COUNTERASSET_IDBOOK_TYPE_CODEPERIOD_COUNTERBOOK_TYPE_CODEPERIOD_COUNTERColumnsName Datatype Length Mandatory Comments BOOK_TYPE_CODEVARCHAR2-15Yes Book nameASSET_ID NUMBER-15Yes Assetidentification numberPERIOD_C OUNTER NUMBER-15Yes Depreciation periodDISTRIBUTI ON_ID NUMBER-15Yes Identifiesthedistributionline thatcontains theassetFA_DEPRN _DETAIL_U 1NORMAL UNIQUE APPS_TS_TX_IDXFA_DEPRN _DETAIL_N 2NORMAL NONUNIQUEAPPS_TS_TX_IDXFA_DEPRN _DETAIL_N 1NORMAL NONUNIQUEAPPS_TS_TX_IDXQuery TextCut, 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_NUMFROM 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:APPSFABV_DEPRECIATIONSFAFV_DEPRECIATIONSFARX_AD - show dependent codeFARX_AL - show dependent codeFARX_BL - show dependent codeFA_ADJUSTMENT_PVT - show dependent codeFA_ASSET_VAL_PVT - show dependent codeFA_CUA_DEPR_PKG - show dependent codeFA_DELETION_PUB - show dependent codeFA_DEPRN_DETAIL_PKG - show dependent codeFA_DEPRN_ROLLBACK_PKG - show dependent codeFA_DEPRN_WEB_VFA_FINANCIAL_INQUIRY_DEPRN_VFA_FIN_INQRY_DEPRN_WEB_VFA_GAINLOSS_UPD_PKG - show dependent codeFA_INS_DETAIL_PKG - show dependent codeFA_JE_ROLLBACK_PKG - show dependent codeFA_MC_UPG2_PKG - show dependent codeFA_MC_UPG3_PKG - show dependent codeFA_QUERY_BALANCES_PKG - show dependent codeFA_RETIRE_PVT_PKG - show dependent codeFA_RX_SHARED_PKG - show dependent codeFA_STD_TYPES - show dependent codeFA_TRACK_MEMBER_PVT - show dependent codeFA_UNPLANNED_PVT - show dependent codeFA_WHATIF_DEPRN2_PKG - show dependent codeIGIRX_IMP_IAC_REP - show dependent codeIGI_IAC_ADJ_AMORT_PKG - show dependent codeIGI_IAC_ADJ_COST_REVAL_PKG - show dependent codeIGI_IAC_ADJ_PKG - show dependent codeIGI_IAC_DEPRN_PKG - show dependent codeIGI_IAC_PROJ_PKG - show dependent codeIGI_IAC_REINSTATE_PKG - show dependent codeIGI_IAC_REVAL_CRUD - show dependent codeIGI_IAC_REVAL_UTILITIES - show dependent codeIGI_IAC_TRANSFERS_PKG - show dependent codeIGI_IAC_TYPES - show dependent codeIGI_IAC_YTD_PRE_PROCESS_PKG - show dependent code IGI_IMP_IAC_PREPARE_PKG - show dependent codeIGI_IMP_IAC_TRANSFER_PKG - show dependent codeIGI_MHC_ASSET_BALANCE - show dependent codeIGI_MHC_ASSET_BALANCE - show dependent codeIGI_MHC_DEPRN_POST_UTILS_PKG - show dependent code IGI_MHC_REVAL_UTILS - show dependent codeIGI_MHC_TFR_TXNS_PKG - show dependent codeJL_CO_FA_ACCOUNTING_PKG - show dependent codeJL_ZZ_FA_DEPRN_ADJ_PKG - show dependent codeMC_FA_UTILITIES_PKG - show dependent codeOKL_ACCOUNT_BALANCES_VOKL_FA_DIST_UVOKL_FA_TRX_LINE_UVCopyright (c) 2001 - 2005, OracleOracle Proprietary, Confidential Information- Use Restricted by Contractser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature wille window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not apk on a link that does not appear to do anything.。