[Home] [Help] [Dependency Information]
Object Name: | FA_SORP_REVAL_CHK |
---|---|
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 |
---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | (15) | Book name | |
CATEGORY_ID | NUMBER | Unique identification number for each asset category | ||
CATEGORY_NAME | VARCHAR2 | (250) | Category Name | |
ASSET_ID | NUMBER | Asset identification number | ||
ASSET_NUMBER | VARCHAR2 | (50) | Asset Number | |
APR_REVAL_RSV | NUMBER | Revaluation Reserve on 01-APR-2007 | ||
REVAL_RSV | NUMBER | Current Revaluation Reserve | ||
STATUS_CODE | VARCHAR2 | (50) | Status of Program Run S - SUCCESS,ARSV -Revaluation Reserve on 01-APR-2007 check Failed,CRSV-Current Revaluation Reserve check Failed | |
STATUS | VARCHAR2 | (500) | Status of Program Run |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, CATEGORY_ID
, CATEGORY_NAME
, ASSET_ID
, ASSET_NUMBER
, APR_REVAL_RSV
, REVAL_RSV
, STATUS_CODE
, STATUS
FROM FA.FA_SORP_REVAL_CHK;
FA.FA_SORP_REVAL_CHK does not reference any database object
FA.FA_SORP_REVAL_CHK is referenced by following:
|
|
|