[Home] [Help] [Dependency Information]
Object Name: | FA_SORP_UPG_CAGF |
---|---|
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 | |
ASSET_ID | NUMBER | Asset identification number | ||
ASSET_NUMBER | VARCHAR2 | (50) | Asset Number | |
ASSET_DESCRIPTION | VARCHAR2 | (200) | Asset Description | |
DATE_PLACED_IN_SERVICE | DATE | Date Placed In Service | ||
CATEGORY_NAME | VARCHAR2 | (250) | Category Name | |
CURRENT_COST | NUMBER | Current Cost | ||
DEPRICIATION_RESERVE | NUMBER | Depriciation Reserve | ||
REVALUATION_RESERVE | NUMBER | Revaluation Reserve | ||
IMPAIRMENT_RESERVE | NUMBER | Impairment Reserve | ||
CAPITAL_ADJUSTMENT_ACCT_AMOUNT | NUMBER | Capital Adjustment Balance | ||
GENERAL_FUND_ACCT_AMOUNT | NUMBER | General Fund Balance |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, ASSET_ID
, ASSET_NUMBER
, ASSET_DESCRIPTION
, DATE_PLACED_IN_SERVICE
, CATEGORY_NAME
, CURRENT_COST
, DEPRICIATION_RESERVE
, REVALUATION_RESERVE
, IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT_ACCT_AMOUNT
, GENERAL_FUND_ACCT_AMOUNT
FROM FA.FA_SORP_UPG_CAGF;
FA.FA_SORP_UPG_CAGF does not reference any database object
FA.FA_SORP_UPG_CAGF is referenced by following:
|
|
|