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_CHANGES_ITF

Object Details

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

FA_MASS_CHANGES_ITF is an interface table that tracks mass change transactions for RX reports.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MASS_CHANGES_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_CHANGE_ID	NUMBER	(15)	Yes	Unique mass change 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
ASSET_TYPE	VARCHAR2	(15)	Yes	Indicates whether the asset is CIP, capitalized, expensed, or group.
BOOK	VARCHAR2	(15)	Yes	Book name
CATEGORY	VARCHAR2	(210)	Yes	Concatenated segment values from the asset category key Flexfield
FROM_CONVENTION	VARCHAR2	(10)		The original prorate convention from which the asset will be changed during the Mass Change process.
TO_CONVENTION	VARCHAR2	(10)		The new prorate convention to which the asset will be changed during the Mass Change process.
FROM_LIFE_IN_MONTHS	NUMBER	(4)		The original life in months from which the asset will be changed during the Mass Change process.
TO_LIFE_IN_MONTHS	NUMBER	(4)		New life in months to which the asset will be changed during the Mass Change process.
FROM_METHOD_CODE	VARCHAR2	(12)		The original depreciation method from which the asset will be changed during the Mass Change process.
TO_METHOD_CODE	VARCHAR2	(12)		New depreciation method to which the asset will be changed during the Mass Change process.
FROM_BASIC_RATE	NUMBER			The original basic depreciation rate percentage used fpr flat rate methods.
TO_BASIC_RATE	NUMBER			New basic depreciation rate percentage used for flat-rate methods
FROM_ADJUSTED_RATE	NUMBER			The original adjusted depreciation rate percentage used for flat-rate methods
TO_ADJUSTED_RATE	NUMBER			New adjusted depreciation rate percentage used for flat-rate methods.
FROM_PRODUCTION_CAPACITY	NUMBER			The original capacity of a units of production asset from which the asset will be changed during the Mass Change process.
TO_PRODUCTION_CAPACITY	NUMBER			New capacity of a units of production asset to which the asset will be changed during the Mass Change process.
FROM_BONUS_RULE	VARCHAR2	(30)		The original bonus depreciation rule from which the asset will be changed during the Mass Change process.
TO_BONUS_RULE	VARCHAR2	(30)		New bonus depreciation rule to which the asset will be changed during the Mass Change process.
FROM_GROUP_ASSET_NUMBER	VARCHAR2	(15)		The original associated group asset from which the asset will be changed during the Mass Change process.
TO_GROUP_ASSET_NUMBER	VARCHAR2	(15)		New associated group asset for group member assets to which the asset will be changed during the Mass Change process.
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
FROM_SALVAGE_TYPE	VARCHAR2	(30)		The original salvage type from which the asset will be changed during the Mass Change process.
TO_SALVAGE_TYPE	VARCHAR2	(30)		The new salvage type to which the asset will be changed during the Mass Change process.
FROM_PERCENT_SALVAGE_VALUE	NUMBER			The original percent salvage value from which the asset will be changed during the Mass Change process.
TO_PERCENT_SALVAGE_VALUE	NUMBER			The new percent salvage value to which the asset will be changed during the Mass Change process.
FROM_SALVAGE_VALUE	NUMBER			The original salvage value from which the asset will be changed during the Mass Change process.
TO_SALVAGE_VALUE	NUMBER			The new salvage value to which the asset will be changed during the Mass Change process.
FROM_DEPRN_LIMIT_TYPE	VARCHAR2	(30)		The original depreciation limit type from which the asset will be changed during the Mass Change process.
TO_DEPRN_LIMIT_TYPE	VARCHAR2	(30)		The new depreciation limit type to which the asset will be changed during the Mass Change process.
FROM_DEPRN_LIMIT	NUMBER			The original depreciation limit percentage from which the asset will be changed during the Mass Change process.
TO_DEPRN_LIMIT	NUMBER			The new depreciation limit percentage to which the asset will be changed during the Mass Change process.
FROM_DEPRN_LIMIT_AMOUNT	NUMBER			The original depreciation limit amount from which the asset will be changed during the Mass Change process.
TO_DEPRN_LIMIT_AMOUNT	NUMBER			The new depreciation limit amount to which the asset will be changed during the Mass Change process.

Query Text

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


SELECT REQUEST_ID
,      MASS_CHANGE_ID
,      ASSET_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      ASSET_TYPE
,      BOOK
,      CATEGORY
,      FROM_CONVENTION
,      TO_CONVENTION
,      FROM_LIFE_IN_MONTHS
,      TO_LIFE_IN_MONTHS
,      FROM_METHOD_CODE
,      TO_METHOD_CODE
,      FROM_BASIC_RATE
,      TO_BASIC_RATE
,      FROM_ADJUSTED_RATE
,      TO_ADJUSTED_RATE
,      FROM_PRODUCTION_CAPACITY
,      TO_PRODUCTION_CAPACITY
,      FROM_BONUS_RULE
,      TO_BONUS_RULE
,      FROM_GROUP_ASSET_NUMBER
,      TO_GROUP_ASSET_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      FROM_SALVAGE_TYPE
,      TO_SALVAGE_TYPE
,      FROM_PERCENT_SALVAGE_VALUE
,      TO_PERCENT_SALVAGE_VALUE
,      FROM_SALVAGE_VALUE
,      TO_SALVAGE_VALUE
,      FROM_DEPRN_LIMIT_TYPE
,      TO_DEPRN_LIMIT_TYPE
,      FROM_DEPRN_LIMIT
,      TO_DEPRN_LIMIT
,      FROM_DEPRN_LIMIT_AMOUNT
,      TO_DEPRN_LIMIT_AMOUNT
FROM FA.FA_MASS_CHANGES_ITF;

Dependencies

[top of page]

FA.FA_MASS_CHANGES_ITF does not reference any database object

FA.FA_MASS_CHANGES_ITF is referenced by following:

FA: FA_MASS_CHANGES_ITF#