[Home] [Help] [Dependency Information]
Object Name: | FA_SORP_UPG_IMPREVAL_HIST |
---|---|
Object Type: | TABLE |
Owner: | FA |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_TYPE | VARCHAR2 | (25) | Transaction Type .It can be either 'Impairment' or 'Revaluation' | |
ID | NUMBER | Impairment Id or Cash Generating Unit | ||
NAME | VARCHAR2 | (30) | Asset Number or Cash Generating Unit | |
DESCRIPTION | VARCHAR2 | (200) | Asset or Cash Generating Unit Description | |
ASSET_CATEGORY_ID | NUMBER | Category Id | ||
CATEGORY_NAME | VARCHAR2 | (250) | Category Name | |
IMPAIRMENT_ID | NUMBER | Impairment Id | ||
IMPAIRMENT_NAME | VARCHAR2 | (50) | Impairment Name | |
IMP_DESCRIPTION | VARCHAR2 | (200) | Impairment Description | |
IMP_CLASS_TYPE | VARCHAR2 | (3) | Impairment Classification Type | |
IMP_AMOUNT | NUMBER | Impairment Amount | ||
MASS_REVAL_ID | NUMBER | Mass Transaction Number | ||
REVAL_PERCENT | NUMBER | Reval Percentage | ||
REVAL_REASON | VARCHAR2 | (250) | REVAL_REASON | |
BOOK_TYPE_CODE | VARCHAR2 | (30) | Asset Book | |
REPORT_MODE | VARCHAR2 | (25) | Report Mode | |
ID_TYPE | VARCHAR2 | (1) | Id type. A -Asset,C -Cash Generating Uni | |
REQUEST_ID | NUMBER | Concurent Porgram Request Id |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_TYPE
, ID
, NAME
, DESCRIPTION
, ASSET_CATEGORY_ID
, CATEGORY_NAME
, IMPAIRMENT_ID
, IMPAIRMENT_NAME
, IMP_DESCRIPTION
, IMP_CLASS_TYPE
, IMP_AMOUNT
, MASS_REVAL_ID
, REVAL_PERCENT
, REVAL_REASON
, BOOK_TYPE_CODE
, REPORT_MODE
, ID_TYPE
, REQUEST_ID
FROM FA.FA_SORP_UPG_IMPREVAL_HIST;
FA.FA_SORP_UPG_IMPREVAL_HIST does not reference any database object
FA.FA_SORP_UPG_IMPREVAL_HIST is referenced by following:
|
|
|