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

TABLE: FA.FA_SORP_UPG_IMPREVAL

Object Details
Object Name: FA_SORP_UPG_IMPREVAL
Object Type: TABLE
Owner: FA
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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
Query Text

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
FROM FA.FA_SORP_UPG_IMPREVAL;

Dependencies

[top of page]

FA.FA_SORP_UPG_IMPREVAL does not reference any database object

FA.FA_SORP_UPG_IMPREVAL is referenced by following:

SchemaFA
ViewFA_SORP_UPG_IMPREVAL#