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

TABLE: FA.FA_DEFERRED_DEPRN

Object Details
Object Name: FA_DEFERRED_DEPRN
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_DEFERRED_DEPRN
Subobject Name:
Status: VALID


This table contains the deferred depreciation amounts calculated
for each distribution when you create deferred journal entries.
Oracle Assets uses this information to create deferred journal
entries for your general ledger.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_DEFERRED_DEPRN_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
FA_DEFERRED_DEPRN_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_ID
ColumnCORP_BOOK_TYPE_CODE
ColumnCORP_PERIOD_COUNTER
ColumnTAX_BOOK_TYPE_CODE
ColumnTAX_PERIOD_COUNTER
FA_DEFERRED_DEPRN_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCORP_BOOK_TYPE_CODE
ColumnTAX_BOOK_TYPE_CODE
ColumnCORP_PERIOD_COUNTER
ColumnTAX_PERIOD_COUNTER
Columns
Name Datatype Length Mandatory Comments
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)
Deferred depreciation expense Accounting Flexfield combination from tax book and distribution
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 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_DEFERRED_DEPRN;

Dependencies

[top of page]

FA.FA_DEFERRED_DEPRN does not reference any database object

FA.FA_DEFERRED_DEPRN is referenced by following:

SchemaFA
ViewFA_DEFERRED_DEPRN#