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_TRACK_MEMBERS

Object Details

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

Temporary Table Details

FA.FA_TRACK_MEMBERS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_TRACK_MEMBERS_N1	NORMAL	NONUNIQUE		MEMBER_ASSET_ID GROUP_ASSET_ID PERIOD_COUNTER

Columns

Name	Datatype	Length
TRACK_MEMBER_ID	NUMBER	(15)
GROUP_ASSET_ID	NUMBER	(15)
MEMBER_ASSET_ID	NUMBER	(15)
PERIOD_COUNTER	NUMBER	(15)
FISCAL_YEAR	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER
ALLOCATION_BASIS	NUMBER
TOTAL_ALLOCATION_BASIS	NUMBER
ALLOCATED_DEPRN_AMOUNT	NUMBER
ALLOCATED_BONUS_AMOUNT	NUMBER
SYSTEM_DEPRN_AMOUNT	NUMBER
SYSTEM_BONUS_AMOUNT	NUMBER
FULLY_RESERVED_FLAG	VARCHAR2	(1)
FULLY_RETIRED_FLAG	VARCHAR2	(1)
OVERRIDE_FLAG	VARCHAR2	(1)
COST	NUMBER
ADJUSTED_COST	NUMBER
EOFY_ADJ_COST	NUMBER
RECOVERABLE_COST	NUMBER
SALVAGE_VALUE	NUMBER
ADJUSTED_RECOVERABLE_COST	NUMBER
PRIOR_YEAR_RESERVE	NUMBER
EOFY_AMOUNT	NUMBER
DEPRN_RESERVE	NUMBER
YTD_DEPRN	NUMBER
BONUS_DEPRN_RESERVE	NUMBER
BONUS_YTD_DEPRN	NUMBER
EOFY_RECOVERABLE_COST	NUMBER
EOP_RECOVERABLE_COST	NUMBER
EOFY_SALVAGE_VALUE	NUMBER
EOP_SALVAGE_VALUE	NUMBER
DEPRN_OVERRIDE_FLAG	NUMBER

Query Text

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


SELECT TRACK_MEMBER_ID
,      GROUP_ASSET_ID
,      MEMBER_ASSET_ID
,      PERIOD_COUNTER
,      FISCAL_YEAR
,      SET_OF_BOOKS_ID
,      ALLOCATION_BASIS
,      TOTAL_ALLOCATION_BASIS
,      ALLOCATED_DEPRN_AMOUNT
,      ALLOCATED_BONUS_AMOUNT
,      SYSTEM_DEPRN_AMOUNT
,      SYSTEM_BONUS_AMOUNT
,      FULLY_RESERVED_FLAG
,      FULLY_RETIRED_FLAG
,      OVERRIDE_FLAG
,      COST
,      ADJUSTED_COST
,      EOFY_ADJ_COST
,      RECOVERABLE_COST
,      SALVAGE_VALUE
,      ADJUSTED_RECOVERABLE_COST
,      PRIOR_YEAR_RESERVE
,      EOFY_AMOUNT
,      DEPRN_RESERVE
,      YTD_DEPRN
,      BONUS_DEPRN_RESERVE
,      BONUS_YTD_DEPRN
,      EOFY_RECOVERABLE_COST
,      EOP_RECOVERABLE_COST
,      EOFY_SALVAGE_VALUE
,      EOP_SALVAGE_VALUE
,      DEPRN_OVERRIDE_FLAG
FROM FA.FA_TRACK_MEMBERS;

Dependencies

[top of page]

FA.FA_TRACK_MEMBERS does not reference any database object

FA.FA_TRACK_MEMBERS is referenced by following:

APPS: FA_TRACK_MEMBERS