[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

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

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:

APPS

FA_MC_DEFERRED_DEPRN