[Home] [Help] [Dependency Information]
Object Name: | FA_SORP_UPG_CAGF_HIST# |
---|---|
Object Type: | VIEW |
Owner: | FA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
ASSET_ID | NUMBER | |||
ASSET_NUMBER | VARCHAR2 | (50) | ||
ASSET_DESCRIPTION | VARCHAR2 | (200) | ||
DATE_PLACED_IN_SERVICE | DATE | |||
CATEGORY_NAME | VARCHAR2 | (250) | ||
CURRENT_COST | NUMBER | |||
DEPRICIATION_RESERVE | NUMBER | |||
REVALUATION_RESERVE | NUMBER | |||
IMPAIRMENT_RESERVE | NUMBER | |||
CAPITAL_ADJUSTMENT_ACCT_AMOUNT | NUMBER | |||
GENERAL_FUND_ACCT_AMOUNT | NUMBER | |||
REQUEST_ID | NUMBER | |||
REPORT_MODE | VARCHAR2 | (10) | ||
PERIOD_NAME | VARCHAR2 | (25) |
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
, REQUEST_ID
, REPORT_MODE
, PERIOD_NAME
FROM FA.FA_SORP_UPG_CAGF_HIST#;
|
|
|