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_GROUP_ASSET_DEFAULT

Object Details

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

Defines accounts to be used for a group asset within a particular book. e.g. Expense account, reserve account etc.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_GROUP_ASSET_DEFAULT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ASSET_ID
FA_GROUP_ASSET_DEFAULT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE
FA_GROUP_ASSET_DEFAULT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPER_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ASSET_ID	NUMBER	(15)	Yes	Unique key to identify the group asset
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Book type code
SUPER_GROUP_ID	NUMBER	(15)		Super group to which the group asset belongs in this book.
ASSET_COST_ACCT	VARCHAR2	(255)		Group asset cost account
ASSET_CLEARING_ACCT	VARCHAR2	(255)		Group asset clearing account
DEPRN_EXPENSE_ACCT	VARCHAR2	(255)		Group depreciation expense account
DEPRN_RESERVE_ACCT	VARCHAR2	(255)		Group depreciation reserve account
REVAL_AMORTIZATION_ACCT	VARCHAR2	(255)		Revaluation amortization account
REVAL_AMORTIZATION_ACCT_CCID	NUMBER	(15)		Revaluation amortization account code combination Id
REVAL_RESERVE_ACCT	VARCHAR2	(255)		Revaluation reserve account
PROCEEDS_OF_SALE_GAIN_ACCT	VARCHAR2	(255)		Proceeds of sale gain account
PROCEEDS_OF_SALE_LOSS_ACCT	VARCHAR2	(255)		Proceeds of sale loss account
PROCEEDS_OF_SALE_CLEARING_ACCT	VARCHAR2	(255)		Proceeds of sale clearing account
COST_OF_REMOVAL_GAIN_ACCT	VARCHAR2	(255)		Cost of removal gain account
COST_OF_REMOVAL_LOSS_ACCT	VARCHAR2	(255)		Cost of removal loss account
NBV_RETIRED_GAIN_ACCT	VARCHAR2	(255)		Net book value retired gain account
NBV_RETIRED_LOSS_ACCT	VARCHAR2	(255)		Net book value retired loss account
REVAL_RSV_RETIRED_GAIN_ACCT	VARCHAR2	(255)		Revalued reserve retired gain account
REVAL_RSV_RETIRED_LOSS_ACCT	VARCHAR2	(255)		Revalued reserve retired loss account
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
RESERVE_ACCOUNT_CCID	NUMBER	(15)		Reserve account code combination Id
REVAL_RESERVE_ACCT_CCID	NUMBER	(15)		Revalued reserve account code combination Id
ASSET_COST_ACCT_CCID	NUMBER	(15)		Asset cost account code combination Id
ASSET_CLEARING_ACCT_CCID	NUMBER	(15)		Asset clearing account code combination Id
DEPRN_RESERVE_ACCT_CCID	NUMBER	(15)		Depreciation reserve account code combination Id
DEPRN_EXPENSE_ACCT_CCID	NUMBER	(15)		Depreciation expense account code combination Id
REVAL_AMORT_ACCOUNT_CCID	NUMBER	(15)		Revalued amortization account code combination Id
COST_OF_REMOVAL_CLEARING_ACCT	VARCHAR2	(255)		Cost of removal clearing account
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield segment for globalization.

Query Text

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


SELECT GROUP_ASSET_ID
,      BOOK_TYPE_CODE
,      SUPER_GROUP_ID
,      ASSET_COST_ACCT
,      ASSET_CLEARING_ACCT
,      DEPRN_EXPENSE_ACCT
,      DEPRN_RESERVE_ACCT
,      REVAL_AMORTIZATION_ACCT
,      REVAL_AMORTIZATION_ACCT_CCID
,      REVAL_RESERVE_ACCT
,      PROCEEDS_OF_SALE_GAIN_ACCT
,      PROCEEDS_OF_SALE_LOSS_ACCT
,      PROCEEDS_OF_SALE_CLEARING_ACCT
,      COST_OF_REMOVAL_GAIN_ACCT
,      COST_OF_REMOVAL_LOSS_ACCT
,      NBV_RETIRED_GAIN_ACCT
,      NBV_RETIRED_LOSS_ACCT
,      REVAL_RSV_RETIRED_GAIN_ACCT
,      REVAL_RSV_RETIRED_LOSS_ACCT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      RESERVE_ACCOUNT_CCID
,      REVAL_RESERVE_ACCT_CCID
,      ASSET_COST_ACCT_CCID
,      ASSET_CLEARING_ACCT_CCID
,      DEPRN_RESERVE_ACCT_CCID
,      DEPRN_EXPENSE_ACCT_CCID
,      REVAL_AMORT_ACCOUNT_CCID
,      COST_OF_REMOVAL_CLEARING_ACCT
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
FROM FA.FA_GROUP_ASSET_DEFAULT;

Dependencies

[top of page]

FA.FA_GROUP_ASSET_DEFAULT does not reference any database object

FA.FA_GROUP_ASSET_DEFAULT is referenced by following:

FA: FA_GROUP_ASSET_DEFAULT#