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

VIEW: FA.FA_SORP_LINK_REVAL_ITF#

Object Details
Object Name: FA_SORP_LINK_REVAL_ITF#
Object Type: VIEW
Owner: FA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MASS_REVAL_ID NUMBER

ASSET_ID NUMBER

CATEGORY_ID NUMBER

BOOK_TYPE_CODE VARCHAR2 (25)
IMPAIRMENT_ID NUMBER

SPLIT_NUMBER NUMBER

IMP_LOSS_AMT NUMBER

REQUEST_ID NUMBER

IMPAIR_LOSS_IMPACT NUMBER

IMPAIR_LOSS_ACCT VARCHAR2 (25)
CREATED_BY NUMBER

CREATION_DATE DATE

RUN_MODE VARCHAR2 (30)
IMP_DEPRN_EFFECT NUMBER

REVAL_RESERVE_IMPACT_FLAG VARCHAR2 (1)
REASON VARCHAR2 (100)
IMPAIR_CLASS_TYPE VARCHAR2 (100)
CALC_IMP_AMOUNT NUMBER

CALC_IMP_DEPRN_EFFECT NUMBER

REVAL_RSV_ADJ_AMOUNT NUMBER

REVAL_RSV_ADJ_DEPRN_EFFECT NUMBER

CALC_IMP_REVERSE_AMT NUMBER

CALC_IMP_REVERSE_DEPRN_EFFECT NUMBER

RSV_REVERSE_AMT NUMBER

RSV_REVERSE_DEPRN_EFFECT NUMBER

REVAL_GAIN NUMBER

IMPAIRMENT_LOSS_AMOUNT NUMBER

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# references the following:

SchemaFA
TableFA_SORP_LINK_REVAL_ITF
FA.FA_SORP_LINK_REVAL_ITF# is referenced by following:

SchemaAPPS
SynonymFA_SORP_LINK_REVAL_ITF