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_TAX_ADJ_REP_T

Object Details

Object Name:	FA_MASS_TAX_ADJ_REP_T
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_MASS_TAX_ADJ_REP_T
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_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
MASS_TAX_ADJ_ID	NUMBER	(15)	Unique mass tax reserve adjustment identification number
REQUEST_ID	NUMBER	(15)	Concurrent request identification number for the mass tax reserve adjustment
ADJUSTED_BOOK_TYPE_CODE	VARCHAR2	(15)	Name of the tax book that is adjusted
ASSET_ID	NUMBER	(15)	System generated asset identification number
ASSET_NUMBER	VARCHAR2	(15)	User assigned asset number
DESCRIPTION	VARCHAR2	(80)	Description of the asset
DEPRN_RESERVE_ACCT	VARCHAR2	(25)	Reserve account segment for depreciation
ASSET_COST_ACCT	VARCHAR2	(25)	Cost account segment for capitalized assets
COST	NUMBER		Current cost of the asset
OLD_YTD_DEPRN	NUMBER		Old year-to-date depreciation expense
ADJ_YTD_DEPRN	NUMBER		Amount of adjustment in year-to-date depreciation expense
NEW_YTD_DEPRN	NUMBER		New year-to-date depreciation expense
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

Query Text

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


SELECT MASS_TAX_ADJ_ID
,      REQUEST_ID
,      ADJUSTED_BOOK_TYPE_CODE
,      ASSET_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      DEPRN_RESERVE_ACCT
,      ASSET_COST_ACCT
,      COST
,      OLD_YTD_DEPRN
,      ADJ_YTD_DEPRN
,      NEW_YTD_DEPRN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
FROM FA.FA_MASS_TAX_ADJ_REP_T;

Dependencies

[top of page]

FA.FA_MASS_TAX_ADJ_REP_T does not reference any database object

FA.FA_MASS_TAX_ADJ_REP_T is referenced by following:

FA: FA_MASS_TAX_ADJ_REP_T#