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

TABLE: FA.FA_WHATIF_ITF

Object Details
Object Name: FA_WHATIF_ITF
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_WHATIF_ITF
Subobject Name:
Status: VALID


FA_WHATIF_ITF contains information about what-if depreciation
analysis. Oracle Assets inserts a row into this table for every
distribution of an asset on which what-if depreciation analysis is
performed.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_WHATIF_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Concurrent request identifier for the what-if calculation
BOOK_TYPE_CODE VARCHAR2 (15)
Name of book
ASSET_ID NUMBER

Asset identification number
ASSET_NUMBER VARCHAR2 (15)
The user assigned asset number
DESCRIPTION VARCHAR2 (80)
The description of the asset
TAG_NUMBER VARCHAR2 (15)
The tag number of the asset
SERIAL_NUMBER VARCHAR2 (35)
The serial number of the asset
PERIOD_NAME VARCHAR2 (15)
Depreciation period name
FISCAL_YEAR NUMBER (4)
Fiscal year
DATE_PLACED_IN_SERVICE DATE

Date placed in service to run hypothetical depreciation analysis
EXPENSE_ACCT VARCHAR2 (500)
Depreciation expense account
CATEGORY VARCHAR2 (500)
Concatenated segments of category to run hypothetical depreciation analysis
LOCATION VARCHAR2 (500)
The asset location
UNITS NUMBER

The number of units for the asset
EMPLOYEE_NAME VARCHAR2 (240)
Name of the employee
EMPLOYEE_NUMBER VARCHAR2 (30)
Number of the employee
ASSET_KEY VARCHAR2 (500)
Asset key for the asset
CURRENT_COST NUMBER

Cost of the asset
CURRENT_PRORATE_CONV VARCHAR2 (15)
Depreciation prorate convention
CURRENT_METHOD VARCHAR2 (15)
Depreciation method for the asset
CURRENT_LIFE NUMBER

Life of the asset in months
CURRENT_BASIC_RATE NUMBER

The base rate used to calculate depreciation amounts for flat rate methods
CURRENT_ADJUSTED_RATE NUMBER

Actual rate used to calculate depreciation for flat rate methods
CURRENT_SALVAGE_VALUE NUMBER

Asset salvage value
DEPRECIATION NUMBER

Depreciation amount using current depreciation parameters
ACCUMULATED_DEPRN NUMBER

Depreciation reserve user enters to run hypothetical depreciation analysis
NEW_DEPRECIATION NUMBER

Depreciation amount using new depreciation parameters
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
BONUS_DEPRECIATION NUMBER

Bonus depreciation amount using current bonus rule
NEW_BONUS_DEPRECIATION NUMBER

Bonus depreciation amount using new bonus rule
CURRENT_BONUS_RULE VARCHAR2 (30)
Bonus Rule for the Asset
PERIOD_NUM NUMBER (9)
Fiscal year period number
CURRENCY_CODE VARCHAR2 (15)
Set of Books Currency
Query Text

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


SELECT REQUEST_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      TAG_NUMBER
,      SERIAL_NUMBER
,      PERIOD_NAME
,      FISCAL_YEAR
,      DATE_PLACED_IN_SERVICE
,      EXPENSE_ACCT
,      CATEGORY
,      LOCATION
,      UNITS
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      ASSET_KEY
,      CURRENT_COST
,      CURRENT_PRORATE_CONV
,      CURRENT_METHOD
,      CURRENT_LIFE
,      CURRENT_BASIC_RATE
,      CURRENT_ADJUSTED_RATE
,      CURRENT_SALVAGE_VALUE
,      DEPRECIATION
,      ACCUMULATED_DEPRN
,      NEW_DEPRECIATION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BONUS_DEPRECIATION
,      NEW_BONUS_DEPRECIATION
,      CURRENT_BONUS_RULE
,      PERIOD_NUM
,      CURRENCY_CODE
FROM FA.FA_WHATIF_ITF;

Dependencies

[top of page]

FA.FA_WHATIF_ITF does not reference any database object

FA.FA_WHATIF_ITF is referenced by following:

SchemaFA
ViewFA_WHATIF_ITF#