eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the 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 appear to do anything.

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

TABLE: FA.FA_MC_DEFERRED_DEPRN

Object Details

Object Name:	FA_MC_DEFERRED_DEPRN
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_MC_DEFERRED_DEPRN
Subobject Name:
Status:	VALID

FA_MC_DEFERRED_DEPRN is an MRC sub-table of FA_DEFERRED_DEPRN. This
table stores currency and financial information about deferred
depreciation amounts per asset in each reporting book, associated
with the parent record in FA_ DEFERRED_DEPRN. Oracle Assets uses
this information to create deferred journal entries to the Reporting
Set of Books in General Ledger.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MC_DEFERRED_DEPRN_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID SET_OF_BOOKS_ID
FA_MC_DEFERRED_DEPRN_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID CORP_BOOK_TYPE_CODE CORP_PERIOD_COUNTER TAX_BOOK_TYPE_CODE TAX_PERIOD_COUNTER SET_OF_BOOKS_ID
FA_MC_DEFERRED_DEPRN_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CORP_BOOK_TYPE_CODE TAX_BOOK_TYPE_CODE CORP_PERIOD_COUNTER TAX_PERIOD_COUNTER SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Reporting set of books identification number for GL sets of books
CORP_BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Corporate depreciation book
TAX_BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Tax depreciation book
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
DISTRIBUTION_ID	NUMBER	(15)	Yes	Distribution identification number
DEFERRED_DEPRN_EXPENSE_CCID	NUMBER	(15)		Distribution identification number
DEFERRED_DEPRN_RESERVE_CCID	NUMBER	(15)		Deferred depreciation reserve Accounting Flexfield combination from tax book and distribution
DEFERRED_DEPRN_EXPENSE_AMOUNT	NUMBER		Yes	Deferred depreciation expense amount
DEFERRED_DEPRN_RESERVE_AMOUNT	NUMBER		Yes	Deferred depreciation reserve amount
CORP_PERIOD_COUNTER	NUMBER	(15)	Yes	Deferred depreciation period counter in the corporate book
TAX_PERIOD_COUNTER	NUMBER	(15)	Yes	Deferred depreciation period counter in the tax book
JE_HEADER_ID	NUMBER	(15)		Journal entry header for deferred depreciation
EXPENSE_JE_LINE_NUM	NUMBER	(15)		Journal entry line number for deferred depreciation expense journal entry
RESERVE_JE_LINE_NUM	NUMBER	(15)		Journal entry line number for deferred depreciation reserve journal entry
EVENT_ID	NUMBER	(38)		Event internal identifier

Query Text

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


SELECT SET_OF_BOOKS_ID
,      CORP_BOOK_TYPE_CODE
,      TAX_BOOK_TYPE_CODE
,      ASSET_ID
,      DISTRIBUTION_ID
,      DEFERRED_DEPRN_EXPENSE_CCID
,      DEFERRED_DEPRN_RESERVE_CCID
,      DEFERRED_DEPRN_EXPENSE_AMOUNT
,      DEFERRED_DEPRN_RESERVE_AMOUNT
,      CORP_PERIOD_COUNTER
,      TAX_PERIOD_COUNTER
,      JE_HEADER_ID
,      EXPENSE_JE_LINE_NUM
,      RESERVE_JE_LINE_NUM
,      EVENT_ID
FROM FA.FA_MC_DEFERRED_DEPRN;

Dependencies

[top of page]

FA.FA_MC_DEFERRED_DEPRN does not reference any database object

FA.FA_MC_DEFERRED_DEPRN is referenced by following:

FA: FA_MC_DEFERRED_DEPRN#