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

TABLE: FA.FA_SORP_LINK_REVAL_ITF

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


This table is populated from FA_REVAL_LINK_IMP_ASSET or FA_REVAL_LINK_IMP_CAT depending on whether the revaluation was run at asset level or category level. This stores the details of the imapirment reversed and other information required to generate accounting entries. The accounting entries in FA_ADJUSTMENTS are created based on the entries in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
MASS_REVAL_ID NUMBER

Unique mass revaluation identification number
ASSET_ID NUMBER

Asset identification number
CATEGORY_ID NUMBER

Unique identification number for each asset category
BOOK_TYPE_CODE VARCHAR2 (25)
Book name
IMPAIRMENT_ID NUMBER

Unique identification number of a impairment
SPLIT_NUMBER NUMBER

The split number if the impairment is Split
IMP_LOSS_AMT NUMBER

Total Impairment Loss Amount
REQUEST_ID NUMBER

Concurrent Request id
IMPAIR_LOSS_IMPACT NUMBER

The net impairment amount eligible for reversal. This is equal to total impairment loss amount minus change in depreciation due to impairment
IMPAIR_LOSS_ACCT VARCHAR2 (25)
The account to which impairment loss must be booked
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
RUN_MODE VARCHAR2 (30)
Mode of concurrent request submission. This can have the value PREVIEW or RUN
IMP_DEPRN_EFFECT NUMBER

The effect of depreciation on IMPAIRMENT_LOSS_AMOUNT
REVAL_RESERVE_IMPACT_FLAG VARCHAR2 (1)
A value of Y indicates that the impairment had previously reversed out revaluation reserve
REASON VARCHAR2 (100)
Reason description
IMPAIR_CLASS_TYPE VARCHAR2 (100)
Impairment classification type
CALC_IMP_AMOUNT NUMBER

The impairment amount attributed to the I&E account. This is calculated as total impairment loss amount minus amount of revaluation reserve adjusted by the impairment
CALC_IMP_DEPRN_EFFECT NUMBER

The effect of depreciation on the CALC_IMP_AMOUNT
REVAL_RSV_ADJ_AMOUNT NUMBER

The amount of revaluation reserve that was adjusted by the Impairment
REVAL_RSV_ADJ_DEPRN_EFFECT NUMBER

The effect of depreciation on the REVAL_RSV_ADJ_AMOUNT
CALC_IMP_REVERSE_AMT NUMBER

The amount of impairment loss attributed to I&E or CALC_IMP_AMOUNT reversed due to linking
CALC_IMP_REVERSE_DEPRN_EFFECT NUMBER

The amount of CALC_IMP_DEPRN_EFFECT reversed due to linking
RSV_REVERSE_AMT NUMBER

The amount of revaluation reserve or REVAL_RSV_ADJ_AMOUNT reversed due to linking
RSV_REVERSE_DEPRN_EFFECT NUMBER

The amount of revaluation reserve depreciation effect or REVAL_RSV_ADJ_DEPRN_EFFECT reversed due to linking
REVAL_GAIN NUMBER

The final revaluation gain after considering linking
IMPAIRMENT_LOSS_AMOUNT NUMBER

Impairment loss amount
Query Text

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


SELECT MASS_REVAL_ID
,      ASSET_ID
,      CATEGORY_ID
,      BOOK_TYPE_CODE
,      IMPAIRMENT_ID
,      SPLIT_NUMBER
,      IMP_LOSS_AMT
,      REQUEST_ID
,      IMPAIR_LOSS_IMPACT
,      IMPAIR_LOSS_ACCT
,      CREATED_BY
,      CREATION_DATE
,      RUN_MODE
,      IMP_DEPRN_EFFECT
,      REVAL_RESERVE_IMPACT_FLAG
,      REASON
,      IMPAIR_CLASS_TYPE
,      CALC_IMP_AMOUNT
,      CALC_IMP_DEPRN_EFFECT
,      REVAL_RSV_ADJ_AMOUNT
,      REVAL_RSV_ADJ_DEPRN_EFFECT
,      CALC_IMP_REVERSE_AMT
,      CALC_IMP_REVERSE_DEPRN_EFFECT
,      RSV_REVERSE_AMT
,      RSV_REVERSE_DEPRN_EFFECT
,      REVAL_GAIN
,      IMPAIRMENT_LOSS_AMOUNT
FROM FA.FA_SORP_LINK_REVAL_ITF;

Dependencies

[top of page]

FA.FA_SORP_LINK_REVAL_ITF does not reference any database object

FA.FA_SORP_LINK_REVAL_ITF is referenced by following:

SchemaFA
ViewFA_SORP_LINK_REVAL_ITF#