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_MASS_RECLASS_ITF

Object Details

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

FA_MASS_RECLASS_ITF is an interface table tracking mass reclass transactions for RX reports.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MASS_RCL_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Concurrent request identification number for the mass reclass
MASS_RECLASS_ID	NUMBER	(15)	Yes	Unique mass reclass identification number
ASSET_ID	NUMBER	(15)	Yes	System generated asset identification number
ASSET_NUMBER	VARCHAR2	(15)	Yes	User assigned asset number
DESCRIPTION	VARCHAR2	(80)	Yes	Description of the asset
BOOK	VARCHAR2	(15)	Yes	Book name
OLD_CATEGORY	VARCHAR2	(210)		Concatenated Segment values from the old asset category key Flexfield. This column is used in Mass Reclass Preview only
NEW_CATEGORY	VARCHAR2	(210)	Yes	Concatenated Segment values from the new asset category key Flexfield
CONVENTION	VARCHAR2	(10)	Yes	New depreciation ceiling for the asset
CEILING	VARCHAR2	(30)		New depreciation ceiling for the asset
METHOD	VARCHAR2	(12)	Yes	New depreciation method for the asset
LIFE	NUMBER			New life of the asset represented in years and months
BASIC_RATE	NUMBER			New basic depreciation rate in percentage used for flat-rate methods
ADJUSTED_RATE	NUMBER			New adjusted depreciation rate in percentage used for flat-rate methods
BONUS_RULE	VARCHAR2	(30)		New bonus depreciation rule for flat-rate method
PRODUCTION_CAPACITY	NUMBER			New capacity of a units of production asset
UNIT_OF_MEASURE	VARCHAR2	(25)		New unit of measure of a units of production asset
DEPRECIATE_FLAG	VARCHAR2	(80)	Yes	Indicates whether the asset is depreciating
DEPRN_LIMIT_PERCENTAGE	NUMBER			New default depreciation limit as a percentage of cost
DEPRN_LIMIT_AMOUNT	NUMBER			New default depreciation limit as a flat amount
SALVAGE_VAL_PERCENTAGE	NUMBER			New default salvage value percentage
COST_ACCT	VARCHAR2	(780)		Asset/CIP cost account in a concatenated string of Segment values. This column is used in Mass Reclass Review only
DEPRN_RESERVE_ACCT	VARCHAR2	(780)		Depreciation reserve account in a concatenated string of segment values. This column is used in Mass Reclass Review only
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ASSET_TYPE	VARCHAR2	(15)		Indicates whether the asset is CIP, capitalized, expensed, or group

Query Text

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


SELECT REQUEST_ID
,      MASS_RECLASS_ID
,      ASSET_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      BOOK
,      OLD_CATEGORY
,      NEW_CATEGORY
,      CONVENTION
,      CEILING
,      METHOD
,      LIFE
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      DEPRECIATE_FLAG
,      DEPRN_LIMIT_PERCENTAGE
,      DEPRN_LIMIT_AMOUNT
,      SALVAGE_VAL_PERCENTAGE
,      COST_ACCT
,      DEPRN_RESERVE_ACCT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      ASSET_TYPE
FROM FA.FA_MASS_RECLASS_ITF;

Dependencies

[top of page]

FA.FA_MASS_RECLASS_ITF does not reference any database object

FA.FA_MASS_RECLASS_ITF is referenced by following:

FA: FA_MASS_RECLASS_ITF#