DBA Data[Home] [Help] [Dependency Information]

TABLE: FA.FA_SHORT_TAX_RESERVES

Object Details
Object Name: FA_SHORT_TAX_RESERVES
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_SHORT_TAX_RESERVES
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.

View Type

Internal

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_SHORT_TAX_RESERVES_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnTAX_BOOK
ColumnASSET_NUMBER
Columns
Name Datatype Length Mandatory Comments
ASSET_NUMBER VARCHAR2 (15) Yes User assigned asset number
TAX_BOOK VARCHAR2 (15) Yes Tax book name
YTD_DEPRN NUMBER

Year-to-date depreciation expense
DEPRN_RESERVE NUMBER
Yes Total depreciation taken since beginning of asset's life
DATE_PLACED_IN_SERVICE DATE

Date the asset was placed in service
PRORATE_CONVENTION_CODE VARCHAR2 (10)
Prorate convention
DEPRN_METHOD_CODE VARCHAR2 (12)
Name of the depreciation method for the asset
LIFE_IN_MONTHS NUMBER (4)
Life of the asset in total months
ORIGINAL_DEPRN_START_DATE DATE

Date short tax year asset began depreciating in the acquired company's books
Query Text

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


SELECT ASSET_NUMBER
,      TAX_BOOK
,      YTD_DEPRN
,      DEPRN_RESERVE
,      DATE_PLACED_IN_SERVICE
,      PRORATE_CONVENTION_CODE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      ORIGINAL_DEPRN_START_DATE
FROM FA.FA_SHORT_TAX_RESERVES;

Dependencies

[top of page]

FA.FA_SHORT_TAX_RESERVES does not reference any database object

FA.FA_SHORT_TAX_RESERVES is referenced by following:

SchemaFA
ViewFA_SHORT_TAX_RESERVES#