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_REP_ITF

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_GROUP_REP_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Concurrent request identifier.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ORGANIZATION_NAME	VARCHAR2	(80)		Organization name.
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(30)		Functional currency.
SET_OF_BOOKS_ID	NUMBER	(15)		Set of books identification number fro GL set of books.
BOOK_TYPE_CODE	VARCHAR2	(30)		Book name.
DEPRN_CALENDAR	VARCHAR2	(15)		Name of depreciation calendar.
FISCAL_YEAR	NUMBER	(15)		Fiscal year.
GRP_ASSET_NUMBER	VARCHAR2	(15)		User assigned group asset number.
GRP_DESCRIPTION	VARCHAR2	(80)		Description of the group asset.
GRP_ASSET_TYPE	VARCHAR2	(30)		Indicates whether the group asset is CIP, capitalized, expensed or group.
GRP_MAJOR_CATEGORY	VARCHAR2	(30)		Major category segment for group asset.
GRP_MINOR_CATEGORY	VARCHAR2	(30)		Monir category segment for group asset.
GRP_OTHER_CATEGORY	VARCHAR2	(30)		Other category segment for group asset.
GRP_DATE_PLACED_IN_SERVICE	DATE			Date the group asset was placed in service.
GRP_DEPRN_METHOD_CODE	VARCHAR2	(30)		Name of the depreciation method for the group asset.
GRP_RULE_NAME	VARCHAR2	(80)		The user rule name of depreciable basis rule for group asset.
GRP_TRACKING_METHOD	VARCHAR2	(30)		Indicates whether tracking method is Allocate, Calculate, or not used.
GRP_COST	NUMBER			Current cost of the group asset
GRP_SALVAGE_VALUE	NUMBER			Group asset salvage value
GRP_ADJUSTED_RECOVERABLE_COST	NUMBER			Adjusted recoverable cost with special depreciation limits taken into account for group asset. This column is effective only if either depreciation limit or depreciation limit amount is set.
GRP_BEGINNING_NBV	NUMBER			Prior fiscal year ending net book value for group asset
GRP_FIRST_HALF_ADDITION	NUMBER			Cost of the assets added to the group during the first half of the fiscal year. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH HALF YEAR RULE.
GRP_SECOND_HALF_ADDITION	NUMBER			Cost of the assets added to the group during the second half of the fiscal year. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH HALF YEAR RULE.
GRP_ADDITION_AMOUNT	NUMBER			Amount of additions to the group during the fiscal year
GRP_ADJUSTMENT_AMOUNT	NUMBER			Amount of the adjustments to the group
GRP_NET_PROCEEDS	NUMBER			Proceeds of sale less cost of removal
GRP_PROCEEDS_OF_SALE	NUMBER			Proceeds from the sale of the member assets
GRP_COST_OF_REMOVAL	NUMBER			Cost of removing the member assets
GRP_COST_RETIRED	NUMBER			Retired cost of the member assets
GRP_RESERVE_RETIRED	NUMBER			Retired cost less retired net book value for group asset
GRP_RECAPTURE_AMOUNT	NUMBER			Recapture amount
GRP_TERMINAL_GAIN_LOSS_AMOUNT	NUMBER			Amount of terminal gain and loss. Negative number represents terminal loss.
GRP_NBV_BEFORE_DEPRN	NUMBER			Sum of beginning net book value, additions and adjustments, less net proceeds for group asset
GRP_DEPRN_BASIS_ADJUSTMENT	NUMBER			Amount which reduction rate is applied. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT or HALF YEAR RULE.
GRP_REDUCED_NBV	NUMBER			Group asset's net book value which applied reduction rate. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT or HALF YEAR RULE.
GRP_ADJUSTED_RATE	NUMBER			Actual rate used to calculate group asset's depreciation for flat-rate methods.
GRP_LIFE_YEAR_MONTH	NUMBER			Life of the group asset in total years and months.
GRP_REGULAR_DEPRN_AMOUNT	NUMBER			Group asset's depreciation amount, which used 100% of depreciation rate. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH HALF YEAR RULE.
GRP_REDUCED_DEPRN_AMOUNT	NUMBER			Group asset's depreciation amount, which applied reduction rate. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH HALF YEAR RULE.
GRP_ANNUAL_DEPRN_AMOUNT	NUMBER			Group asset's depreciation expense for the fiscal year
GRP_DEPRN_RESERVE	NUMBER			Total depreciation taken since beginning of group asset life
GRP_ENDING_NBV	NUMBER			Group asset's ending net book value
MEM_ASSET_NUMBER	VARCHAR2	(15)		User assigned member asset number
MEM_DESCRIPTION	VARCHAR2	(80)		Description of the member asset
MEM_ASSET_TYPE	VARCHAR2	(30)		Indicates whether the member asset is CIP, capitalized, expensed, or group.
MEM_MAJOR_CATEGORY	VARCHAR2	(30)		Major category segment for member asset
MEM_MINOR_CATEGORY	VARCHAR2	(30)		Minor category segment for member asset
MEM_OTHER_CATEGORY	VARCHAR2	(30)		Other category segment for member asset
MEM_DATE_PLACED_IN_SERVICE	DATE			Date the member asset was placed in service
MEM_DEPRN_METHOD_CODE	VARCHAR2	(30)		Name of the depreciation method for member asset
MEM_RULE_NAME	VARCHAR2	(80)		The user rule name of depreciable basis rule for member asset
MEM_COST	NUMBER			Current cost of the member asset
MEM_SALVAGE_VALUE	NUMBER			Member asset salvage value
MEM_ADJUSTED_RECOVERABLE_COST	NUMBER			Adjusted recoverable cost with special depreciation limits taken into account for member asset. This column is effective only if either depreciation limit or depreciation limit amount is set.
MEM_BEGINNING_NBV	NUMBER			Prior fiscal year ending net book value for member asset
MEM_FIRST_HALF_ADDITION	NUMBER			Cost of the member asset if the asset was added to the group during the first half of the fiscal year. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH HALF YEAR RULE.
MEM_SECOND_HALF_ADDITION	NUMBER			Cost of the member asset if the asset was added to the group during the second half of the fiscal year. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH HALF YEAR RULE.
MEM_ADDITION_AMOUNT	NUMBER			Amount of addition of the member asset during the fiscal year
MEM_ADJUSTMENT_AMOUNT	NUMBER			Amount of the adjustments of the member asset
MEM_NET_PROCEEDS	NUMBER			Proceeds of sale less cost of removal for member asset
MEM_PROCEEDS_OF_SALE	NUMBER			Proceeds from the sale of the member asset
MEM_COST_OF_REMOVAL	NUMBER			Cost of removing the member asset
MEM_COST_RETIRED	NUMBER			Retired cost of the member asset
MEM_RESERVE_RETIRED	NUMBER			Retired cost less retired net book value for member asset
MEM_NBV_BEFORE_DEPRN	NUMBER			Sum of beginning net book value, additions and adjustments, less net proceeds for member asset
MEM_DEPRN_BASIS_ADJUSTMENT	NUMBER			Amount which reduction rate is applied. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT or HALF YEAR RULE.
MEM_REDUCED_NBV	NUMBER			Member asset's net book value which applied reduction rate. NULL is set to this column when group's depreciable basis rule is not YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT or HALF YEAR RULE.
MEM_ADJUSTED_RATE	NUMBER			Actual rate used to calculate member asset's depreciation for flat-rate methods. This column is effective only when group asset's tracking method is CALCULATE MEMBER ASSET AMOUNT and depreciated by MEMBER METHOD.
MEM_LIFE_YEAR_MONTH	NUMBER			Life of the member asset in total years and months. This column is effective only when group asset's Tracking Method is CALCULATE MEMBER ASSET AMOUNT and depreciated by MEMBER METHOD
MEM_ANNUAL_DEPRN_AMOUNT	NUMBER			Member asset's depreciation expense for the fiscal year
MEM_DEPRN_RESERVE	NUMBER			Total depreciation taken since beginning of member asset life
MEM_ENDING_NBV	NUMBER			Member asset's ending net book value
MEM_STATUS	VARCHAR2	(30)		Indicates whether the member asset is fully reserved or fully retired. FULLY RESERVED - member asset is fully reserved. FULLY RETIRED - member asset is fully retired.

Query Text

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


SELECT REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      SET_OF_BOOKS_ID
,      BOOK_TYPE_CODE
,      DEPRN_CALENDAR
,      FISCAL_YEAR
,      GRP_ASSET_NUMBER
,      GRP_DESCRIPTION
,      GRP_ASSET_TYPE
,      GRP_MAJOR_CATEGORY
,      GRP_MINOR_CATEGORY
,      GRP_OTHER_CATEGORY
,      GRP_DATE_PLACED_IN_SERVICE
,      GRP_DEPRN_METHOD_CODE
,      GRP_RULE_NAME
,      GRP_TRACKING_METHOD
,      GRP_COST
,      GRP_SALVAGE_VALUE
,      GRP_ADJUSTED_RECOVERABLE_COST
,      GRP_BEGINNING_NBV
,      GRP_FIRST_HALF_ADDITION
,      GRP_SECOND_HALF_ADDITION
,      GRP_ADDITION_AMOUNT
,      GRP_ADJUSTMENT_AMOUNT
,      GRP_NET_PROCEEDS
,      GRP_PROCEEDS_OF_SALE
,      GRP_COST_OF_REMOVAL
,      GRP_COST_RETIRED
,      GRP_RESERVE_RETIRED
,      GRP_RECAPTURE_AMOUNT
,      GRP_TERMINAL_GAIN_LOSS_AMOUNT
,      GRP_NBV_BEFORE_DEPRN
,      GRP_DEPRN_BASIS_ADJUSTMENT
,      GRP_REDUCED_NBV
,      GRP_ADJUSTED_RATE
,      GRP_LIFE_YEAR_MONTH
,      GRP_REGULAR_DEPRN_AMOUNT
,      GRP_REDUCED_DEPRN_AMOUNT
,      GRP_ANNUAL_DEPRN_AMOUNT
,      GRP_DEPRN_RESERVE
,      GRP_ENDING_NBV
,      MEM_ASSET_NUMBER
,      MEM_DESCRIPTION
,      MEM_ASSET_TYPE
,      MEM_MAJOR_CATEGORY
,      MEM_MINOR_CATEGORY
,      MEM_OTHER_CATEGORY
,      MEM_DATE_PLACED_IN_SERVICE
,      MEM_DEPRN_METHOD_CODE
,      MEM_RULE_NAME
,      MEM_COST
,      MEM_SALVAGE_VALUE
,      MEM_ADJUSTED_RECOVERABLE_COST
,      MEM_BEGINNING_NBV
,      MEM_FIRST_HALF_ADDITION
,      MEM_SECOND_HALF_ADDITION
,      MEM_ADDITION_AMOUNT
,      MEM_ADJUSTMENT_AMOUNT
,      MEM_NET_PROCEEDS
,      MEM_PROCEEDS_OF_SALE
,      MEM_COST_OF_REMOVAL
,      MEM_COST_RETIRED
,      MEM_RESERVE_RETIRED
,      MEM_NBV_BEFORE_DEPRN
,      MEM_DEPRN_BASIS_ADJUSTMENT
,      MEM_REDUCED_NBV
,      MEM_ADJUSTED_RATE
,      MEM_LIFE_YEAR_MONTH
,      MEM_ANNUAL_DEPRN_AMOUNT
,      MEM_DEPRN_RESERVE
,      MEM_ENDING_NBV
,      MEM_STATUS
FROM FA.FA_GROUP_REP_ITF;